Microsoft Access 2000 MOS

Topics: 8

Length: 22 hours

This course is designed to prepare you for the MOS Access 2000 Core certification exam. It will show you how to create and alter database and tables in Access 2000 as well as showing you how to use Forms, Reports, Filters, importing data and various other advanced tasks.

Topic 1: Creating Databases

Topic 2: Building Tables

This will show you how to create tables, enter text and will give you an understanding of table structures.

Topic 3: Modifying Tables

In this section you will see how to modify tables, the data within tables, and field properties including size, format and default values.

Topic 4: Sorting and Filtering

Including how to find records, sorting records and advanced sorting filtering data and removing filters.

Topic 5: Relationships and Queries

What relationships are, how to define them, perform join operations, displaying related records, specifying query criteria, creating calculated fields and using multi table queries.

Topic 6: Building Forms

In this topic you will see how to build forms, operating in the form design view, using controls and using calculated controls.

Topic 7: Producing Reports

This topic will show you how to produce reports, and add bound and unbound controls to that report as well as working with the reports in the design view.

Topic 8: Advanced Tasks

You will see how to import data, save an object as a webpage, back up, restore and compact an Access Database.