Webinars from Spindustry on SharePoint, MS Teams, and Power BI

Spindustry offers a variety of ways to learn more about solutions to benefit your business. Below is a list of upcoming webinars or pre-recorded sessions that we hope you find helpful.

Five Benefits of Live Instructor Led Training

Five Benefits of Live Instructor Led Training

Experts still agree that there are no viable replacements for having a live professional in the room during training sessions.

Spindustry Training Offers SharePoint Governance Consulting

Avoid costly, time consuming mistakes with your SharePoint installation.

Training partners

Spindustry Training - (515) 334-9556

Bookmark and Share

Microsoft Office Access 2013: Level 2

Course Code: FC2-AC2013
Length: 1 Day
Tuition: $179.00

Schedule for this Course

There are no dates scheduled for this course.
If you would like to be added to the wait list for this class Click Here

Course Description:

Your training and experience using Microsoft® Access® 2013 has given you basic database management skills such as creating tables, designing forms and reports, and building queries. In this course, you will expand your knowledge of relational database design, write advanced queries, structure existing data, share data across applications, and customize reports. Extending your knowledge of Microsoft Access 2013 will result in a robust, functional database for your users.

You can also use this course to prepare for the Microsoft Office Specialist (MOS) Certification exams for Microsoft Access 2013.

Target Student:

This course is designed for students wishing to gain intermediate-level skills or individuals whose job responsibilities include constructing relational databases, performing database maintenance, creating advanced queries and reports, or integrating Access with other programs.


To ensure your success in your course you should have experience working with Microsoft Access 2013, including a working knowledge of database design and creation, form design and creation, report design and creation, a working knowledge of database querying and the various table relationships. You can obtain this level of skill and knowledge by taking the following courses:

  • Microsoft® Office Access® 2013: Level 1

Course Outline:


  • Designing Reports
    • Report Essentials
    • Identifying Report Design Tools
  • Creating Reports Based on Multiple Tables
    • Creating a Report Using the Report Wizard
  • Modifying a Report
    • Working with Report Controls
    • Adding and Deleting Controls
    • Adding a Logo to the Report
    • Adding a Title or Subtitle to a Report
    • Using the Property Sheet
    • Formatting Controls
    • Applying Themes
  • Exploring Other Report Tools
    • Adding Report Sorting and Grouping Levels
    • Adding Date and Time Data to a Report
    • Adding Page Breaks to a Report
  • Printing Reports
    • Setting Report Print Layout
    • Controlling Page Breaks


  • Creating and Modifying Relationships
    • Relationship Types
    • Adding, Deleting, and Modifying Relationships
    • Editing Relationships
  • Modifying Table Structures
    • Renaming Tables and Editing, Adding, and Deleting Table Fields
  • Formatting a Table Datasheet Layout
    • Changing the Width of Columns
    • Moving and Hiding Data Columns
    • Saving a Table Layout
    • Enhancing a Datasheet
  • Setting Field Properties
    • Why Set Field Properties?
    • Set Field Sizes, Captions, and Default Values
    • Custom Text and Memo Field Formats
    • Short Text and Long Text Field Unique Properties
    • Entering Field Properties
    • Formatting Data Using Input Masks
    • Setting Validation Rules
  • Setting Lookup Fields With the Lookup Wizard
    • Examining the Benefits of Lookup Tables
    • Performing a Lookup
    • Creating Lookup Fields for Multiple Values


  • Identifying Complex Form Features
  • Creating a Main Form with a Subform
    • Removing the Layout
    • Connecting Related Tables in Forms
    • Creating a Form with a Subform
    • Identifying the Subform Data Source
    • Formatting the Form and Subform
  • Adding Calculations to Forms
    • Applying Totals to Forms in Datasheet View
    • Creating Calculated Controls
    • Totaling Calculated Subform Fields on a Form
    • Using the Expression Builder
    • Adding the Current Date to a Form


  • Identifying Advanced Query Features
    • Querying Tables Containing No Relationships
  • Creating Select Queries
  • Creating a Calculated Field in a Query
    • Identifying Features of a Calculated Field
    • Adding Totals to Datasheets
    • Creating a Multi-Table Report Based on a Query
  • Creating and Running Parameter Queries
    • Setting Up a Parameter Query
    • Formatting the Criteria Expression
    • Creating Complex Parameter Prompts
  • Creating and Running Action Queries
    • Identifying Action Query Types
    • Identifying Queries by Their Icons
    • Enabling Content
    • Creating a Make Table Query
    • Creating an Append Action Query
    • Creating an Update Query
    • Creating a Delete Query

back to top