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!
My name is Lesley Goodwin and I work in financial services industry as a Marketing and Communication Manager. Over the past two years, I have exchanged emails with GIT while researching several training options. GIT continued to keep me informed of their class outline and when I learned they could coordinate a class around my [...] Read more
Lesley Goodwin
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
This is just a note of thanks to you and your staff to express how pleased I am with the education I am receiving from Global Information Technology. In March, 2007 I was without employment for the second time within four months. Even though I had a Master of Arts Degree in Education, the lack [...] Read more
Debbie Leveski
First I would like to thank GIT staff for all their support. Before I started at Global Information Technology (GIT). I had no IT experience and I was searching for a career that I enjoyed as well as one that would allow me to raise my two children as a single parent. At the time [...] Read more
Nicole Walker
I wish to express my thanks and gratitude for your expert teaching and support that have helped me transition into a career in information technology. When I began taking classes in August of 2009, I had been unemployed for over a year, and job prospects in the insurance industry were slim. Your staff took the [...] Read more
Marcus Thompson
866-GO-GIT-GO