Back

Microsoft Access Level 3 training course in Guildford Surrey

Course Description: Access  Level 3 (Expert)

Your training in and use of Microsoft Office Access has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access . You're now ready to extend your knowledge into some of the more specialised and advanced capabilities.

Prerequisites: Access Level 1 and Access Level 2, or equivalent knowledge.

Benefits: You will create complex Access databases using forms, reports, and macros.

Target student: This course is designed for the student who wishes to learn intermediate and advanced operations of the Microsoft Office Access database program. The Level 3 course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance.

Length: One Day

Click back button above to see course dates and fees.
 

Course Contents:

Access  Level 3 (Expert)

 

Lesson 1: Structuring Existing Data

Topic 1A: Import Data

Topic 1B: Analyze Tables

Topic 1C: Create a Junction Table

Topic 1D: Improve Table Structure

 

Lesson 2: Writing Advanced Queries

Topic 2A: Create Unmatched and Duplicates Queries

Topic 2B: Group and Summarize Records Using the Criteria Field

Topic 2C: Summarize Data with a Crosstab Query

Topic 2D: Create a PivotTable and a PivotChart

Topic 2E: Display a Graphical Summary on a Form

 

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro

Topic 3B: Attach a Macro to a Command Button

Topic 3C: Restrict Records Using a Where Condition

 

Lesson 4: Adding Interaction and Automation with Macros

Topic 4A: Require Data Entry with a Macro

Topic 4B: Display a Message Box with a Macro

Topic 4C: Automate Data Entry

 

Lesson 5: Making Forms More Effective

Topic 5A: Change the Display of Data Conditionally

Topic 5B: Display a Calendar on a Form

Topic 5C: Organize Information with Tab Pages

 

Lesson 6: Making Reports More Effective

Topic 6A: Cancel Printing of a Blank Report

Topic 6B: Include a Chart in a Report

Topic 6C: Arrange Data in Columns

Topic 6D: Create a Report Snapshot

 

Lesson 7: Maintaining an Access Database

Topic 7A: Link Tables to External Data Sources

Topic 7B: Back Up a Database

Topic 7C: Compact and Repair a Database

Topic 7D: Protect a Database with a Password

Topic 7E: Determine Object Dependency

Topic 7F: Document a Database

Topic 7G: Analyze the Performance of a Database

Topic 8D: Merge Access Data with a Word Document

www.surreytraining.com

Telephone: 01483 572855

                                   Home / Contact us / Diplomas / Individuals / Companies / News / Location / Site Map