Duration
1 day
Overview
This level covers more advanced Access techniques, including securing the database and customizing the program to fit the way you work.
Course Objective
- Managing and maintaining databases
- ability to back up, split, compact, and repair a database
- encrypt a database by using a password
- set database options and properties
- identify object dependencies
- print database information
- Presenting and sharing data
- import data or link to external data
- export data from tables and queries
- reset or refresh table links
Lesson 1: Advanced Queries
- Create Crosstab Queries
- Create a Subquery
- Save a Filter as a Query
- Create an Append Query
- Create a Make Table Query
- Create an Update Query
- Create a Delete Query
- Create a Join
- Create a Calculated Query Field
- Create an Aggregated Query
- Use Arithmetic and Logical Operators to Group Data
Lesson 2: Displaying and Sharing Data
- Create a Chart
- Change Chart Options
- Change Format Options
- Refresh Data in a Chart
- Change Chart Types
- Save a Database Object as Another File Type
- Print a Database Object
Lesson 3: Importing a 14 nd Exporting Data
- Import Data from Excel
- Import Table Data from Another Access Database
- Link to an External Data Source
- Save Import Specifications
- Run Import Specifications
- Export from a Table to Excel and Other Formats
- Export from a Query to Word
- Save Export Specifications
- Run Export Specifications
Lesson 4: Database Tools
- Back Up a Database
- Save as a Previous Version
- Compact and Repair a Database
- Save a Database as a Template
- Merge Databases
- Set Database Properties
- Encrypt and Decrypt a Database
- Configure Database Options
- Identify Object Dependencies
- Use the Database Documenter
- Split a Database
Programme scope, delivery arrangements and suitability are confirmed during enquiry.