Course Overview
This course is designed to teach students intermediate level skills in Microsoft Access 2013. In this course, students will learn to design tables for improved accuracy in data entry, review the various options to share data with other applications, learn about action queries, and review various advanced query techniques. Students will also learn how to automate processes with Macros, advanced form techniques, and advanced report techniques.
Course Objectives
Designing Tables for Improved Accuracy in Data Entry, Sharing Data with Other Applications, Action Queries, Advanced Query Techniques, Automate Processes with Macros, Advanced Form Techniques, Advanced Report Techniques
Agenda
1 - Designing Tables for Improved Accuracy in Data Entry
- Reviewing Table Design Principles
- Setting Default Values and Required Fields
- Restricting Data Entry - Validation Rules
- Restricting Data Entry - Input Masks
2 - Sharing Data with Other Applications
- Exporting Tables and Queries to Excel
- Importing Data from a Text File
- Importing Data from Excel
- Exporting Data to a Text File
- Linking External Data Sources
- Using Word Merge
3 - Action Queries
- What are Action Queries?
- Creating an Update Query
- Creating an Append Query
- Creating a Delete Query
- Creating a Make Table Query
- Changing the Start Number of an AutoNumber Field
4 - Advanced Query Techniques
- Creating Query Joins
- Creating Find Unmatched and Find Duplicate Queries
- Creating Parameter Queries
- Using Like Keyword in Parameter Queries
- Creating a Top X Query
- Reviewing Calculated Query Fields
- Summarizing Query Data with Totals
- Inserting WHERE Statements in a Summary Query
- Creating a Crosstab Query
5 - Automate Processes with Macros
- Understanding Macro Basics
- Creating Macros to Open Forms by Record
- Validating Data Entry with Macros
- Creating a Macro to Automate Data Entry
- Advanced Data Entry Using Macros and DLOOKUP Functions
6 - Advanced Form Techniques
- Using Conditional Formatting
- Organizing Form Fields with a Tab Control
- Creating a Combo Box Control
- Creating an Option Group Control
- Configuring a Combo Box Control to Show Search Results
- Using a Sub-Form to Show Data from a Related Table
7 - Advanced Report Techniques
- Inserting Charts on Reports
- Showing Data In Columns
- Inserting a Sub-Report
- Configuring Reports with Parameter Queries
- Sending Reports
8 - Conclusion
9 - Introduction