Overview
Access 2010 – Level 1
In this course, students will create and modify new databases and their various objects. Students will maintain data consistency and integrity; improve queries, forms, and reports; and also integrate Microsoft® Office Access™ 2010 with other applications.
Access 2010 – Level 2
In this course, students will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.
Access 2010 – Level 3
In this course students will exchange data with other applications, automate business processes by using VBA code, and secure and share databases.
Prerequisites
Access 2010 – Level 1
Students should be familiar with using personal computers and have used a mouse and keyboard. Students should be comfortable with the Windows environment and be able to use Windows to manage information on their computer. Specifically, students should be able to launch and close programs; navigate to information stored on the computer; and manage files and folders.
Access 2010 – Level 2
Access 2010 – Level 1
Access 2010 – Level 3
Access 2010 – Level 1
Access 2010 – Level 2
Who Should Attend?
Course Outline Level 1
- Identify the Elements of the Access 2010 Interface
- Identify the Components of a Database
- Examine the Relational Database Design Process
- Create a New Database
- Create a Table Using Design View
- Modifying the Table Structure
- Establish Table Relationships
- Modify Table Data
- Sort and Filter Records
- Work with Subdatasheets
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Perform Calculations on a Record Grouping
- Create a Form
- Modify the Design of a Form
- View and Add Data Using an Access Form
- Create a Report
- View an Access Report
- Add a Calculated Field to a Report
- Format the Controls in a Report
- Apply a Theme to a Report
- Prepare a Report for Print
- Constrain Data Entry Using Field Properties
- Establish Data Entry Formats for Entering Field Values
- Create a List of Values for a Field
- Create Query Joins
- Join Unrelated Tables
- Relate Data Within a Table
- Retrieve Records Using Select Queries
- Retrieve Records Based On Input Criteria
- Manipulate Data Using Queries
- Manipulate Data Using Queries
- Design a Form Layout
- Enhance the Appearance of a Form
- Restrict Data Entry in Forms
- Add a Command Button to a Form
- Create a Subform
- Organize Report Information
- Format Reports
- Control Report Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
- Import Data into Access
- Export Data
- Analyze Access Data in Excel
- Export Query Results
- Mail Merge Access Data With a Word Document
Course Outline Level 2
- Restructure the Data in a Table
- Create a Junction Table
- Improve the Table Structure
- Create Subqueries
- Create Unmatched and Duplicate Queries
- Group and Summarize Records Using Criteria
- Summarize Data Using a Crosstab Query
- Create a PivotTable and a PivotChart
- Create a Macro
- Attach a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
- Include a Chart in a Report
- Print Data in Columns
- Cancel Printing of a Blank Report
- Publish Reports as PDF
- Link Tables to External Data Sources
- Manage a Database
- Determine Object Dependency
- Document a Database
- Analyze the Performance of a Database
Course Outline Level 3
- Import XML Data into an Access Database
- Export Access Data to XML Format
- Export Data to the Outlook Address Book
- Collect Data Through Email Messages
- Create a Standard Module
- Develop Code
- Call a Procedure from a Form
- Run a Procedure
- Create a Database Switchboard
- Modify a Database Switchboard
- Set the Startup Options
- Split a Database
- Implement Security
- Set Passwords
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
- Export a Table to a SharePoint List
- Import Data from a SharePoint List
- Publish a Database to a SharePoint Site
- Move a Database to a SharePoint Site
- Work Offline
