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 would like to take this opportunity to thank the entire team for providing the training and resources needed to get my career in Information Technology (IT) off to a great start. Having experienced a variety of jobs previously – including a stint as a Mortgage Officer for a large local Bank, and my prior [...] Read more
Garrett Mason
I was a Computer Technician with a major Corporation for 33 years when organization downsizing impacted my career. After 33 years, it was hard to fathom unemployment not to mention what to do next. I was angry, frustrated, and upset! After a few calming days of contemplation and a few weeks of unsuccessful job searches, [...] Read more
David Gough
Dear Manish: I wanted to also take this opportunity to thank you, and the Staff at Global IT. You and your staff all really changed my life. I know you all know my story and where I came from and where I am now. If it were not for how you conduct classes, and the [...] Read more
Bradley Freeland
I am writing this letter with the utmost sincerest appreciation, respect and regard for the staff and faculty at Global Information Technology. Words cannot express the gratitude I have for everything you have done for me. When I began at GIT, I was unsure about a few things: the means to reach my goal and [...] Read more
William Dicks
866-GO-GIT-GO