|
Please select the topics that interest you
and
contact us or call
(905) 271 1119
for more information about courses.
 Microsoft
Access - Level 1 Introduction
Topic 1: Overview of
Microsoft
Access
Introduction to Database Concepts and Terminology
Introduction to Access
Database Planning and Design
Topic 2: Creating
Access tables
Examining an Access Table
Creating a Table With the Table Wizard
Creating a Table in Design View
Types of Access Primary Keys
Topic 3: Working with
Microsoft
Access tables
Modifying a Table Using Design View
Finding and Editing Records
Filtering and Sorting Records
Topic 4: Creating and Using Select Queries
Creating a Select Query to View Specific Fields
Specifying Criteria in a Query to View Specific Records
Using Queries to Perform Calculations
Joining Tables in a Query
Topic 5: Creating and Using Forms
Creating a Form With the Form Wizard
Modifying the Form Design
Using a Form to Locate and Organize Information
Multiple-Table Forms
Topic 6: Creating and Using Reports
Creating a Report With the Report Wizard
Creating a Report That Contains Totals
Topic 7: Creating and Maintaining a Database
Creating a Database
Managing a Database and Its Objects
Database Maintenance
Microsoft
Access - Level 2
Topic1: Principles of Table Design
Normalizing Data
Normalizing Data for First, Second and Third Normal Forms
Topic 2: Principles of Table Relationships
Analyzing Table Relationships
Establishing and Testing Referential Integrity
Topic 3: Table Design Techniques
Data Validation Techniques
Indexing Techniques
Topic 4: Designing Select Queries
Using Calculated Fields in Access Queries
Creating Multiple-Table Queries
Topic 5: Customizing Form Designs
Customizing the Form Design
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls
Topic 6: Working with Data Access Pages
Creating Data Access Pages
Integrating with Other Applications
Topic 7: Customizing Reports
Customizing a Report Created by the Report Wizard
Summary Options in Access reports
Working with Subreports
Creating grouping in Access reports
Please
contact us or call 905 271 1119
for more information
on training courses |
