setting up database
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 » Setting up a database

Setting up a database

resolvedResolved · Low Priority · Version 2003

replyReply Thu 20 May 2010, 15:57Delegate Antonia said...

Antonia has attended:
Access Introduction course

Setting up a database

This is probably a really stupid question, but I want to set up a database of people, their contact details, car reg, children, which committees they're on and which groups they're in. What is the best way to link all these tables - would an auto number be the best plan? Or something else?

For upcoming training course dates see: Pricing & availability

replyReply Fri 4 Jun 2010, 10:35Trainer Jacob said...

RE: Setting up a database

Hi Antonia

Thank you for your recent post. Database design and structure needs to be carefully considered and we wouldn't be able to give you a well informed response at this stage.

We do assist clients with similar requests by reviewing their databases or if at an earlier stage helping to create the structure of the database to fit the design parameters.

This type of work due to it's nature falls beyond the scope of the forum and is more consultative. If you would like to know more on how we can assist please let me know.

Kind regards

Jacob

Thu 10 Jun 2010: Automatically marked as resolved.

 

Please browse our web site to find out more about
microsoft access advanced training and other Microsoft training courses.

Access tip:

Create calculated fields that work out your age

You can uset eh year function to work out the year from NOW function and then subtract it with your date of birth type field

Age=Year(Now( ))-Year([DoB])

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