Access 2016 - Part 2
Duration
2 Days
Price
330,00 €
Course Type
Virtual / Physical
Your training and experience using Microsoft® Office Access® has given you basic database management skills, such as creating tables, designing forms and reports, and building queries. 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.
Microsoft® Office Access® 2016 - Part 2 focuses on optimization of an Access database, including optimizing performance and normalizing data; data validation; usability; and advanced queries, forms, and reports.
Learning Objectives
In this course, you will optimize an Access 2016 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.
-
-
-
Course Outline
1 - PROMOTING QUALITY DATA INPUT
- Topic A: Restrict Data Input Through Field Validation
- Topic B: Restrict Data Input Through Forms and Record Validation
2 - IMPROVING EFFICIENCY AND DATA INTEGRITY
- Topic A: Data Normalization
- Topic B: Associate Unrelated Tables
- Topic C: Enforce Referential Integrity
3 - IMPROVING TABLE USABILITY
- Topic A: Create Lookups Within a Table
- Topic B: Work with Subdatasheets
4 - CREATING ADVANCED QUERIES
- Topic A: Create Query Joins
- Topic B: Create Subqueries
- Topic C: Summarize Data
5 - IMPROVING FORM PRESENTATION
- Topic A: Apply Conditional Formatting
- Topic B: Create Tab Pages with Subforms and Other Controls
6 - CREATING ADVANCED REPORTS
- Topic A: Apply Advanced Formatting to a Report
- Topic B: Add a Calculated Field to a Report
- Topic C: Control Pagination and Print Quality
- Topic D: Add a Chart to a Report
Target Audience
This course is designed for students looking to establish a foundational understanding of Microsoft Office Access 2016, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.