Formats: 4-hour virtual course | 1-day instructor-led onsite
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.
Learning Objectives »
- Provide input validation features to promote the entry of quality data into a database
- Organize for efficiency and performance
- Improve the usability of Access tables
- Create advanced queries
- Use advanced formatting and controls
- Use advanced formatting and calculated fields
Course Agenda »
Promoting Quality Data Input
- Restrict Data Input Through Field Validation
- Restrict Data Input Through Forms and Record Validation
Improving Efficiency and Data Integrity
- Data Normalization
- Associate Unrelated Tables
- Enforce Referential Integrity
Improving Table Usability
- Create Lookups Within a Table
- Work with Subdatasheets
Creating Advanced Queries
- Create Query Joins
- Create Subqueries
- Summarize Data
Improving Form Presentation
- Apply Conditional Formatting
- Create Tab Pages with Subforms and Other Controls
Creating Advanced Reports
- Apply Advanced Formatting to a Report
- Add a Calculated Field to a Report
- Control Pagination and Print Quality
- Add a Chart to a Report