4 Access XP Tutorials from Kansas University

Here are 4 Access XP Tutorials, from Kansas University. These include an Access tutorial that will introduce you to Access, and three others that teach you more advanced Access features and tasks, such as create and run a select query, create pivot tables and charts, work with forms and subforms, sort and filter for records, work with reports, add grouped sections and sort fields in reports, and create calculated controls in reports.


Access Introduction Tutorial

This Access Introduction Tutorial will get you started using the Microsoft Access relational database application. This program which allows you to create, organize, and edit large quantities of data. The tutorial covers creating a blank database, creating and importing tables into the database, establishing primary and foreign key fields, entering records into tables, sorting fields in tables, and filtering for specific records in tables. It also demonstrates how to set up different types of relationships between tables and enforcing rules on those relationships. (21 pages, 286kb, pdf format)

The goals of this Access Introduction Tutorial are to teach you to:
  - Create a new, blank database
  - Create new tables in design view and import tables
  - Enter and delete records
  - Edit table design
  - Display and organize data in a table
  - Create and edit relationships

Access Introduction Tutorial Contents:
Introduction
Objectives
Definitions
Planning for a Relational Database
Creating a New Blank Database
    The Database Window
Creating a Table
    Creating a Table in Design View
    Importing a Table
Entering and Deleting Information
    Adding Records
    Deleting Records
Editing the Table Design
Displaying and Organizing Data
    Rearranging Columns
    Sorting
    Filtering Records
Creating Relationships
    Types of Relationships
    Enforcing Relationship Rules
    Creating a Relationship
Modifying a Relationship
Getting Additional Help


Intermediate Access Tutorial

This Intermediate Access Tutorial teaches how to design a query, use queries to display related information from two or more tables, and construct selection criteria to extract specific records from tables using queries. It also shows you how to create and utilize pivot tables and charts based on query information. (18 pages, 349kb, pdf format)

Upon completing this Intermediate Access Tutorial, you should be able to:
  - Create and run a select query to display data from one or more related tables
  - Sort data in a query
  - Add criteria to a query to display specific records
  - Create pivot tables and charts based on query data

Contents of Intermediate Access Tutorial:
Introduction
Objectives
Running and Creating Select Queries.
Editing Select Queries
Adding Criteria to Select Queries
Creating Calculated Fields
Using Pivot Tables and Pivot Charts (New in Access XP).
Creating PivotCharts
Getting Additional Help


Access Forms Tutorial

This Access Forms Tutorial explains how to use and work with forms in Access. Forms give you a way to enter data into a database and work with other objects in a database. This tutorial shows the tasks needed for creating forms via AutoForm and the Form Wizard, and also for designing and modifying forms in design view with the help of the Toolbox toolbar. It also shows you how to add subforms to main forms, to sort, filter, and work with conditionally formatting data in forms. (22 pages, 273kb, pdf format)

At the end of this Access Forms Tutorial, you will be able to:
  - Create a form from a table or query using AutoForm
  - Create a form from a table or query using the Form Wizard
  - Create a form directly in the Design View
  - Modify a form in the Design View
  - Add subforms to main forms
  - Sort and filter for records in a form
  - Format controls conditionally

Contents of Access Forms Tutorial:
Introduction
Objectives
Introducing Forms 
Using AutoForm
Creating Forms with the Form Wizard
    Viewing and Editing
Creating a Form in Design View
    Sections of a Form
    Adding Controls
    Other Types of Controls
Adding Controls from the Toolbox 
Modifying Properties
Setting Tab Control 
Sorting and Filtering in Forms
    Sorting Information 
    Filtering Records 
Conditional Formatting 
    Adding a Conditional Format 
    Deleting a Conditional Format 
Getting Additional Help


Access Reports Tutorial

This Access Reports Tutorial explains how to use reports within Access. It will teach you how to create reports using AutoReport and the Report Wizard. It also demonstrates how to design and modify reports in design view with the help of the Toolbox toolbar. And finally, it describes the tasks to create grouped sections, calculated fields, and sort information in reports. (17 pages, 248kb, pdf format)

When you are finished with this Access Reports Tutorial, you will be able to:
  - Create a report from a table or query using AutoReport
  - Create a report from a table or query using the Report Wizard
  - Create and modify reports in the Design View using the tools from the Formatting and Toolbox toolbars
  - Add grouped sections and sort fields in reports
  - Create calculated controls in reports

Contents of Access Reports Tutorial:
Introduction
Objectives
Prerequisites
Related Training Available from Instructional Services
Introducing Reports
Using AutoReport
Creating Reports with the Report Wizard
    Viewing and Editing
Creating a Report in Design View
    Sections of a Report 
    Adding Controls
    Other Types of Controls
Adding Controls from the Toolbox
Modifying Properties
Sorting and Grouping Records
    Sorting Records
    Grouping Records
    Creating Calculated Field
Getting Additional Hel