access training course - Database

Resolved · Low Priority · Version Standard

Wed 28 Feb 2007, 09:50 Delegate Joanna said...

Joanna has attended:
Access Introduction course

Database

how do I set up an access database?

Wed 28 Feb 2007, 12:38 Trainer David said...

Creating a Microsoft Access Database

Hi Joanna

I trust that you found your MS Access course very informative today, by now I assume that you have already been taught how to create your Microsoft Access Database. However just a quick recap.

You need to open a blank MS Access database and go into design view, whilst in design view, you can enter row by row the details of each column you want in your database along with the data type and description when this is done, change views and you should have you database. It will ask you to save it first though.

Hope this helps

David

Training courses

	98.7 % recommend us
	More live stats...

Training information:

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