ACCESS CHAPTER 5 FORMS AND REPORTS

1
ACCESS CHAPTER 5FORMS AND REPORTS

• Learning Objectives
• Build a simple form
• Add a label, text box, and list controls to a
  form
• Create a multi-table form and subform
• Create a report with report wizard
• Produce a grouped data report
• Design complex multiple-table reports employing
  summary information.

2
ACCESS OBJECTS

• Tables All database information is stored in
  tables comprised of rows (attributes) and columns
  (tuples)
• Queries A question you ask about one or more
  tables in your database
• Forms A simple way to enter, change, or display
  data
• Reports A convenient way to consolidate and
  group information that is stored in a database
  for publication or reporting purposes.

3
ACCESS CHAPTER 5FORMS AND REPORTS
FORMS
REPORTS

• TASK 1. build a simple form
• Exercise 5.1 creating a form from a table
• Exercise 5.2 altering a forms title
• Print the first page of frmMyCustomer
• TASK 2. use a form
• Exercise 5.3 using the order entry form
• Print the order you just entered
• TASK 3. create a multi-table form and subform
• Follow instructions of Exercise 5.4 5.5 and 5.6
  to build an invoice form for Coffee Merchant
• Replace the ItemID on the subform by a combo box
  (ItemID Name) and disable Name and Extended
  Price
• Print the Coffee Merchant Invoice Form
  (frmInvoice2) showing only one record from the
  form view
• Complete Problem 4 on page 255 and print a form
  showing only one record.

TASK 1. create a report with a report
wizard Exercise 5.7 creating a report Exercise
5.8 altering report controls data
alignment Print rptMyEmployee TASK 2. produce
a grouped data report Exercise 5.9 creating a
grouped data report Print the Employee by
Location report TASK 3. build complex
multiple-table reports with expressions
Exercise 5.10 using the report
wizard Exercise 5.11 creating a simple sales
tax calculated control Exercise 5.12 creating a
shipping calculated control Exercise 5.13
aligning and sizing multiple fields Print the
first page of rptInvoice