Membership Benefits include Free Unlimited Access to All Project Management, Business Skills,
IT Service Management,
IT Networking and Cyber Security Online Training Series and more. Become a Member
Training Series Overview
This training series covers the intermediate functions and features of Access 2013. Students will learn about designing a relational database, joining tables and advanced reporting. They will also learn how to organize a database for efficiency and share data across applications.
In high-growth industries, entry-level employees who hold a Microsoft Office Specialist (MOS) certification can earn up to $16,000 more, annually, than their peers.Five times as many high-growth/high-salary positions require experience with Office than all non-Microsoft software skills combined. Twenty-nine percent of tomorrow’s high-growth/high-wage positions require Office or Office-related skills.
Series Taught By:
Office 2013 combines cloud and web technologies to extend the way you create and consume information and introduces a new cloud app model for you to build secure and flexible apps—all discoverable from the familiar Office interface. There are no prerequisites for the Microsoft Office Specialist 2013 certification.
Certification Exam Details:
This training will prepare you for the Microsoft Office Specialist Certification. To learn more, please go to
Certiport for certification details.
Does this training qualify for college credits?
Yes! This course series does qualify for college credits to be applied towards a degree program offered at American Business and Technology University.
Available CEUs for Course Series Completion: 5
Students can earn up to 5 CEUs for fully completing this course series. This information will be displayed on the certificate of completion.
Access Training Courses Below
Click any of the titles below to launch your videos:
Course 01 - Designing a Relational DatabaseAccess Now - No Membership Required
Topic A: Relational Database Design
Topic B: Create a Table
Demo 01 - Analyzing the Relational DB Design Process
Topic C: Create Table Relationships
Demo 01 - Creating a Table Relationship
Course 02 - Joining Tables
Topic A: Modify Table Data
Demo 01 - Creating Inner and Outer Joins
Topic B: Join Tables That Have No Common Fields
Demo 01 - Joining Unrelated Tables
Topic C: Create Lookups
Demo 01 - Creating a Self Join
Topic D: Work with Subdatasheets
Demo 01 - Modifying Data in a Subdatasheet
Topic E:Create Subqueries
Demo 01 - Creating Subqueries
Course 03 - Organizing a Database for Efficiency
Topic A: Data Normalization
Demo 01 - Running the Table Analyzer Wizard
Topic B: Create a Junction Table
Demo 01 - Creating a Many-to-Many Relationship
Topic C: Improve Table Structure
Demo 01 - Improving Table Structure
Course 04 - Sharing Data Across Applications
Topic A: Import Data into Access
Demo 01 - Importing Data from a Text File
Demo 02 - Importing Data from an Excel File
Topic B: Export Data to Text File Formats
Demo 01 - Exporting Data to Text File Formats
Topic C: Export Access Data to Excel
Demo 01 - Exporting Data to Excel
Topic D: Create a Mail Merge
Demo 01 - Merging Access Data with a Word Document
Course 05 - Advanced Reporting
Topic A: Organize Report Information
Demo 01 - Making Report Design Modifications
Topic B: Format Reports
Demo 01 - Formatting a Report
Topic C: Include Control Formatting in a Report
Demo 01 - Adding Data Bars to a Report
Topic D: Add a Calculated Field to a Report
Demo 01 - Adding a Calculated Field to a Report
Topic E: Add a Subreport to an Existing Report
Demo 01 - Adding a Subreport to an Existing Report
Training Final Exam
Are you ready to earn your certificate of completion? If so, Launch the Final Exam below to do so now!