Microsoft Access 2000 Introduction
| Duration: | 1 day |
| Prerequisite: | Basic knowledge of the windows environment, basic keyboard skills |
| Course Materials: | Course manual with CD containing exercises, 136 pages |
| Prices: | $195 for 1 student (one-on-one training) $160 each for 2 to 3 students $130 each for 4 to 6 students $130 for the first 6 students, $100 for each additional student |
| Description: | This class covers the basic concepts of Microsoft Access 2000 with managing database objects, creating macros and graphic reports, understanding modules, and maintaining databases. The manual is recognized as a Microsoft Approved Study Guide for the Microsoft Office Specialist Program Certification Exam. The manual is also a great reference for after the class. |
Getting Started with Access
Defining Database Software
Learning Database Terminology
Starting Access and Opening a Database
Viewing the database Window
Navigating Records
Entering Records
Editing Records
Previewing and Printing a Database
Getting Help and Exiting Access
Using Tables and Queries
Planning a Database
Creating a Table
Using Table Design View
Formatting a Datasheet
Understanding Sorting, Filtering, and Finding
Sorting Records and Finding Data
Filtering Records
Creating a Query
Using Query Design View
Using Forms
Planning a Form
Creating a Form
Moving and Resizing Controls
Modifying Labels
Modifying Text Boxes
Modifying Tab Order
Entering and Editing Records
Inserting an Image
Using Reports
Planning a Report
Creating a Report
Grouping Records
Changing the Sort Order
Modifying an Expression
Aligning Controls
Formatting Controls
Creating Mailing Labels
Modifying a Relational Database Structure
Examining Relational Databases (Conceptual)
Planning Related Tables (Conceptual)
Creating Related Tables
Defining Text Field Properties
Defining Number and Currency Field Properties
Defining Date/Time and Yes/No Field Properties
Defining Field Validation Properties
Creating One-to-Many Relationships