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.
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
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.
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.
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.
PMP Certification Training, 2008
Great training facility. Great instructors. Great experience.
PMP Certification Training, November 2008
Thanks Microtrain for conducting a great PMP course that set me on a successful path to obtain my PMP certification. I have passed the test!
Great class, loved the interaction and team-building exercises. Plenty of materials and learning tools supplied. Although it was a full week's class, never boring. Donna [Russell] was awesome and gave many supporting examples for better understanding.
Connect with MicroTrain
Begin building a successful long-term career pathway.