access training course - 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 » access training course - Database

access training course - Database

resolvedResolved · Low Priority · Version Standard

Joanna has attended:
Access Introduction course

Database

how do I set up an access database?

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


 

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


Server loaded in 0.08 secs.