Microsoft Office 2016 Access Level 2
Welcome to the first part of our Microsoft Office Access 2016 courseware. Access is Microsoft’s flagship database application that allows you to create and manage databases for all sorts of different purposes. This new version of Access incorporates a few new features and connectivity options in order to make databases more accessible to the everyday user.
This course is intended to help all novice computer users get up to speed quickly. This manual will also help more experienced users who have little to no experience with Microsoft Access and databases in general.
About this Course
By the end of this course, users should be comfortable with navigating the Access 2016 interface, creating a new database from scratch, querying a database, generating reports, sharing data, and much more. This course is organized into lessons. Each lesson focuses on several key topics, each of which are broken down into easy-to-follow concepts. At the end of each topic, you will be given an activity to complete. At the end of each lesson, we will summarize what has been covered and provide a few review questions for you to answer. Supplemental learning for selected topics is provided in the form of Lesson Labs at the end of this book.
Outline
Lesson 1: Designing a Relational Database
Lesson 2: Organizing a Database for Efficiency
Lesson 3: Querying a Database
Lesson 4: Creating Advanced Queries
Lesson 5: Joining Tables from a Query
Lesson 6: Generating Reports
Lesson 7: Advanced Reporting
Lesson 8: Additional Reporting Options
Prerequisites
This class assumes that the user understands the basics of using a Windows-based computer. Students should be comfortable using the keyboard, mouse, and Start menu. Students should also be comfortable navigating their computer in order to create and manage files and folders. Understanding and experience with printing and using a web browser is an asset, but not required. No previous experience with other versions of Microsoft Access is necessary.
Exam Pass Guarantee
At Microtrain we are committed to your success! Let us show you the return you get from great tech training. We will personally guarantee that if you take our class and follow our program you will be successfully certified!
Raves & Praise
Robert Graf
MCSA
Microtrain presents the course material in an interesting and concise manner. Microtrain gives the student all the resources necessary to pass the certification exams. Both the Chicago and Lombard facilities were excellent, and the staff goes to any length to accommodate any student changes.
Jean S.
PMP Certification Training, Lombard, 2008
I was laid off for many months and not really getting many callbacks for my resume and no job offers. After I put the letters PMP on it, not only did I see an increase in quantity, but also quality of interviews. I had been spinning my wheels for 5 months, and after the PMP went on, I had 2 job offers in 6 weeks. It really was the "golden ticket"
Ron Cwik
PMP Certification Training, 2008
Great training facility. Great instructors. Great experience.
Christopher Fowler
MCSA
Very thorough, good mix of lecture and lab work. Al is great! Keeps classes interesting and supplements required test material with need-to-know items from real world experience.
Kaycee Ekufu
MCSA
The instructor [Al Khalfan] was very knowledgeable in the field. He presented the materials and concepts with a professional touch. He also frequently adds humor to his teachings, which made it easier for me to understand. The support staff was all nice, gentle, caring, and very helpful. The materials, rooms and amenities were excellent and exceeded expected standards.
Connect with MicroTrain
Begin building a successful long-term career pathway.