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!
June 2, 2020. Before Global Information Technology I found myself in a “great job market” with no callbacks on the dozens of applications I submitted to companies all over metro Detroit. I was in a particular bind because I had work experience AND a graduate degree, but all of the offers I received were well [...] Read more
Stephanie Holley
Greetings! I am a currently a student taking courses at Global Information Technology, a company that offers a complete suite of modern, relevant computer software, network and personal computer hardware training. Class sizes are small with extensive hands-on instruction. The company provides instruction in the most up-to-date software and information technologies and teaches using the [...] Read more
Zsombor Zoltan
At college graduation, I thought that a major part of my life was behind me. I would finally get the opportunity to live out life the way I was advised as a child: go to school, get a degree, get a safe and secure job. Unfortunately, I didn’t dare anticipate what was actually ahead of [...] Read more
Steve Johnson
I am writing you this letting in praise of GIT, its wonderful staff and the learning experience I had in my time there. I have been an IT professional for 10+ years but never took the time to obtain any credentials or certifications along the way. When I finally decided it was time to do [...] Read more
De McCadney
I would like to thank you for the great experience I had with the “Java Professional” course taught by our knowledgeable instructor. He was very patient with us when explaining programming concepts that are new to the Java Language. He pointed out topics that will be covered in the Certification exam that will help prepare [...] Read more
Sandy Skrbina