Microsoft Access 2010 Level 3

Request info

Course duration: 1 Day

Course Description

You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Target Student:

This 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.

Prerequisites:

To ensure your success, knowledge of basic and intermediate features of Access tables, relationships, and queries, forms, and reports is recommended. The following courses or equivalent knowledge is recommended:

• Microsoft® Office Access® 2010: Level 1
• Microsoft® Office Access® 2010: Level 2

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• restructure data into appropriate tables to ensure data dependency and minimize redundancy.
• write advanced queries to analyze and summarize data.
• create and revise Microsoft® Office Access® 2010 macros.
• customize reports by using various Microsoft® Office Access® 2010 features.
• maintain their databases using Microsoft® Office Access® 2010 tools.

Course Content

Lesson 1: Structuring Existing Data

Topic 1A: Restructure the Data in a Table
Topic 1B: Create a Junction Table
Topic 1C: Improve the Table Structure

Lesson 2: Writing Advanced Queries

Topic 2A: Create SubQueries
Topic 2B: Create Unmatched and Duplicate Queries
Topic 2C: Group and Summarize Records Using Criteria
Topic 2D: Summarize Data Using a Crosstab Query
Topic 2E: Create a PivotTable and a PivotChart

Lesson 3: Simplifying Tasks with Macros

Topic 3A: Create a Macro
Topic 3B: Attach a Macro
Topic 3C: Restrict Records Using a Condition
Topic 3D: Validate Data Using a Macro
Topic 3E: Automate Data Entry Using a Macro

Lesson 4: Creating Effective Reports

Topic 4A: Include a Chart in a Report
Topic 4B: Print Data in Columns
Topic 4C: Cancel Printing of a Blank Report
Topic 4D: Publish Reports as PDF

Lesson 5: Maintaining an Access Database

Topic 5A: Link Tables to External Data Sources
Topic 5B: Manage a Database
Topic 5C: Determine Object Dependency
Topic 5D: Document a Database
Topic 5E: Analyze the Performance of a Database

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2024-11-06' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (1173) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC