Overview
-
Prepare for the Microsoft Office Specialist Access 2013 exam and use the challenge files included in the course to practice your Access skills.
Syllabus
-
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Using the challenges
- Compare the Microsoft Office Specialist certifications
- Prepare for the exam
- Review the exam objectives and format
- Create a new database
- Set up the primary key
- Manage relationships
- Navigate through a database
- Protect and maintain a database
- Save and export a database
- Challenge: Create a database
- Solution: Create a database
- Create a new table
- Format a table
- Manage records
- Create and modify fields
- Challenge: Build tables
- Solution: Build tables
- Work with simple select queries
- Create multi-table queries
- Create crosstab queries
- Modify a query
- Utilize calculated fields and group within a query
- Challenge: Create queries
- Solution: Create queries
- Create basic forms
- Create navigation forms and split forms
- Set form controls
- Format forms
- Challenge: Create a form
- Solution: Create a form
- Create a report
- Set report controls
- Format a report
- Challenge: Create a report
- Solution: Create a report
- Challenge: Full-length practice exam
- Solution: Full-length practice exam
- Next steps
