Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships
Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships
Project: Create several Tables with Primary and Foreign Keys

Advanced Access Objectives
1. Identify the levels of database design: First, Second and Third Normal Form.
2. Create Tables in Design View that have Primary and Foreign Keys.
3. Create Tables that do not have repeating groups: Third Normal Form.
4. Document the Relationships.
5. Edit the Joins between Tables to ensure Data Integrity and Enforce Referential Integrity

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.
• Step-by-step video demonstrations
• Companion eBook with detailed instructions
• Sample databases
• Practice, Quizzes and Skill Test

All materials for this program are available online.

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
$5.00
Save for later
  • Access2013_Adv_Table2.pdf
  • 2013_Access_Adv_Table2_Video.zip

About this resource

Info

Created: Aug 18, 2016

Updated: Feb 22, 2018

E-book

pdf, 11 MB

Access2013_Adv_Table2

Project/Activity

zip, 73 MB

2013_Access_Adv_Table2_Video

Report a problem