1012C Wilson Point Road
Middle River, Md. 21220
410-574-2234

Your only phone call for all of your computer needs!
     

Home

 

Computer News
     

YES!
We Can Fix It!

We Cater to Computer Cowards!
Let us clean your windows and empty your trash

No Need to Fear!
OnSite is Here!

Microsoft Access 2003 - Level 1
Course Length: 6 hours (9 a.m. - 4 p.m.)
Prerequisites: Microsoft Windows


Course Overview
Microsoft Office Access is a relational database management system that helps you store and retrieve information in a database. In the Using Microsoft Office Access Level 1 course, you will learn about database concepts and terminology and how to create and use an Access database. You will enter, edit, sort, filter and print data in tables; create custom views; and build and modify queries, forms and reports.
 

 Database Concepts & Terminology
Database Concepts
Access Terminology

Getting Started with Access
Startup Access
Open a Database
View Database Objects
View Table Relationships

Create a Database

Working with Tables
Open a Table
Navigate Records
Select Records and Fields
Customize Datasheet View
Enter and Edit Data
Sort and Filter Records
Create a Table
Modify a Table 

 

Using the Help System

Working with Forms
Open a Form
Navigate Records and Fields
Enter and Edit Data
Create a Form using Form Wizard
Modify the Form Design
Work with Form Controls

Working with Queries
Create a Query (Query Wizard)
Create a Query in Design View
Modify the Query Design
Run a Query
Using And/Or with Selection Criteria
Query Multiple Tables

Working with Reports
Create a Report (Report Wizard)
Modify the Report Design
Working with Report Controls
Preview and Print a Report

Back to Class Schedule