Access 2010 - Level 1

Duration:  Instructor Led Learning - 2 Days
At Course Completion:
Upon successful completion of this Access 2010 Beginning course, the delegate(s) will demonstrate an ability to:

 

  • Understand the basic elements of an Access database
  • Build and re-build the structure of a blank or existing database
  • Design and format the data in a table
  • Use a query to write reports and query important data
  • Forms for input
  • Create reports from queries or tables
  • Maintain the integrity and protection of the data
  • Create join lines between tables to retrieve data from all parts of the database
  • Create parameter queries to sort and filter the data
  • Improve form input measures and rules for maintaining accuracy
  • Design reports with customised layouts and settings.
  • Integrate data between Access and other Microsoft and non-microsoft programmes 

 

Access 2010 Outline:

Lesson 1: Getting Started with Access 2010

Recognise and use the Elements of the Access 2010 Interface
Recognise the Key Components of a Database
Analyse the Relational Database Design Processes

Lesson 2: Managing Data in a Table

Modify Table Data
Sort and Filter Records
Work with Subdatasheets

Lesson 3: Querying a Database

Create a Select Query
Add Sorting and Filter Criteria to a Query
Add a Calculated Field to a Query
Create Calculations on a Record Grouping

Lesson 4: Designing Entry Forms

Create a Designed Form
Modify the Designing of a Form
Add, Modify and Archive Data Using an Access Form

Lesson 5: Create Designed Business Reports

Create a Basic Report
Add a Button Control to a Report
Format the Format and Design in a Report
Enhance the Retrievability of Data for a Designed Report
Prepare a Report for Page Setup and Printing

Lesson 6: Controlling Data Entry

Constrain Data Entry Using Field Properties
Establish Data Entry Formats for Entering Field Values
Create a List of Values for a Field

Lesson 7: Joining Tables

Create flexible Query Joins for Identifying Specific Data
Join Tables That Have No Common Fields for Multiple Relational Data
Relate Data Within a the Current Table

Lesson 8: Building The Structure of a Database

Creating a New Database
Create a Table in the Database
Manage the Tables within the Database
Establishing Table Relationship Links within the Database

Lesson 9: Creating Customised Queries

Set the Select Query Properties
Retrieve Records Based on Input Criteria
Create Filters Using Advanced Queries

Lesson 10: Improving Forms

Restrict Data Entry in Forms
Organise Information with Tab Pages
Add a Command Button to a Form
Create a SubForm
Display a Summary of Data in a Form
Change the Display of Data Conditionally

Lesson 11: Customising Reports

Organise Report Information
Format Reports
Control Report Pagination
Add a Calculated Field to a Report Add a SubReport to an Existing Report
Create a Mailing Label Report

Lesson 12: Sharing Data within Microsoft Applications

Import Data into Access
Export Data to Text File Formats
Export Access Data to Excel
Create a Mail Merge Using Access or Excel Datasheets

View Access Intermediate 2010 Outline

Access 2010 Level 1 Outline.pdf Access 2010 Level 1 Outline.pdf
Size : 181.652 Kb
Type : pdf