classnotes week04

Walter’s Teaching
Pages

Class Notes – Week 04

Homepage ] Office Hours ] Class Listings ] Lab Schedule ] Student Login ] Some interesting links ]


A Form is an object that you use to maintain, view, and
print records in a database. – Pg. 4.02

The Form Wizard allows you to choose some or all of
the fields in a selected table or query in allowing you to create a form.

FORM WIZARD EXAMPLE – pg. 4.03 – 4.05

AutoFormat – a predefined style for a form or report. –
Pg. 4.05

CHANGE A AUTOFORMAT Style

Navigating a Form – Pg. 4.07

Finding Data – Pg. 4.08

Find using Wild Cards – Pg. 4.09

Wild Card table – pg. 4.10

Skip Previewing and Printing records from a form.

Maintaining Data using a Form – Pg. 4.12

  • Changing
    data
  • Deleting
    data – Pg. 4.13
  • Adding
    data

Creating Sub-Forms in another Form – Pg. 4.15

        
a relationship must exist between the two sources of the forms

        
EXMPLE – pg. 4.15 to 4.18

Creating a Report using a Report Wizard – Pg. 4.18

Start with a sketched out design of what is needed

Detail Record – a set of field values for each
record – Pg. 4.18

Report Wizard Example – Pg. 4.19-4.27

Inserting a Picture into a report. – Pg. 4.27

Converting an Access 2000 database into a previous version.
– Pg. 4.32

 


Copyright ©2001-2002, Walter Wimberly – Instructor and all
’round Cool Guy – IADT