Home » Microsoft Access » 10 - Reports and Data Access Pages
10

Creating a Report

Michael is now well-versed with basic MS Access concepts, such as tables, forms, and queries. His next step is to build a report.

To build the Emergency Contact report:

  1. Go to report tab.
  2. Click New > Report Wizard.
  3. Select qy: empapp
  4. Click OK.
  5. Select the fields and move them over to selected fields.

  1. MS Access will ask you if you want to add any groupings. For this particular report, we will not add any groupings.
  2. Click Next.

  1. To sort by employee’s last name and then first name, select emp_lname on field#1, and select emp_fname on field #2.

  1. Select tabular layout for your report in landscapeview
  2. Click OK.

  1. Select Corporate style for the report.

  1. Type ‘emergency contact information’ as the title for your report.

Discuss this in the forums

< Prev
|
Next >