Access 2003: Introduction      

Code:

 CT11-330

Series:

 Desktop Applications

Duration:

 1 day
Getting started
Database concepts
Exploring the Access environment
Getting help
Closing a database and Access

Databases and tables
Planning and designing databases
Exploring tables
Creating tables

Fields and records
Changing the design of a table
Finding and editing records
Organizing records

Data entry rules
Setting field properties
Working with input masks
Setting validation rules
Using indexes		 Simple queries
Creating and using queries
Modifying query results and queries
Performing operations in queries

Using forms
Creating forms
Using the Form Wizard
Using Design view
Finding, sorting, and filtering records

Working with reports
Creating reports
Modifying and printing reports

Appendix A: MOS exam objectives map
Comprehensive exam objectives

Access 2003: Introduction


After completing this course, students will know how to:

  • Organize data efficiently by using a database management system; start Access and open Access databases; and use the Help feature.
  • Plan and create a database; use Datasheet view and Design view; and create tables and work in tables.
  • Modify a table’s design; use the Find feature and the spelling checker; and sort, filter, and delete records.
  • Set field properties; create input masks; set validation rules; and create single- and multiple-field indexes.
  • Create queries, and sort and filter the results; modify queries; and perform operations in queries.
  • Create, modify, and work with forms; and use them to find, sort, and filter records.
  • Create reports by using AutoReport, the Report Wizard, Design view, and queries; and modify and print reports.

Prerequisites:


Windows 2000: Basic or equivalent experience