access+course+training - how many microsoft access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access+course+training - How many Microsoft Access database table do I need

access+course+training - How many Microsoft Access database table do I need

resolvedResolved · Low Priority · Version Standard

replyReply Fri 27 Jul 2007, 15:18Delegate Dave said...

Dave has attended:
No courses

How many Microsoft Access database table do I need

Hi,

I am creating a ordering system using a Microsoft Access database. I have got stuck and could really use some advise on how many Microsoft Access database tables I need to use. Currently I have have all the customer information set up in Microsoft Access database tables and now I need to implement the ordering Microsoft Access Database tables.

Thanks for the help

Dave

For upcoming training course dates see: Pricing & availability

replyReply Fri 27 Jul 2007, 16:13Trainer David said...

RE: How many Microsoft Access database table do I need

Hi Dave

For a basic implementation in a Microsoft Access database, you will need 3 tables:

A customer table
An order table
An order item table

If you have all these tables within your Microsoft Access database you should have no problem implementing you ording system within a Microsoft Access database system.

Hope this helps

David

 

Access tip:

Space marks

It is good practice not i to have space marks for field names as this can lead to problems when using queries or VBA code. It is much better to use an underscore charcter to represent spaces in field names

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard