places where i can find beginner help

[dave543212]

hi, i am new to access and got a basic book but i am looking for more resources.

i know exactly what i want to do in this program, i am just trying to get there.

here are some of the things i want to accomplish and haven't been able to find help with yet:

1. i have a table that has a couple of fields, name/address/city/etc. i want to make a form where i can type in a name and click a button and it will search through my table and look for that name and if it's there pull it up with all it's corresponding information.

2. once this information has been pulled up, i want to add a couple of things (what these people are ordering), and have it calculate some things like the total and shipping charges and tax. then i want all this information to save itself in a new table.

so anyway i know there are a bunch of different elements here but if anyone knows some good places to start that would be awesome. or even any basic advice would be appreciated.

 

[willir]

Dave

Regardless of books, I feel one of the most imprtant things to realize with a raltional database is the design. No amount of coding and wizardery will save you if the design is lacking.

Here is some reading to get you started...
Fundamentals of Relational Database Design by Paul Litwin
Download document
Read on-line (HTML)


Micro$oft's answer...
283878 - Description of the database normalization basics
304467 - ACC2000 Defining Relationships Between Tables in a Microsoft Access Database

1. i have a table that has a couple of fields, name/address/city/etc. i want to make a form where i can type in a name...

This is a simple contact database. If you understand the theory, it will be fairly easy.

and click a button and it will search through my table and look for that name and if it's there pull it up with all it's corresponding information.

This task is easy. When you add an unbound combo box to the form, one of the threads of thw combo box wizard will do eactly this.

2. once this information has been pulled up, i want to add a couple of things (what these people are ordering),

This is much more difficult. This is an order/entry system which can simple to very complicated.

If you are going to research things, this may be the topic where to focus on.

...and have it calculate some things like the total and shipping charges and tax. then i want all this information to save itself in a new table.

This is back to the design of your tables.

What is useful to know is that the contact database components are fairly independent of the order / entry system. Perhaps you may want to experiement on the contact databse part and move on after you have a better idea on the order / entry system.

Richard

 

[ZmrAbdulla]

Here is some beautiful tutorials of Access and some other
www.functionx.com

Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[PHV]

And feel free to play with the Northwind database.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[swtrader]

Another good article...

http://www.databasejournal.com/sqletc/article.php/1469521

 

[SQLSister]

YOU might also consider the use of subforms for the information whci will go into your realted table. Subforms can be based on a different query ot table and so are very useful wehn you want to insert or update multiple tables.

But willir is correct, do nothing at all until you read about and understand relational database design. This is critical to the succes of your system.

Questions about posting. See faq183-874
Click here to learn Ways to help with Tsunami Relief