Microsoft Office 2000 - Beginning Access

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
240 Minutes

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