Microsoft Office 2000 - Beginning Access

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number

---

Overview/Description
To provide an introduction to the core concepts of Microsoft Access 2000 and the skill areas of planning and creating a database, creating tables and forms, and entering and querying data

Target Audience
End-users seeking to become familiar with Microsoft Access 2000; end-users seeking to obtain Microsoft Office Specialist (MOS) certification in the use of Microsoft Access 2000 at Core level

Prerequisites
Some knowledge of basic word processing and computing; familiarity with a Microsoft Windows environment

Expected Duration (hours)
4.0

Lesson Objectives

Microsoft Office 2000 - Beginning Access

define a database and identify database types and structures.

plan the creation of a relational database.

launch Microsoft Access 2000 and operate basic functions on the Access 2000 user interface.

create a database in Access 2000 with or without the Database Wizard.

create a database.

create a table in Access 2000 by using the Table Wizard, the Design view, or by entering data, and set the primary keys.

specify a table's fields and set a primary key.

modify a table's structure, data types, and field properties.

define and modify Lookup fields and input masks.

modify Lookup fields in Access 2000.

define and create a form.

add controls to a form using the Toolbox.

add a text box calculated control on a form, and use a calculated control on a form.

modify the format properties of controls.

format single and multiple control fields.

enter records, use the Office clipboard, and use a subdatasheet.

find, replace, and sort records.

enter and sort data using a form and to sort data using Datasheet view.

define, create, and modify a query, and create a calculated field.

create and specify a query.

print information from an Access database.

Course Number:
111352_eng