In our Access training courses, students will learn how to take control of their data. This course will teach the intermediate features of Access.
- How Table Relationships Affect Queries
- Controlling Query Results with Join Types
- Creating Complex Queries with Multiple Criteria
- Calculating Data with Queries
- Automating Queries with Parameters
- Using Query Wizards
- Exploring Action Queries
- Advanced Report Design Techniques
- Creating Relationships Between Tables
- Add Relationship Security
- How Relationships Affect Query Results
- Using Join-Types to Affect Query Results
- Applying Wildcards
- Using And / Or Conditions
- Create Custom Fields with Calculations
- Summarize Data with Grouping
- Creating Automated Requests for Criteria
- Using Wildcards in Parameter Queries
- Using Range Operators in Parameter Queries
- Getting Non-Matching Records with the Un-Matched Query Wizard
- Finding Duplicate Records with the Duplicate Query Wizard
- Create Tables with a Make-Table Query
- Add Records to a Table with an Append Query
- Change Data with an Update Query
- Delete Data with a Delete Query
- Understanding Report Control Types
- Grouping Report Data
- Summarizing Report Data
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”
The ability to work with and analyze data is critical to the success of your organization. For decades, Microsoft Excel has been the go-to application for doing so. Begin adding it to your professional skill set with our foundational Excel course. You will learn to navigate the application confidently while creating and developing worksheets and workbooks that employ the most popular features Excel has to offer.
DETAILED COURSE OUTLINE
Getting Started with Access
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help and Configure Options in Microsoft Access
Working with Table Data
- Modify Table Data
- Sort and Filter Records
Querying a Database
- Create Basic Queries
- Sort and Filter Data in a Query
- Perform Calculations in a query
Using Forms
- Create Basic Access Forms
- Work with Data on Access Forms
Generating Reports
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports
“Our outlines are a guide to the content covered on a typical class. We may change or alter the course topics to meet the objectives of a particular class.”
