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 Date | End Date | Time | Day’s | Total 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