|
|
|
 
ACCESS 2003
Course Objectives:
To learn the Access 2003
program to Microsoft Office Specialist Level
Course Content:
-
Terminology
used in connection with a database, loading the Microsoft Office
Access program, opening an existing database, navigating around
different objects in a database, using datasheet and design view,
entering a new record, finding records, sorting records
-
Planning
and design of a database, recognising relationships between tables,
defining fields, data types and properties using design view, entering
data into tables using datasheet view, re-sizing columns, using the
Lookup Wizard
-
Defining
relationships, sing the Table Wizard to create a table, modifying the
table design, sing the Input Mask Wizard, sing the Database Wizard to
create a new database
-
Editing
data in form and datasheet views, adding new records, using print
preview, changing page orientation, printing a datasheet, enforcing
referential integrity in a relationship, using the Form Wizard,
working with controls in form design
-
Using
advanced sort, using filter by form, importing a table from an
external database, using a junction table to resolve a many to many
relationship, adding a new field to a form, using a calculated control
on a form, creating a query, using criteria to retrieve selected data,
creating and naming a calculated field in a query
-
Adding
a field with data validation in a table, creating a form with subform,
entering data using a form/subform combination, creating and modifying
the design of a report, adding a subreport to an existing report
-
Exporting
an HTML file, editing an existing web page, creating a data access
page, adding a hyperlink, object dependencies, importing an Excel
spreadsheet as a table, importing a comma delimited text file as a
table, creating a switchboard, backing up a database
Benefits
|
|
