Microsoft® Access for Intermediate & Advanced Level - TED Learning

This 2-day intermediate/advanced Microsoft Access training course is suitable for those with a basic working knowledge of Microsoft Access. It is designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features. On completion you will be able to understand relational databases and work with related tables. You will learn how to generate much more complicated queries and create more advanced forms and reports before tackling Macros.

At the end of the course, participants should be able to:

• Import, link and export tables
• Work with advanced table properties
• Use advanced select queries and create crosstab queries and charts, as well as use action queries
• Design forms and use subforms
• Create simple macros
• Design Microsoft Access reports

LESSON 1: CONTROLLING DATA ENTRY

1. Restrict Data Entry Using Field Properties
2. Establish a Pattern for Entering Field Values
3. Create a List of Values for a Field

LESSON 2: JOINING TABLES

1. Create Query Joins
2. Join Unrelated Tables
3. Relate Data Within a Table

LESSON 3: CREATING FLEXIBLE QUERIES

1. Set Select Query Properties
2. Create Parameter Queries
3. Create Action Queries

LESSON 4: IMPROVING FORMS

1. Design a Form Layout
2. Enhance the Appearance of a Form
3. Restrict Data Entry in Forms
4. Add a Command Button to a Form
5. Create a Subform

LESSON 5: CUSTOMIZING REPORTS

1. Organize Report Information
2. Format the Report
3. Set Report Control Properties
4. Control Report Pagination
5. Summarize Report Information
6. Add a Subreport to an Existing Report
7. Create a Mailing Label Report

LESSON 6: SHARING DATA ACROSS APPLICATIONS

1. Import Data into Access
2. Export Data
3. Analyze Access Data in Excel
4. Export Data to a Text File
5. Merge Access Data with a Word Document

LESSON 7: USING DATABASES ON THE INTERNET

1. Creating a Hyperlink
2. Exporting a Form to HTML
3. Creating a Data Access Page
4. Grouping a Data Access Page
5. Sorting and Grouping Data on a Data Access Page

LESSON 8: AUTOMATING TASKS

1. Creating an AutoKeys Macro
2. Using Controls to Run a Macro
3. Assigning a Macro to an Event
4. Assigning a Macro to a Condition
5. Testing and Debugging a Macro

LESSON 9: USING DATABASE TOOLS

1. Setting, Modifying, Deleting a Database Password
2. Encrypting and Decrypting a Database
3. Replicating a Database
4. Splitting a Database
5. Converting a Database
6. Setting Startup Options

This 2-day intermediate/advanced Microsoft Access training course is suitable for those with a basic working knowledge of Microsoft Access. It is designed for those users who wish to step up their current knowledge of Microsoft Access to take advantage of the more complex features. On completion you will be able to understand relational databases and work with related tables. You will learn how to generate much more complicated queries and create more advanced forms and reports before tackling Macros.

At the end of the course, participants should be able to:

• Import, link and export tables
• Work with advanced table properties
• Use advanced select queries and create crosstab queries and charts, as well as use action queries
• Design forms and use subforms
• Create simple macros
• Design Microsoft Access reports

LESSON 1: CONTROLLING DATA ENTRY

1. Restrict Data Entry Using Field Properties
2. Establish a Pattern for Entering Field Values
3. Create a List of Values for a Field

LESSON 2: JOINING TABLES

1. Create Query Joins
2. Join Unrelated Tables
3. Relate Data Within a Table

LESSON 3: CREATING FLEXIBLE QUERIES

1. Set Select Query Properties
2. Create Parameter Queries
3. Create Action Queries

LESSON 4: IMPROVING FORMS

1. Design a Form Layout
2. Enhance the Appearance of a Form
3. Restrict Data Entry in Forms
4. Add a Command Button to a Form
5. Create a Subform

LESSON 5: CUSTOMIZING REPORTS

1. Organize Report Information
2. Format the Report
3. Set Report Control Properties
4. Control Report Pagination
5. Summarize Report Information
6. Add a Subreport to an Existing Report
7. Create a Mailing Label Report

LESSON 6: SHARING DATA ACROSS APPLICATIONS

1. Import Data into Access
2. Export Data
3. Analyze Access Data in Excel
4. Export Data to a Text File
5. Merge Access Data with a Word Document

LESSON 7: USING DATABASES ON THE INTERNET

1. Creating a Hyperlink
2. Exporting a Form to HTML
3. Creating a Data Access Page
4. Grouping a Data Access Page
5. Sorting and Grouping Data on a Data Access Page

LESSON 8: AUTOMATING TASKS

1. Creating an AutoKeys Macro
2. Using Controls to Run a Macro
3. Assigning a Macro to an Event
4. Assigning a Macro to a Condition
5. Testing and Debugging a Macro

LESSON 9: USING DATABASE TOOLS

1. Setting, Modifying, Deleting a Database Password
2. Encrypting and Decrypting a Database
3. Replicating a Database
4. Splitting a Database
5. Converting a Database
6. Setting Startup Options