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.

50
NUMBER OF LESSONS
5
LEARNING HOURS
2.5
AUDIO HOURS
 


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

  • 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.


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.

 

GET IN TOUCH