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!
I just wanted to express my feelings about Global Information Technology and their staff. First let me say I have never encountered an organization that cares about the students as much as GIT. After working many years for an automotive supplier in the auto industry I found myself unemployed, without a degree or any certifications [...] Read more
Aubrey Carvine
I was an out of work Engineering Technologist from ford motor. With a strong background in Electrical, Electronics and Mechanical. But no jobs. In this bad economy I was quite depressed and decided to do something about it. When your school was recommended I decided to go there and take a look. I liked what [...] Read more
Heather Berry
While serving in the military I often found myself interested in pursuing a career within IT. Shortly after exiting the military, I started my journey and landed a position as an apprentice with a global consulting firm. I was quickly able to recognize that I was going to need more knowledge than just a web [...] Read more
Brian Cancel
I would like to take this opportunity to show my heart-felt appreciation and my learning experience at Global Information Technology (Global IT). I had recently left the military and was floundering with no real valid prospects and not sure what my next steps would be. I met with a knowledgeable Global IT Career Advisor who [...] Read more
Timothy Taylor
After suffering through unemployment for over a year with a bleak outlook for future employment opportunities in the Criminal Justice field that offered no upward mobility, I made the decision to return to school for some needed updated IT skills and current certifications. I selected Global Information Technology for my updated training. I started my [...] Read more
Randy Schales
866-GO-GIT-GO