creating database

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Creating a database

Creating a database

resolvedResolved · Low Priority · Version 2007

Stefanie has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Creating a database

how to create the primary key?

RE: creating a database

Hello Stefanie
Thank you for your question

Create the table in design mode. Pick the field you want to use as the primary key and right click that field. There is an option to Set primary key. A little key sign should appear next to the fields.

If this resolves your question, please mark it as resolved. If not, please reply with more information.

Kind regards
Cress

Tue 3 Mar 2009: Automatically marked as resolved.


 

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Server loaded in 0.08 secs.