access+courses+in+london - relational db
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+courses+in+london - Relational DB

access+courses+in+london - Relational DB

resolvedResolved · Low Priority · Version Standard

replyReply Wed 23 May 2007, 14:03Delegate Pajam said...

Pajam has attended:
Access Introduction course

Relational DB

How do I creat a Relational DB?

For upcoming training course dates see: Pricing & availability

replyReply Thu 24 May 2007, 16:45Trainer Richard said...

RE: Relational DB

Hi Pajam

Using access to create a relational DB can be a complex series of steps. Essentially you need to create a minimum of two tables and then link them together by a common field using a relationship.

As an example, you might have a suppliers table and a products table. Each supplier provides many products. So the products table would have a suppliers field that would link the product with the supplier.

In principal, that is how it works.

Regards

Richard

 

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



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