MICROSOFT ACCESS

Program Details Program Code:
School: Macmillian Institute of Applied Health Sciences
Credential:Ontario College Certificate
Program Type:
Program Length:
Location: College Campus/Online
Email: macmillianinstitute@gmail.com
Telephone:647-219-4887

DURATION: 45 HRS

COST: $980

Overveiw: Basic: Covers the basic functions and features of Access. Students will learn how to design and create databases; work with tables, fields and records; sort and filter data; and create queries, forms and reports.

Intermediate: Students will learn how to normalize data; work with lookup fields and sub datasheets; create join queries; add objects to forms, print reports and labels.

Advanced: For additional training on advanced Microsoft Access topics, students can continue with the Microsoft Access Advanced course.

PRE-REQUISITES: Computer Fundamentals and Microsoft Key Office Applications

NEXT COURSE START DATES:

Start DateEnd DateTimeDay’sTotal Hrs.
     

Contact us for Next Start Date

COURSE OUTLINE

BASIC

Unit 1: Getting Started

Database Concepts

Exploring the Access Environment and Getting Help

Unit 2: Databases and Tables

Planning and Designing Databases

Exploring and Creating Tables

Unit 3: Fields and Records

Changing the Design of a Table

Finding, Editing and Organizing Records

Unit 4: Data Entry Rules

Setting Field Properties

Working with Input Masks and Setting Validation Rules

Unit 5: Basic Queries

Creating and Using Queries

Modifying Query results and queries

Performing Operations in Queries

Unit 6: Using Forms

Creating Forms, Using Design View and Sorting and Filtering Records

Unit 7: Working with Reports

Reports and Modifying and Printing Reports

INTERMEDIATE

Unit 1: Relational Databases

Database Normalization

Relating Tables and Implementing Referential Integrity

Unit 2: Related Tables

Lookup Fields and Modifying Lookup Fields

Subdatasheets

Unit 3: Complex Queries

Joining Tables in Queries

Calculated Fields and Summarizing and Grouping Values

Unit 4: Advanced from Design

Adding Unbound Controls, Graphics, Calculated Values, Combo Boxes and Form Types

Unit 5: Reports and Printing

Customized Headers and Footers

Adding Calculated Values

Printing and Labels

Unit 6: Charts

Charts in Forms and Reports

Quick Contact