In our Access training courses, students will learn how to take control of their data. This course will teach the advanced features of Access.
- Advanced Form Design Techniques
- Using Switchboards to Navigate Database Objects
- Designing Macros to Automate Database Tasks
- Introduction into Access Visual Basic for Complex Automation
- Linking Tables to Ensure Database Security
- Customizing Database Options
- Designing Complex Forms
- Creating “Keystroke-less” field controls
- Adding Buttons and Drop-Down Lists for Navigation
- Create a Main Switchboard
- Design a Reports Switchboard
- Create Macros to Open and Close Database Objects
- Using Message Boxes to Inform Users
- Automate Parameter Queries with Macros
- View Related Records in Another Form with Macros
- Hiding/Un-Hiding Field Controls with Macros
- Use Macros to Validate Data Entry
- Use Visual Basic to Secure Forms with Passwords
- Create User Input Boxes
- Use Logic Programming to Interpret Conditions
- Place Tables in a Separate Database
- Manage Tables with the Linked Table Manager
- Set Startup Options
- Applying the Compact and Repair Tool
“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.”
