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!
After being laid-off and getting frustrated looking for work in the current market with outdated AS/400 and Mainframe skills, I decided to visit a few training providers to investigate some tech training to upgrade my skills set. The third one I visited was Global Information Technology. My first impression was very positive. The representative’s passionate [...] Read more
David Hamel
I started training at Global I.T. in January of 2002 with the Web Pro course, then after successfully completing that course, I elected to take the Java Pro. I liked my instructors because they were always willing to help before and after class, as well as by appointment. The material was good because it explained [...] Read more
Lisa Majewski
I’d just like to thank Global IT for getting my career back on track. Before joining your school I was at a major crossroads in my life; I had depleted my unemployment benefits and was deciding on which direction to take my career. The economy was making companies close their doors and companies which did [...] Read more
Daniel Vitale
I was fortunate to meet Manish, the Director of Global-IT, and started to discuss classes that would assist me with Project Management, as a Training Consultant. My experience has been nothing but positive, but also, confidence building. My instructor was phenomenal who taught my PMP course. He not only is available any time, but is [...] Read more
Soraya Meri
This is an great day to say the educational experience has given me and my family an ultimate way knowing how lives can change through information as well as information technology. I don’t really have much to say on this matter because the challenges, the grinding work effort was a part of my personality since [...] Read more
Dell Williams