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