Description

Demonstrate your mastery of Access by becoming a Microsoft Office Specialist (MOS). Get training for the Access Expert certification exams for Office 365 and Office 2019.

Tags

Syllabus

Syllabus IntroductionProve your Access skills with a MOS certificationWho should take this course?About the exercise filesAbout the challenges1. Microsoft Office Specialist (MOS) Exam OverviewThe different kinds of Microsoft Office Specialist certificationsPrepare for the test and review learning objectivesOverview of the Access Expert—Office 365 and Office 2019—exam format2. Managing DatabasesModify database structureManage table relationships and keysEnforce referential integrityPrint and export data✓ Challenge: Create and manage a database✓ Solution: Create and manage a database3. Create and Modify TablesCreate tablesManage tablesManage table recordsManage fieldsAdd validation rules and input masks✓ Challenge: Create and modify tables✓ Solution: Create and modify tables4. Create and Modify QueriesCreate and run a queryCreate a crosstab queryCreate an action queryCreate a basic parameter queryModify a query✓ Challenge: Create queries✓ Solution: Create queries5. Modify Forms in Layout ViewConfigure form controlsModify tab order on forms and sort by fieldModify form positioningInsert information in form headers and footers✓ Challenge: Create forms✓ Solution: Create forms6. Modify Reports in Layout ViewGroup and sort fields on reportsFormat reportsAdd and modify labels on reportsFormat a report into multiple columns✓ Challenge: Create reports✓ Solution: Create reports7. Final Practice Exam✓ Challenge: Full-length practice exam✓ Solution: Full-length practice examConclusionNext steps Read more