R3,800
Microsoft Office Access 2016 Advanced
Candidates will learn specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports and maintaining a database .
Essentials training
1. SQL and Microsoft Access
- Importing Information
- Exporting Information
- Copying o and from Other Office Programs
2. Using the SELECT Statement
- Selecting All Data
- Selecting Specific Data
- Selecting Conditional Data
- Using the ORDER BY Statement
3. Using SQL Joins
- Creating Simple Joins
- Using an Alias
- Sorting Joins
- Creating Outer Joins
4. Using Subqueries
- What is a Subquery?
- Creating a Subquery
- Subqueries with Aggregate Functions and Nested Subqueries
- Using the IN Keyword with Subqueries
5. Advanced Form Tasks, Part One
- Limiting User Access to a Form
- Creating Checkboxes and Command Buttons
- Building Command Button Events
- Creating Event Procedures
6. Advanced Form Tasks, Part Two
- Using Hyperlinks in a Form
- Adding Links to Other Database Objects
- Inserting a Mailto Link in a Form
- Adding a Browser Control to a Form
- Performing Calculations in a Form
7. Advanced Form Tasks, Part Three
- Exporting Your Form to XML
- Exporting a Form as a Word Document
- Exporting a Form as HTML
- Sending a Form as an E-mail Attachment
- Exporting a Form to Other Formats
8. Creating Split Forms
- Creating a Split Form
- Splitting an Existing Form
- Using a Split Form
- Fixing the Form Separator
9.Using Digital Signatures
- What is a Digital Signature?
- Obtaining a Digital Signature
- Attaching Your Signature to a Database
- Extract and Use a Signed Database
10. Using the Trust Center
- Opening the Trust Center
- Trusting a Database
- Configuring Macro Security
- Customizing the Message Bar
11. Managing COM Add-ins
- Viewing Add-ins
- Opening the Add-in Manager
- Installing Add-ins
- Disabling All Add-ins
- Uninstalling Add-ins
12. Customizing Access
- Changing User Information
- Changing the Office Background and Theme
- Setting the Default Database Type and Location
Course Days: 1 Day