[Lynda.com / Jennifer McBee] Cert Prep: Access 2016 Microsoft Office Specialist (77-730) [2017, ENG] + Sub (Eng)

Содержание

00 - Introduction
Welcome
Who should take this course
Using the exercise files
Using the challenge files
01 - Microsoft Office Specialist (MOS) Exam Overview
The different kinds of Microsoft Office Specialist certifications
Prepare for the test
Overview of the 2016 MOS exam format and learning objectives
02 - Create and Manage a Database
Create and modify databases
Manage relationships and keys
Navigate through a database
Maintain databases
Print and export data
Challenge: Create and manage a database
Solution: Create and manage a database
03 - Build Tables
Manage tables
Manage records in tables
Modify fields
Validation and masks
Challenge: Build tables
Solution: Build tables
04 - Create Queries
Create and run a query
Create a crosstab query
Create an action query
Create a parameter query
Modify a query
Create calculated fields and grouping within queries
Challenge: Create queries
Solution: Create queries
05 - Create Forms
Create a form
Configure form controls
Add subforms
Format a form
Challenge: Create forms
Solution: Create forms
06 - Create Reports
Create a report
Configure report controls
Format a report
Add a calculated field
Challenge: Create reports
Solution: Create reports
07 - Final Practice Exam
Challenge: Full-length practice exam
Solution: Full-length practice exam
08 - Conclusion
Next steps
Exercise Files

Скриншоты