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

access

ResolvedVersion Standard

Mangai has attended:
Access Introduction course

Access

Would we be able to include email addresses into tables

RE: access

Hi Mangai, Thank you for your post, In response to your question, yes it is possible to include email addresses in a table, create the field using the hyperlink option and when inserting data into the datasheet click the Hyperlink button on the toolbar or use the keyboard command Ctrl+K to open your hyperlink options, choose email address and then enter information as required in the dialog box. I hope that helps, best regards Pete.

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.11 secs.