B.C.'s Energy College

Apply Now
WFTR551 - Microsoft Access Level 2 - Building Productivity
Course Code:
WFTR 551

Calendar Description:
Microsoft® Office Access – Level 2 teaches students how to use advanced commands to work with forms, reports, designing tables, manipulating queries, as well as using subforms or subreports. It is designed for computer users who are familiar with Access and now want to explore some of the intermediate to advanced skill sets.

Date First Offered:

Total Hours: 18
Seminars and Tutorials: 18

Total Weeks:

This course is offered online:


WFTR 531 MicroSoft Access Level 1 or permission of CE/WFTR Coordinator

Non-Course Pre-Requisites:


Rearticulation Submission:

Course Content:
Unit 1: Working with Forms
- What is a Form?
- Creating a Form
- Using Forms
- Creating and Modifying a Form in Layout View
- Creating and Modifying a Form in Design View
- Creating Datasheet Forms
- Creating Multiple Items Forms
- Creating Split Forms
- Creating PivotTable Forms
Unit 2: Working with Reports
- What is a Report?
- Creating a Report using the Report Tool
- Creating a Report using the Report Wizard
- Creating and Modifying Reports in Layout View
- Creating and Modifying Reports in Design View
- Print Preview and Print Reports
- Exporting as PDF or XPS Format
- Creating Mailing Labels
Unit 3: Advanced Table Design
- Advanced Field Properties
- Using Lookup Fields
- Linking Tables
Unit 4: Advanced Queries
- Select Queries from Multiple Tables
- Adding and Removing Tables from Queries
- Inner and Outer Joins
- Specialized Select Queries
- Summary Queries
- Action Queries
- Create Subqueries
- Queries from Filters
Unit 5: Advanced Forms and Reports
- Features of Forms and Reports
Unit 6: Customizing Forms and Report
- Working with Properties
- Using Unbound and Bound Controls
- Applying Images
- Using List Boxes and Combo Boxes
- Using Check Boxes
- Using Option Groups
Unit 7: Using Subforms and Subreports
- Creating Subforms and Subreports
- Exporting to HTML

Learning Outcomes:
Upon successful completion of this course, the student will be able to:

- Create one-to-one, one-to-many and many-to-many relationships
- Use the table analyzer
- Perform maintenance on databases
- Identify object dependencies
- Open a database exclusively or with shared access
- Use the Database Documenter
- Create a form using the Form tool or the Form wizard
- Create a form in design or layout view
- Add, move, resize, delete, formatting, space, anchor or group controls
- Creating datasheet forms, multiple item forms, split forms, and PivotTable forms
- Create a report using the Report Tool and Report Wizard
- Modify a report in design or layout view
- Print and preview forms and reports
- Create mailing labels
- Use input masks, validation rules, or indexed fields
- Use the lookup wizard or create lookup fields manually
- Work with query joins
- Create parameter, unique, unmatched and duplicate select queries
- Create summary, action, and sub queries
- Use embedded macros in forms or reports
- Create and modify charts
- Create a subform or subreport using the wizard or the subform/subreport tool

Grading System:

Passing Grade:

Grading Weight:
Quizzes and Tests: 24 %
Assignments: 21 %
Project: 50 %
Participation: 5 %

Number of Assignments:

Nature of Participation:

Percentage of Individual Work:

Course Offered in Other Programs:

Additional Comments:
This course has a project that takes a minimum of 40 hours to complete outside of class hours.

Completion of this course partially prepares students to write the Microsoft Certified Application Specialist exam. By completing the other levels available for this application students will have reviewed all of the exam objectives.

Text Books:

Required - Microsoft, 2008, Microsoft Office Access 2007, Level 2 - Building Productivity (CCI Learning Solutions Inc.). Chapters Covered: All
Home   |   About NLC   |   Admissions   |   Programs   |   Services   |   Student Life   |   News & Events   |   Contact Us