This course builds on the skills taught in Access Intermediate. In this advanced course, students will learn how to create and manage databases and database objects. Students will learn how to create PivotTables, PivotCharts, add tab controls to forms, create and use macros, and create SQL queries. Course activities also cover using hyperlinks and data access pages, working with database utilities and security features, such as passwords and permissions.

 

Creating Multiple Table Queries

§    Creating select queries

§    Sorting a query on multiple fields

§    Developing AND queries

§    Developing OR queries

§    Creating calculated fields

§    Building summary queries

§    Creating cross tab queries

 

Developing Forms and Subforms

§    Understanding the form/subform Relationship

§    Creating Forms with subforms using the form wizard

§    Creating subforms using queries

§    Modifying subforms

§    Adding combo boxes

§    Adding option groups

§    Adding command buttons

§    Adding records with a form/subform

 

Building Complex Reports

§    Using the database wizard

§    Importing data

§    Creating a report from a parameter query

§    Enhancing reports

§    Adding lines and rectangles

§    Using format painter and autoformats

§    Inserting an image

§    Securing a database

 

Sharing Access Information with Other Office Programs

§    Examining Access objects

§    Examining relationships between tables

§    Importing data from Excel

§    Linking data with Excel

§    Formatting controls

§    Analyzing data with Excel

§    Copying data to Word

§    Exporting data

 

Creating Data Access Pages

§    Understanding the World Wide Web

§    Using hyperlink fields

§    Creating pages for data entry

§    Creating pages for data analysis

§    Working in page design view

§    Inserting hyperlinks to other pages

§    Publishing web pages to web servers

 

Creating Advanced Queries

§    Querying for top values

§    Creating an advanced parameter query

§    Modifying query properties

§    Creating an update query

§    Creating a make-table query

§    Creating an append query

§    Creating a delete query

§     Specifying joint properties

 

Covered Topics (lists are not all-inclusive)

1. Getting Started with Access
   1. Starting Access
   2. Navigating records
   3. Entering records
   4. Editing records
   5. Previewing and printing a document
2. Using Tables and Queries
   1. Creating a table
   2. Using Table Design
   3. Formatting a datasheet
   4. Understanding sorting, filtering, and finding
   5. Sorting records
   6. Filtering records
   7. Creating a query
   8. Using query design
3. Using Forms
   1. Creating a form
   2. Moving and resizing controls
   3. Modifying labels
   4. Modifying text boxes
   5. Entering and editing records
   6. Inserting an image
4. Using Reports
   1. Creating a report
   2. Grouping a report
   3. Changing the sort order
   4. Aligning controls
   5. Formatting controls
   6. Creating mailing labels
5. Modifying a database structure
   1. Planning related tables
   2. Creating related tables
   3. Defining text field properties
   4. Defining number and currency fields
   5. Defining date/time and yes/no fields

Covered Topics (lists are not all-inclusive)

1. Getting Started with Access
   1. Starting Access
   2. Navigating records
   3. Entering records
   4. Editing records
   5. Previewing and printing a document
2. Using Tables and Queries
   1. Creating a table
   2. Using Table Design
   3. Formatting a datasheet
   4. Understanding sorting, filtering, and finding
   5. Sorting records
   6. Filtering records
   7. Creating a query
   8. Using query design
3. Using Forms
   1. Creating a form
   2. Moving and resizing controls
   3. Modifying labels
   4. Modifying text boxes
   5. Entering and editing records
   6. Inserting an image
4. Using Reports
   1. Creating a report
   2. Grouping a report
   3. Changing the sort order
   4. Aligning controls
   5. Formatting controls
   6. Creating mailing labels
5. Modifying a database structure
   1. Planning related tables
   2. Creating related tables
   3. Defining text field properties
   4. Defining number and currency fields
   5. Defining date/time and yes/no fields

Covered Topics (lists are not all-inclusive)

1. Creating Multiple Table Queries
   1. Creating Select Queries
   2. Sorting a Query on multiple fields
   3. Developing AND queries
   4. Developing OR queries
   5. Creating Calculated Fields
   6. Building Summary Queries
   7. Creating Crosstab Queries
2. Developing Forms and Subforms
   1. Understanding the Form/Subform Relationship
   2. Creating Forms with Subforms using the form wizard
   3. Creating subforms using queries
   4. Modifying Subforms
   5. Adding Combo Boxes
   6. Adding Option Groups
   7. Adding Command Buttons
   8. Adding Records with a Form/Subform
3. Building Complex Reports
   1. Using the Database Wizard
   2. Importing Data
   3. Creating a report from a parameter Query
   4. Enhancing Reports
   5. Adding lines and Rectangles
   6. Using Format Painter and AutoFormats
   7. Inserting an image
   8. Securing a database
4. Sharing Access Information with Other Office Programs
   1. Examining Access Objects
   2. Examining relationships between tables
   3. Importing data from Excel
   4. Linking data with Excel
   5. Formatting controls
   6. Analyzing data with Excel
   7. Copying data to Word
   8. Exporting Data
5. Creating Data Access Pages
   1. Understanding the World Wide Web
   2. Using Hyperlink Fields
   3. Creating Pages for Data Entry
   4. Creating Pages for Data Analysis
   5. Working in Page Design View
   6. Inserting Hyperlinks to Other Pages
   7. Publishing Web Pages to Web Servers
6. Creating Advanced Queries
   1. Querying for Top Values
   2. Creating an Advanced Parameter Query
   3. Modifying Query Properties
   4. Creating an Update Query
   5. Creating a Make-Table Query
   6. Creating an Append Query
   7. Creating a Delete Query
   8. Specifying Join Properties

This course teaches students how to use Microsoft’s leading consumer relational database management system for desktop applications. Students will learn how to respond to application level events, display forms and reports, manipulate toolbars, create and name variables and create classes.  Students will discover how to access data with VBA, execute and debug VBA code, and use VBA with Access objects.

 

Visual Basic Editor §    Objects §    Object Browser §    Collections   Programming basics §    Data §    Scope   Control structures §    Decision structures §    Loop structures   ActiveX Data Objects §    Getting started with ActiveX Data Objects § Working with ActiveX Data Objects   VBA debugging tools §    Errors in code §    Debugging techniques § Handling run-time errors   Office integration §    Automating Office 2003 §    Working with Word & Excel from Access