Access 2016 Intermediate (2 Days)
- This event has passed.
You have the basic skills needed to work with Microsoft® Office AccessTM 2016 databases, including creating and working with Access tables, relationships, queries, forms, and reports. But so far, you have been focusing only on essential database user skills. In this course, you will consider how to maintain data consistency, how to customize database components, and how to share Access data with other applications.
Who is this course for?
Microsoft Office Access 2016: Intermediate is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The Intermediate course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other applications. This course is also a prerequisite to taking more advanced courses in Access 2016.
Pre-requisites
- Microsoft Office Access 2016: Basic
Objectives
Upon successful completion of this course, students will be able to:
- Modify the design and field properties of a table.
- Retrieve data from tables.
- Create flexible queries to display specified records.
- Enhance the capabilities of a form and add graphics.
- Customize reports.
- Share Access data across other applications.
- Use charts and Pivot Tables.
Course Contents
Unit 1: Relational databases
- Database normalization
- Relating tables
- Implementing referential integrity
Unit 2: Related tables
- Lookup fields
- Modifying lookup fields
- Sub datasheets
Unit 3: Complex queries
- Joining tables in queries Calculated fields
- Summarizing and grouping values
Unit 4: Advanced form design
- Adding unbound controls
- Adding Graphics
- Adding calculated values
- Adding combo boxes
- Advanced form types
Unit 5: Reports and printing
- Customized headers and footers
- Adding calculated values
- Printing
- Labels
Unit 6: Charts
- Charts in forms
- Charts in reports
Unit 7: Pivot Tables and Pivot Charts
- Pivot Tables
- Modifying Pivot Tables
- Pivot Charts
- Pivot Table forms