fbpx

Microsoft Access 2013

Block
Program
Accounting
Course Aim
To provide an understanding of Microsoft Access that goes beyond the basics, in order to create and manage databases.
Of Interest To
Those who are already familiar with Microsoft Access, and who want to learn more advanced techniques for creating, using, and managing relational databases.
Method of Delivery
Integrated Learning™ System (ILSPlus) training facilitated by Academy of Learning Career College facilitators.

Course Introduction

The Microsoft Access course (contains Access 2010 and Access 2013) teaches students the fundamentals of the Microsoft Access 2010 application.

In this course, students examine database objects and learn to manage data in a database. They learn to sort and filter data, display and format data, and use simple queries to retrieve data. Students learn to create and modify databases and tables, and work with simple forms and reports.

Students accomplish the learning objectives for each module through a series of hands-on tasks, for which they are given step-by-step instructions and desired result checkpoints. The tasks provide ample opportunity for students to practice, apply, and develop the skills covered in the course.

A practice exercise and review questions are included at the end of each module to measure progress and reinforce the skills learned. There is also a lab exercise at the end of the course to provide further practice and review to reinforce the topics learned throughout the course, and to help prepare students for the exam.


Course Prerequisites

Introduction to Windows course, or equivalent.


Course Notes

Course manual is provided for on-going reference. There is a final exam upon completion of the course. Participants who receive 75% or higher on their exam will receive a certificate.

Course Breakdown

Access 2010 Level 1:

  • Lesson 1:

Introduction to Microsoft Access; What are Access Database Objects and File Types?; Starting and Exiting the Application; Exploring the Access Application Window; Completing Dialog Boxes; Opening and Closing a Database; Getting Help While You Work

  • Lesson 2:

Examining Database Objects; Looking at Other Objects; Grouping Database Objects; Managing Data; Editing Data in Datasheet View

  • Lesson 3:

Creating a Database; Creating Tables; Setting Field Properties; Lookup Fields and Indexes; Modifying Tables and Fields

  • Lesson 4:

Sorting and Filtering Data; Displaying and Formatting Data; Using Queries to Retrieve Data; Finding Duplicates and Creating a Query in Design View

  • Lesson 5:

Understanding and Creating Forms; Using the Form Wizard; Modifying and Customizing Forms; Using Form Layout and Design Tools; Formatting and Modifying Form Properties

  • Lesson 6:

Understanding Reports; Creating a Report; Using the Report Wizard; Using the Label Wizard; Understanding the Layout and Design Views; Using the Ribbon’s Report Layout Tools; Using the Ribbon’s Report Design Tools; Formatting Reports and Modifying Report Properties; Printing a Report

  • Lab Exercise

Access 2010 Level 2:

  • Lesson 1:

Understanding Database Relationships; Defining a Database Relationship; Viewing Existing Relationships; Viewing Data in Related Tables and Enforcing Referential Integrity; Modifying Table Design

  • Lesson 2:

Selecting Data from Tables; Calculating Fields; Understanding Joins; Finding Unmatched Records; Creating Parameter Queries; Creating Action Queries; Summarizing and Grouping Data; Creating a Crosstab Query; Optimizing a Query

  • Lesson 3:

Creating Advanced Forms; Naming Controls, Applying Conditional Formatting, and Changing the Tab Order; Using Advanced Controls; Creating and Modifying a Subform; Creating a Switchboard Form; Modifying a Switchboard Form

  • Lesson 4:

Creating Complex Reports; Embedding Objects in a Report, Applying Conditional Formatting, and Using the Find Command; Working with Subreports; Charting Data; Creating PivotTables and PivotCharts

  • Lesson 5:

Importing Data; Linking Data from an External Source; Exporting and Merging; Saving Database Objects and Databases; Data Collection; Introducing Microsoft SharePoint

  • Lesson 6:

Creating and Using Macros; Working with Macros; Maintaining a Database; Splitting a Database and Error Checking; Optimizing and Documenting a Database

  • Lab Exercise

Access 2013 Level 1:

  • Lesson 1:

Defining Access Databases; Exploring the Access Environment; Introducing Objects and Exiting

  • Lesson 2:

Designing and Normalizing; Linking Tables; Creating Tables; Retrieving Data

  • Lesson 3:

Form Design and Creation; Modifying Form Controls; Printing and Using Help; Modifying Form Layout

  • Lesson 4:

Creating Select Queries; Setting Query Criteria; Sorting and Performing Calculations; Creating Special Types of Queries

  • Lesson 5:

Designing Reports; Modifying Reports; Exploring Other Report Tools; Printing Reports

  • Exam Preparation Exercises
  • Glossary

Access 2013 Level 2:

  • Lesson 1:

Creating and Modifying Relationships; Modifying Table Structures; Formatting A Table Datasheet Layout; Setting Field Properties; Setting Lookup Fields With the Lookup Wizard

  • Lesson 2:

Creating a Main Form with a Subform; Adding Calculations to Forms; Setting Properties to Assist and Control Data Entry

  • Lesson 3:

Identifying Advanced Query Features; Creating a Calculated Field in a Query; Creating and Running Parameter Queries; Creating and Running Action Queries

  • Lesson 4:

Customizing Reports; Adding a Subreport to a Main Report; Creating a Report from a Subreport; Numbering Items in a Report; Creating Calculated Controls on a Subreport; Setting Page Breaks and Customizing Controls; Analyzing Report Performance

  • Lesson 5:

Set Access Options; Splitting a Database; Customizing the Database Interface

  • Lesson 6:

Converting Files; Attaching Files; Integrating Word; Integrating Access on the Excel; Displaying Access Data on the Web

  • Lesson 7:

Improving and Maintaining; Database Objects; Analyzing and Documenting; Compacting and Repairing; Database Security; Cloud Storage; Creating Macros

  • Exam Preparation Exercises
  • Glossary