Question Newbie here, want to learn more advanced Access 2003

[^_^]

Hello everyone, please to have found this forum.
I've got a friend that from time to time comes visit my office and use this superb program to make my life easier, He's amazing, built me application with access that I think will cost thousands of dollars if it wasn't for me.

Now, he's really busy, and I always wanted to learn use Access myself.
I've watched tutorials in Youtube and learn alot. but I feel I can't progress further... I know Access is amazing, but I can't find more tuts to help me..

What I need now is to build an application that will help me manage my warehouse, not very complicated, but every time I start working on my DB i get stuck on some level..

My question is, is there a chance I will tell you guys how to do something and could help me figure how to?

I will really really really appreciate it

 

[pbaldy]

Welcome to the site. That's what we're here for! I will say that specific questions get better responses than "how do I build an application for such-and-such?"

Your first task is to determine the tables and fields needed, with an eye towards normalization. Table design is the foundation the application is built on.

 

[^_^]

Hello there! thanks for the reply.
I just wanted to know if thats okay....

This is where I'm stuck.
I've created a table of the products with this columns -> pid, itemname, quantity, quantity type, division.
for quantity type and division i've created another tables and linked them.
(Quantity type is "unit, meters, galons..." and division is "paint, plumbing, electricity..."

Everything here is all right.

also created table customers (which will be only one) and Givers (which is only me)

Now is the problem, I want to make a form that will allow me to manage the products given and after every session will print a report that will list the customer, the giver, and the products (item name, division, quantity, quantity type) given.
also I need it to automatically update the quantity in the products table (if i've given the customer 10 units of a certain product it will automatically reduced the quantity in the table).

I can't figure how to make this, I've tried reading tutorials but can't get this right..

Please help me, I really want to learn how to do this.

btw, sorry for my english...

thanks again.

 

[Mr. B]

Before you go any further, go back to your table and remove any spaces from the Field names. I would suggest that you use "Camel" case. For example: your field named "pid" would be come ProductId; your field named "itemname" would become "ItemName"; your field named "quantity type" would become "QuantityType", etc.

Next, think about how your tables are going to need to be related to each other and create the appropriate field for each table along with primary keys and then create foreign keys in the appropriate tables so you can link the data correctly. When you think you have it down like you want it, run it by the group here and let them look it over and help you with you database structure first.

Do this before you start to worry about designing any forms, etc.

 

[^_^]

Hey thanks for the tip...
I learned all the basics for Access, But I feel I can't progress further, I know to to something like I described in my previous post I need to use VBA, but I don't have a clue where to start

 

[pbaldy]

Generally speaking, you would not want to store quantity on hand. You would have a transaction table, and calculate quantity on hand from transactions (number in minus number out). One advantage to that is that you can calculate inventory at any point in time.

It's dinner time for me, so off I go!

 

[^_^]

basically, i understand what you told me...

What i really want to learn is how to create a form like I described above, is there any tutorial you can forward me to.

I believe in my self that I can learn, but need the right assistant...

thanks again.