We're introducing Video on TpT – this is a BETA version. To explore more videos click here.

Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships

Preview (00:30)
Product Rating
Not yet rated
File Type
Duration
14:17
Supporting Document
zip

Be sure that you have an application to open this file type before downloading and/or purchasing.
How to unzip files.

PRODUCT DESCRIPTION

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

SUMMARY: If you wish to prepare students for Microsoft Certification Exam 77-424: Microsoft Office Access 2013 this course will help you teach the skills and knowledge your students need:

This course includes the following in a Zipped file:
• Step-by-step video demonstrations (MP4)
• Companion eBook with detailed instructions (PDF)
• Sample databases and files
• Practice, Quizzes and Skill Test

With this comprehensive, performance-based certification preparation online program, you can teach and validate important business computer skills using Microsoft Access 2013 software. You can teach basic through advanced topics. Upon completion, your students will be prepared to earn their certification and gain an important edge in today's competitive job market.


If you are interested in Microsoft Access, here are some links you might consider:
Microsoft Access 2013 eBooks (PDF, only. No sample files)
Microsoft Access 2013 Advanced

Microsoft Access 2013 Beginning (Includes eBook, Videos and Sample Databases)
Microsoft Access 2013 Beginning: Tables and Table Design
Microsoft Access 2013 Beginning: More Table Design
Microsoft Access 2013 Beginning: Form Design for Real Users
Microsoft Access 2013 Beginning: More Query Design

Microsoft Access 2013 Intermediate (Includes eBook, Videos and Sample Databases)
Microsoft Access 2013 Intermediate: One-from-Many (A Combo Box)
Microsoft Access 2013 Intermediate: Search Form, part 1
Microsoft Access 2013 Intermediate: Search Form, part 2
Microsoft Access 2013 Intermediate: Search Form, part 3
Microsoft Access 2013 Intermediate: Meet the Stars
Microsoft Access 2013 Intermediate: The Opening Scene
Microsoft Access 2013 Intermediate: Report Totals
Microsoft Access 2013 Intermediate: Report Formatting

Microsoft Access 2013 Advanced (Includes eBook, Videos and Sample Databases)
Microsoft Access 2013 Advanced: You Say Goodbye, I Say Hello!
Microsoft Access 2013 Advanced: Relating Tables in a Relational Database
Microsoft Access 2013 Advanced: Tables 2-Primary Keys and Relationships
Microsoft Access 2013 Advanced: The Receipt Form, Part 1
Microsoft Access 2013 Advanced: The Receipt Form, Part 2
Microsoft Access 2013 Advanced: The Receipt Report, Part 1
Microsoft Access 2013 Advanced: The Receipt Report, Part 2
Microsoft Access 2013 Advanced: The Producers
Microsoft Access 2013 Advanced: Prepare to Share
Microsoft Access 2013 Advanced: Strategies for Archiving
Microsoft Access 2013 Advanced: The Performance Network

Other Microsoft Office Lessons on Teachers Pay Teachers
Microsoft Excel 2013
Microsoft Excel 2013 Beginning
Microsoft Excel 2013 Intermediate
Microsoft Excel 2013 Advanced

Microsoft Outlook 2013
Microsoft Outlook 2013

Microsoft PowerPoint 2013
Microsoft PowerPoint 2013 Beginning
Microsoft PowerPoint 2013 Advanced

Microsoft Word 2013
Microsoft Word 2013 Beginning
Microsoft Word 2013 Intermediate
Microsoft Word 2013 Advanced
Total Pages
25
Answer Key
Included
Teaching Duration
1 hour

Average Ratings

N/A
Overall Quality:
N/A
Accuracy:
N/A
Practicality:
N/A
Thoroughness:
N/A
Creativity:
N/A
Clarity:
N/A
Total:
0 ratings
COMMENTS AND RATINGS:
Please log in to post a question.
PRODUCT QUESTIONS AND ANSWERS:
$5.00
Video & Supporting Document
ADD TO CART
User Rating: 3.9/4.0
 (64 Followers)
$5.00
Video & Supporting Document
ADD TO CART