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

microsoft access courses in london - table

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access courses in london - Table

microsoft access courses in london - Table

ResolvedVersion Standard

Mark has attended:
Access Intermediate course

Table

How do I create a table?

RE: table

Mark,

You can create a table by selecting the TABLE tab onthe left of the database window. There are Three options:

Create table by:
- entering data
- using the wizard
- in design view

You can choose how to start off. If you are new to tables, try using the wizard to get the basics going. All the technical settings are located in the design view.

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

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.13 secs.