MENU

Microsoft Access

Program Code: COM # IT
School: MacMillian Institute of Applied Health Sciences
Credential: Ontario College Certificate
Program Type:
Program Length:45hrs
Location: College Campus/Online
COST: $ 380
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 Advanced Program
PRE-REQUISITES: Computer Fundamentals and Microsoft Key Office Applications
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 Table
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