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 - Level 2
 

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


Course Overview
In the Using Microsoft Office Access Level 2 course, the student will learn how to plan, design and create a database; create and modify tables; create more advanced queries, forms and reports; attach a macro to a button on a form; link to external data; join tables; import and export data; and use mail merge.
 

Plan and Design a Relational Database Build a Relational Database
Create a Database File
Create the Database Tables
Assign Primary Key Fields
Set Field Properties
Modify Fields
Assign Table Relationships

Forms
Create a form using AutoForm
Create a form using the Form Wizard
Create a Relational Form
Set Form Properties
Create a Combo Box Control
Create a Calculated Control

Queries
Review Select Queries
Create a Parameter Query
Create a Calculated Field
Perform Calculations on a Group of Records
Create a Make Table Query

Reports
Create a Multi-level grouping Report with Subtotals and Grand Total

Macros
Create a Macro to Automate Tasks
Attach a Macro to a Button on a Form
 

Import, Export and Link Data
Import and Export Data
Link to External Data
Join Tables

 

Mail Merge
Merge data with documents

 

Back to Class Schedule