EK-084587 - Microsoft Office Access 2010 Introduction, Level 1
Course
EK-084587
Price:
$498.00
Software Assurance Value:
Not Eligible
Duration:
2 Days
Description
This two-day course is for the individual whose job
responsibilities include designing and creating new databases, tables and
relationships, creating and maintaining records, locating records and producing
reports based on a database. It also provides the fundamental knowledge and
techniques needed to advance to more complex Access responsibilities such as
maintaining databases and using programming techniques that enhance Access
applications.
Return to Top
Audience
This course is
designed for students who wish to learn the basics of Microsoft Access.
Return to Top
Prerequisites
Prospective students proficient with Windows. Familiarity
with the Office 2010 environment is helpful.
Return to Top
Course Objectives
Upon successful completion of this course, students will be
able to:
- identify the basic components of an Access
database.
- build the structure of a database.
- manage data in tables.
- query a database.
- design forms.
- generate reportsstreamline data entry and
maintain data integrity.
- join tables to retrieve data from unrelated
tables.
- create flexible queries to display specified
records, allow for user-determined query criteria, and modify data using
queries.
- improve forms.
- customize reports to organize the displayed
information and produce specific print layouts.
- share data between Access and other applications
Return to Top
Course Outline
Day 1
Getting
Started with Access Databases
- Elements of the Access 2010 Interface
- Identify the Components of a Database
- Examine the Relational Database Design Process
Building the Structure of a Database
- Create a New Database
- Create a Table Using the Design View
- Manage Tables
- Establish Table Relationships
Managing Data in a Table
- Modify Table Data
- Sort and Filter Records
- Work with Subdatasheets
Querying a Database
- Create a Query
- Add Criteria to a Query
- Add a Calculated Field to a Query
- Calculations on a Record Grouping
Designing Forms
- Create and Modify a Form
- View Data Using an Access Form
Generating Reports
- Create a Report
- Add a Control to a Report
- Format the Controls in a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
Day 2 Controlling Data Entry
- Constrain Data Entry Using Field Properties
- Establish Data Entry Formats
- Create a List of Values for a Field
Joining Tables
- Create Query Joins
- Join Tables with No Common Fields
- Relate Data within a Table
Creating Flexible Queries
- The Select Query Properties
- Retrieve Records Based on Input Criteria
- Create Action Queries
Improving Forms
- Restrict Data Entry in Forms
- Organize Information with Tab Pages
- Add a Command Button to a Form
- Create a Subform
- Display a Summary of Data in a Form
- Change Display of Data Conditionally
Customizing Reports
- Organize Report Information
- Format Reports and Control Pagination
- Summarize Report Information
- Add a Subreport to an Existing Report
- Create a Mailing Label Report
Sharing Data Across Applications
- Import Data into Access
- Export Data to Text File Formats
- Export Access Data to Excel
- Create a Mail Merge
Return to Top
