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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
reports

ResolvedVersion 2003

Lucy has attended:
Access Introduction course

Reports

What is a report?

RE: Reports

Hi Lucy

A report is an object generated by Access to display data from a table or query in a printable format.

You can edit and set up the report as required in the design view and when perfected, every time it's run you can create a printed copy of the data for distribution.

Hope this helps

Carlos

Mon 15 Dec 2008: Automatically marked as resolved.

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