Course Information
Course Overview
Learn what Microsoft want you to know for their database certification.
All the training you need to take (and hopefully) pass your Microsoft Office Specialist exam - and one step towards the Master certification.
Most people who use Access are working at Level 1. Why not go all the way to Level 5?
Please note: This course is not affiliated with, endorsed by, or sponsored by Microsoft.
In this course, learn how to:
Create and manage a database, including:
Create and modify databases
Manage relationships and keys
Navigate through a database
Protect and maintain databases
Print and export data
Build tables, including:
Create and manage tables,
Manage records in tables, and
Create and modify fields.
Create queries, including:
Create and modify a query,
Create calculated fields and grouping within queries
Create forms and reports, including:
Create forms and reports,
Configure form and report controls, and
Format forms and reports.
This course teaches all the skills that Microsoft want you to know. Specifically, they are the skills required to undertake the Microsoft Certificate 77-605 (for Access 2007), 77-885 (for Access 2010), 77-424 (for Access 2013) and 77-730 (for Access 2016 Core) and will be useful if you wish to take the exam, or which to learn more about Microsoft Access
The core skills which are taught are those tested by Microsoft in the exam. There are topics that it wants you to learn about Microsoft Access, and this course teaches you all of them.
Each module is taught in order, and is divided in sub-topics, and generally each sub-topic will have an individual lecture lasting 5-7 minutes.
The course will take about 8 hours to complete, plus will you need additional time to test yourselves to ensure that you have learned the necessary skills.
You should take this course if:
you want to learn more about Microsoft Access , or
you want to learn the skills you need to become a certified Microsoft Office Specialist.
Regardless whether you have Access 2007, Access 2010, Access 2013, Access 2016 or Office 365, this course will help you get to a good level, and maybe even want you to get more!
Course Content
- 1 section(s)
- 98 lecture(s)
- Section 1 Introduction
What You’ll Learn
- Create and manage a database
- Build tables
- Create queries
- Create forms
- Create reports
Skills covered in this course
Reviews
-
CChristopher Boorman
You're excel courses were way better. You're going too fast in this one and you seem less prepared. The sound of your typing is loud and distracting.
-
AAnonymized User
Phillip est un excellent formateur : enseignement très progressif et suffisamment détaillé, explications très claires, vidéos courtes mais denses.
-
KKayvan Deldadeh
Philip and his training skill are like the Swiss Army knife. He has professional knowledge in different aspects of IT and the best person to instruct and help with your questions. Please take a look at the courses he teaches and student reviews.
-
CCharlotte Raulston
Excellent presentation of material - learned tricks I did not know, and got the information I was needing to expand my skills.