This video covers the level of expertise you should have before beginning this cert prep course.
- [Instructor] Who should take this course? This course is custom-tailored to those interested in becoming a Microsoft Certified Access Expert. A certification which verifies the recipient has knowledge of, and competency in, database design principles. This course is for intermediate Access users. While the MOS exam covers basic tasks like creating tables, queries, forms and reports, the main focus of the exam is on intermediate and advanced features of the software. To really get the most out of this course, I recommend learners have at least three to six months of prior experience with Access, and a requisite level of comfort creating and working with tables, queries, forms and reports. We will branch off of this knowledge to learn more about table relationships, data entry forms, multi-level reports, and multi-table queries. If you fit this criteria and are ready to prepare for the Microsoft Certified Access Expert exam, let's get rolling.
- Modifying the database structure
- Managing table relationships and keys
- Exporting data
- Managing records and fields
- Creating and running queries
- Configuring form controls
- Modifying form positioning
- Grouping report fields
- Formatting reports
- Taking the practice exam
Skill Level Intermediate
1. Microsoft Office Specialist (MOS) Exam Overview
2. Managing Databases
3. Create and Modify Tables
4. Create and Modify Queries
5. Modify Forms in Layout View
6. Modify Reports in Layout View
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.