Microsoft Access 2013 Advanced: Many-to-Many Relationships
Microsoft Access 2013 Advanced: Many-to-Many Relationships
This is an introduction to the lessons in the Access 2013 Advanced programming.

Please review our Microsoft Access lessons available on TES and download the zipped files that include eBook (PDF), video (MP4) and sample files.

An overview of our Microsoft Access lessons available on TES:
1. Representing many-to-many relationship with a Table and Subdatasheet.
2. Using Primary Keys to create Relationships between Tables.
3. Creating a blank Form and adding buttons to open Forms and Reports.
4. Finding common errors in Forms and Queries and correcting the mistakes.
5. Calculating Totals in a Report

Another Computer Mama Guide: www.thecomputermama.com

If you wish to prepare for Certification Exam 77-424: Microsoft Office Access 2013 this course will help you build the skills and knowledge you need. Please review our Microsoft Access lessons available on TES and download the zipped files that include eBook (PDF), video (MP4) and sample files.
• Step-by-step video demonstrations
• Companion eBook with detailed instructions
• Sample databases
• Practice, Quizzes and Skill Test


In Microsoft Access, you’ll cover basic through advanced topics, including:
• Learn how to navigate the online course and submit your assignments
• Understand the purpose of Tables and how they are used in a database
• Edit the Form Properties to help Users navigate the Form Fields and enter data
• Learn how to design Queries and use Queries to lookup records in the Tables
• Use Query Criteria and Parameter Queries to select specific records in the Tables
• Learn how to design and modify Reports in Layout and Design Views
• Learn how to manage Database files: Save and Save As

The Microsoft Access 2013 Certification Training Program is part of the Microsoft Business Certification program: Microsoft Office Specialist (MOS). MOS certification is the globally recognized standard for validating expertise with the Microsoft Office 2013 suite. Students who wish to prepare for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 will find beginning through advanced lessons that demonstrate these required MOS topics.

This course teaches the objectives for the following certification tests:
Expert Certification:
Access® 2013: Exam 77-424

Free

Save for later
  • Access2013_Adv_Hello.pdf

About this resource

Info

Created: Aug 18, 2016

Updated: Feb 22, 2018

E-book

pdf, 6 MB

Access2013_Adv_Hello

Report a problem