Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Creating a database

Resolved · Low Priority · Version 2007

Reply Mon 23 Feb 2009, 16:46Delegate Stefanie said...

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

Creating a database

how to create the primary key?

For upcoming training course dates see: Pricing & availability

Reply Tue 24 Feb 2009, 20:56Trainer Cress said...

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 articles

· Microsoft Access Mistakes to Avoid
· Express Yourself With Microsoft Access
· Innovation with Microsoft Access
· It's so easy to Access the information you need
· Data validation in MS Access

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

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips