Microsoft Access 2013 or 2016 - Level 2 - Intermediate

Office Applications/Productivity
Delivery Type (Must Select One)
  Online Live Instructor-Led
  A+ Test Voucher ($390) - Set of 2 - $195 Each
  A+ Practice Exam ($70.00)
  IT Online Library (1 Year Subscription - $1595.00)
If quantity is more than 1, Please add all Attendees' Names /Voucher #/ Learning Credit below separated with a comma. If not specified, we will contact you prior to the class start date. Special Instructions
This hands-on intermediate course is suitable for Access 2010/2013/2016 users.
Live face-to-face instructor-led training. No minimum class size - all classes guaranteed to run.
On this course you will extend your knowledge of Access by building a more complex database, working with external data, running more advanced queries, building more complex forms and generating detailed reports.

Advanced Record Tasks
  • Showing Totals
  • Adding from Outlook
  • Saving a Record as an Outlook Contact
  • Adjust Row Height
  • Hiding and Un-hiding Fields
  • Freezing and Unfreezing Fields
  • Formatting Text

Adding Data Fields
  • Adding Rich Text and Long Text Fields
  • Adding Attachment Fields
  • Adding Hyperlink Fields
  • Adding Lookup & Relationship Fields
  • Adding Calculated Fields

Advanced Field Tasks
  • Adjusting the Field Size/Width
  • Setting Field Default Value
  • Working with More Fields
  • Working with Field Validation Options
  • Using the Field List

Working in Table Design View
  • Opening Design View
  • Working with Field Properties
  • Setting the Primary Key
  • Using the Properties Sheet
  • Working with Table Properties
  • Viewing Table Relationships
  • Using Relationship Tools
  • Viewing Object Dependencies

Working with External Data
  • Linking Data
  • Importing Data
  • Using the Table Analyzer
  • Refreshing Data
  • Exporting Data

Creating Queries
  • Creating a Select Query
  • Creating a Make Table Query
  • Creating an Append Query
  • Creating a Cross Tab Query
  • Showing and Removing Tables

Creating Forms and Reports
  • Creating a Form with the Form Wizard
  • Creating a Report with the Report Wizard
  • Modifying Form Layout
  • Navigating the Field List
  • Key Features on the Form Tools Tabs
  • Key Features on the Report Tools Tabs

Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.

Certificate of Course Completion

This hands-on intermediate course is suitable for Access 2010/2013/2016 users.

You should have completed our Introduction class or have a basic knowledge of Microsoft Access prior to attending.

You may cancel this class 10 or more business days prior to the start date of the class for a full refund. No shows or cancellations made within 10 days will forfeit all fees paid.