Tutorial 4 Forms and Reports

1
Tutorial 4Forms and Reports

• Review Assignmentpp 4.34 to 4.35

2
Setup

• Use the solution from Tutorial 8
• Save the Travel.bmp from the web site

3
Form Wizard

• Table tblStudent
• Fields all (note order selected affects order
  presented on form)
• Layout Columnar
• Style Sandstone
• Title Student Data

4
Adjust properties

• Open in Design View, set Form Properties
• Scroll bars to neither
• Record Selector to No
• Border Style to dialog
• Min Max Buttons to none
• Adjust width of City and BirthDate fields
• Remove input mask from Recruiter Name
• Where did it come from?

5
Auto Format

• You may want to change the appearance of a form
  after it has been created with the Form Wizard.
• Clicking on the AutoFormat button and then make
  your selection.
• Click the button beside each format to view a
  sample of that particular format.
• Once you have decided on a format, click OK.

6
Modify Data with Form

• Find STO1323
• Change FirstName to Nathaniel, City to Perth,
  BirthDate to 4/2/85
• Find KIE2760
• Delete the record
• Add
• SAN2540, Pedro, Sandes, Barcelona, Spain, 5/1/85,
  M, Todd Wolfe

7
Auto Form 2

• Query Salaries with Raises
• Use Sumi-painting style
• Open in Design View, set Form Properties
• Scroll bars to neither
• Record Selector to No
• Border Style to dialog
• Min Max Buttons to none
• Adjust width of name fields

8
Main/Subform

• You can create a form with a subform on two
  tables that have an established relationship.
• When the relationship between the tables is a
  one-to-many relationship, the main form will
  consist of data from the primary table and the
  subform will consist of data from the related
  table.
• By selecting two related tables in the Form
  Wizard, you can produce a form with a subform.

9
Main/Sub

• Main table tblRecruiter
• Fields FirstName, LastName, SSN
• Subform tblStudent
• All except RecruiterName
• View data by tblRecruiter, use Subform option
• Please use Tabular layout (as opposed to
  datasheet)
• Sumi style
• Titles
• Recruiter Students
• Recruiter Students Subform

10
Adjust properties of Main

• Open in Design View, set Form Properties
• Scroll bars to neither
• Record Selector to No
• Border Style to sizable
• Min Max Buttons to none
• Change caption of subform to Students
• Right-align the labels

11
Adjust Properties of Subform

• Reduce the width of the City and Birthdate
  fields.
• Reduce the width of the form.
• Set the form properties as follows  Scroll bars
  to Vertical Only, Record Selector to Yes

12
Notes about Main/Subforms

• You have two sets of navigation buttons. You can
  navigate the data for either form.
• The outer navigation buttons apply to the main
  form
• The inner navigation buttons apply to the subform

13
Create a report using the Report Wizard

• You can easily create a formatted printout of
  data in table(s) in a database by using the
  Report Wizard.
• The Report Wizard will ask you a series of
  questions to help you format the report.
• Once the report has been created, either with the
  Report Wizard or your own design, you can change
  the design later.
• Choices include grouping and sorting options, as
  well as report layout options.

14
Recruiters and Students Report

• Tables tblRecruiter, tblStudent
• Fields All from tblRecruiter, all from
  tblStudent except RecruiterName
• Order FirstName, Lastname, City, nation,
  BirthDate, Gender, StudentID
• Group by Nation
• Sort by City, ascending
• Align left, formal style

15
Modify Design

• SSN Header
• Nation Header
• Insert Travel image
• Note that the top of the image should be on the
  grid immediately below the top line
• Move the lower bold line to align at the top of
  the SSN Header section.