Access – Part 1
Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.
Course Objectives
In this course, you will create and manage an Access database. You will: Navigate within the Access application environment, create a simple database, and customize Access configuration options. Organize and manage data stored within Access tables. Use queries to join, sort, and filter data from different tables. Use forms to make it easier to view, access, and input data. Create and format custom reports.
Delivery Methods: Virtual Instructor Led Training
Course Duration: 2 days (8:00AM - 4:00PM)
Intended Audience: This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.
Access – Part 2
In this course, you will expand your knowledge of relational database design; promote quality input from users; improve database efficiency and promote data integrity; and implement advanced features in tables, queries, forms, and reports. Extending your knowledge of Access will result in a robust, functional database for your users. Focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Course Objectives:
In this course, you will optimize an Access database. You will: Provide input validation features to promote the entry of quality data into a database. Organize a database for efficiency and performance, and to maintain data integrity. Improve the usability of Access tables. Create advanced queries to join and summarize data. Use advanced formatting and controls to improve form presentation. Use advanced formatting and calculated fields to improve reports.
Delivery Methods: Virtual Instructor Led Training
Course Duration: 2 Days (8:00AM - 4:00PM)
Intended Audience: Students taking this course are database administrators or prospective database administrators who have experience working with Access 2016 and need to learn advanced skills.
This course is also designed for students who are preparing for the Microsoft® Office Specialist certification and who want to prepare for the Microsoft Office Access 2016 Exam #77-730.