microsoft access courses - Query

Resolved · Low Priority · Version Standard

Thu 15 Mar 2007, 15:55 Delegate Sharon said...

Sharon has attended:
Access Intermediate course

Query

How do I create a report?

Fri 16 Mar 2007, 13:04 Trainer Tracy said...

RE: Query

Hi Sharon,

Thanks for the question, once you have opened Access from the Start menu, find the database you wish to create a report on.

On the left hand side there are a list of menus, which start, tables, queries, forms and the next one down is reports. If you click on the report option it will give you the option, create report in Design view, or create report using wizard.

If you follow the wizard it will help you pick what information you want in your report.

Hope that helps

Tracy

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

microsoft access courses - Query

Query

RE: Query

Access articles

Access tip:

Prefixed Autonumbering