Pre-Requisites: Windows 10, MS Access 2016 Basic
This course provides the fundamental knowledge and techniques needed to advance to more technical Access responsibilities, such as creating and maintaining new databases and their various objects. Students will learn how to maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2016 with other applications.
A relational database application such as Microsoft® Access™ 2016 can help you and your organization collect and manage large amounts of data. Access is a versatile tool. You can use it as a personal data management tool (for your use alone), or you can use it as a construction set to develop applications for an entire department or organization. In this course, you will learn how to use Access 2013 to manage your data, including creating a new database; constructing tables; designing reports; and creating queries to join, filter, sort data, and much more.
Microsoft Access® 2016- Part 2
Designing a Relational Database
Joining Tables
Using Data Validation
Creating Advanced Queries
Organizing a Database for Efficiency
Using Advanced Reporting Techniques
Real testimonials from our Students!
In mid-2012, I was at a cross-road in my life after being informed that the position I held for over 11 years was being eliminated. I realized then that my skills needed to be updated to take me into a new line of work. That’s when I met one of your career advisors at Detroit [...] Read more
Deb Lasko
As a United States Army veteran, I participated in four (4) combat tours and a tour of duty to South Korea. I am a three (3) time veteran of Iraq, serving in various capacities in Operation Iraqi Freedom (OIF) I, III and Operation New Dawn (OND) which ended the war in Iraq in December 2011. [...] Read more
Christopher B. Amara, Jr.
US Army Veteran
Dear Global Information Technology: If it were not for you my future in Information Technology would be completely uncertain. My name is Meontre and before Global IT I was working low paying side computer repair jobs and retail computer/computer part sales. During that time in my life I learned some minor basic computer stuff but [...] Read more
Meontre Byrd
My name is Tiffanie Bradley; I was a Mainframe Programmer Analyst by profession and was laid off from Compuware Corporation in 2004. I have been in the Information Technology (IT) field for over 15 years and have experienced a successful career. Upon being laid off and seeking further employment, I recognized that my skills were [...] Read more
Tiffanie Bradley
My name is Willie M. Williams, I became unemployed after nine years of service to one of the big three companies in April 2009. The majority of my department (ISS) was terminated indefinitely. I thought to myself, ok, I’ll just find another job in the IT field because I knew I had a Master’s degree [...] Read more
Willie M. Williams
866-GO-GIT-GO