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
Scott Wilson - Team Bradley
Employer Partner Feedback
Dawn has been a pleasure to work with. She is diligent in her efforts to give MicroTrain’s students the best opportunities to connect and network with various companies and players in the job market. The curriculums and certification programs are in line with today’s current IT needs. It’s good to see that they evolve with what employers are most seeking out there. I would recommend to any employer that hires skilled IT workers that they look into MicroTrain’s career services department as a potential source of candidates. The business of hiring can be quite costly, and Dawn and her staff provide a free service to outside companies. This value-add for MicroTrain’s students aligns with their mission in both training and job assistance to set up a win/win scenario for all involved.
David
A Cisco Success Story
I attended a resume writing seminar & conducted mock phone interviews with a Microtrain career counselor. These two activities gave me a leg up on distinguishing myself from all the other people looking for work. Since the career counselor's at Microtrain had a track record of getting people hired, their insight and positive past experiences helped me tremendously in getting hired with a Cisco Voice Systems Integrator in the Chicago area. I was hired as a Cisco Voice Tech Engineer with a starting salary of $65,000 / year with a Cisco voice systems reseller located in the Chicagoland area. Microtrain was very instramental in making this a reality. From expediting my WIA grant, to providing excellent hands-on training from knowledgable instructors I was able to achieve becoming certified with my CCNP. Microtrain's career services was the final catalyst in connecting me with this company by communicating with them on my behalf and with me in setting up the interview. One week later and I was hired. No joke. Thanks Microtrain!
D. Easter
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!
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.
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"
Connect with MicroTrain
Begin building a successful long-term career pathway.