Programming & Development

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.

Course Outline:

Topic A: Create Lookups Within a Table
Topic B: Work with Subdatasheets
Topic A: Create Query Joins
Topic B: Create Subqueries
Topic C: Summarize Data
Topic A: Apply Conditional Formatting
Topic B: Create Tab Pages with Sub forms and Other Controls
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
Topic A: Import and Link Data
Topic B: Export Data
Topic C: Create a Mail Merge
Topic A: Create Action Queries
Topic B: Create Unmatched and Duplicate Queries
Topic A: Create Sub reports
Topic B: Create a Navigation Form
Topic C: Show Details in Sub forms and Popup Forms
Topic A: Create a Standalone Macro to Automate Repetitive Tasks
Topic B: Create a Macro to Program a User Interface Component
Topic C: Restrict Records by Using a Condition
Topic D: Create a Data Macro
Topic A: Getting Started with VBA
Topic B: Using VBA with Form Controls
Topic A: Back Up a Database
Topic B: Manage Performance Issues
Topic C: Document a Database
Topic A: Split a Database for Multiple-User Access
Topic B: Implement Security
Topic C: Convert an Access Database to an ACCDE File
Topic D: Package a Database with a Digital Signature

Enroll in this course


Need Help Finding The Right Training Solution?

Our training advisors are here for you.