Access 2013 Basic Advanced Expert E-Learning + Book

Book Access 2013 Basic Advanced Expert E-Learning + Book

Follow this unique E-Learning course Microsoft Access 2013. You will have 24/7 access to a virtual Office Cloud environment with rich interactive videos, speech, subtitles, practical assignments with real-time analysis of your answers for 365 days. After you have passed 70% of the course you will receive a certificate of participation by e-mail. This course has been developed by MOS Master teachers with more than 27 years of experience. This allows you to use this course to prepare yourself for the Microsoft Office Specialist MOS exam Access 2013.  

Course content:

Basic:

What you need to know about: The Ribbon and Quick Access Toolbar
Open a database
Database objects
Create records
Access to records
Change field values
Search for a record
Replace field value
Delete records
Sort records quickly
Print Preview
Print margins and orientation
Run a query

Expert:

Table structure in datasheet view
Table structure in design view
Check field entries
Input mask
Create a list box
Create lists of data from another table
Copy and move controls
Align controls
Section height
Create / delete a line or rectangle
Determine control dimensions
Text formatting controls
Align text controls
Appearance controls
Conditional formatting
Copy formatting
Group / Ungroup controls
Page numbering
Insert pictures
Themes
Sort order associated with report
Group records in report
Manage groups when printing
Labels for mailings
Total fields in queries
Statistical calculations without grouping
Statistical calculations with grouping
Grouping certain records
Parameter queries
Query Unrelated Records
Query Duplicate Records
Crosstab query