Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database
Microsoft Access 2013 Advanced: Tables 1- Tables in a Relational Database
Project: Create a Table and use the Primary Key to create a relationship to an existing Table

Advanced Access Objectives
1. Define the Primary Key in a new Table
2. Add a Foreign Key to a Table
3. Use the Primary Keys to create Relationships between Tables
4. Add a Subdatasheet and format the Tables to Show/Hide and Freeze the Columns in Datasheet View

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_Table1.pdf
  • 2013_Access_Adv_Table1_Video.zip

About this resource

Info

Created: Aug 18, 2016

Updated: Feb 22, 2018

E-book

pdf, 14 MB

Access2013_Adv_Table1

Project/Activity

zip, 73 MB

2013_Access_Adv_Table1_Video

Report a problem