Access 2013

What does this course offer you?

In this elearning course, you will learn how to effectively use Microsoft Access 2013 for both your individual needs and for the development of complex business solutions. You will gain an introduction to the planning of databases, structuring data and the creation of the required tables. You define data types, field properties and relationships between your different tables. Furthermore, you get to know how to set filters, create queries for evaluation and will learn how to simplify data input and maintenance via forms and create professional reports.

What does this course include?

In addition to the instructional content, practice exercises and test questions are also included.


Course Topics

  • What is a database?
  • Structure of a database
  • Starting and exiting Access
  • The Access application window
  • Opening a database
  • Creating a database

  • Planning a database
  • Tables and data fields
  • Creating a table in the design view
  • Defining field properties
  • Using the input mask
  • Using the output format
  • Creating a validation rule
  • Assigning an index
  • Defining lookup list

  • Entering and editing data in a table
  • Copying data between programs
  • Changing the datasheet view
  • Sorting data records
  • Finding and replacing data

  • Basics of relationships
  • Referential integrity
  • Setting up and deleting relationships
  • Showing dependent data

  • What are filters?
  • Using operators
  • Using selection-based filters
  • Using form-based filters
  • Saving form-based filters

  • What are queries?
  • Creating simple queries with the wizard
  • Creating select queries in the design view
  • Editing a query
  • Queries for table creating and deletion

  • Creating AutoForms
  • Creating forms with the wizard
  • Editing forms in the layout view
  • Entering and editing text

  • Creating basic reports
  • Creating reports with the wizard
  • The print preview
  • Printing and exporting data

Technical Specifications


  • Windows XP / Vista / 7 / 8
  • Internet Explorer 7 / 8 / 9* / 10* /11*
  • Firefox 10 or higher
  • “Script ActiveX controls marked safe for scripting” must be enabled

* In Internet Explorer 8 and higher, the Internet Explorer 7 "Compatibility Mode" is used to guarantee the optimal display of course content.

Office E-Learning Course Features:

  • Designed for Beginners, Experienced Users and Upgraders
  • Structured Video Tutorials
  • Audio Narrated Videos with Closed-Captioning
  • Practice Interactive Exercises
  • Topics Include Tips and Printable PDF's
  • Pretest with Personalized Learning Path
  • Chapter Tests
  • Comprehensive Final Test with Certificate
  • Deliverable as a SCORM package to host on your own LMS
  • Accessible online though our Course Platform service
  • Tin Can/xAPI Compatible
  • Available in Different Languages
  • Flexible Pricing Options


Interested in Pricing?

To receive pricing information for our MS Office and Windows E-Learning courses, please send us a Quotation Request and we will be touch with you shortly.

Receive a Quote ›



About Us

EXPAND Global provides learning technologies and content for the next generation workplace. We are experts in innovative learning tools, eLearning content development, off-the-shelf eLearning for Microsoft Office, microlearning, mobile learning, gamification and performance support.