Access 2000 Basic
Explore the Access environment, create a database, add tables, create queries,
forms and reports.
Recommended Preparation: Ability to navigate in Windows
environment.
Register for
a class
Personalized training and consulting is available upon
request.
Lesson 1: Database Concepts
- Database concepts and terminology
- Starting with Access
- Access environment
- Planning and designing databases
- Getting help
- Closing a database and Access
Lesson 2: Access Basics
- Exploring tables and forms
- Exploring queries
- Exploring reports
Lesson 3: Creating Databases
- Creating a database
- Using the table wizard
- Working in design view
Lesson 4: Working with Fields and Records
- Changing the design of a table
- Adding and deleting records
- Finding and editing records
- Sorting and filtering records
|
Lesson 5: Querying Tables
- Viewing specific fields
- Modifying query results and queries
- Calculations in queries
Lesson 6: Creating and Using Forms
- Creating forms by using AutoForm
- Using the form wizard
- Using design view
Lesson 7: Creating and Using Reports
- Using the report wizard
- Using reports to perform calculations
|
