IT Training

Computing Workshop Descriptions - Access

Access: What's New in Access 2007

Intended for participants who are considering upgrading to Access 2007 and want to learn more about it, and for experienced Access users who simply need to learn how to navigate in the new interface and take advantage of the new features. In this workshop, participants will be introduced to the new Access 2007 interface and learn how to use some its new features. Compatibility issues and file formats will also be discussed.

Note: While this workshop introduces the Access 2007 interface, for those who need to learn Access, we recommend taking our Microsoft Access workshops which are now taught in Access 2007.

Participants will:

explore the new Access 2007 user interface
understand the various file formats and compatibility issues
filter data in datasheet view
create a split form
modify a form in Layout view
work with multivalued fields
modify a report in Layout view

Participants should already be able to:

understand basic database terminology
create a new database
create a simple query
work with one-to-many relationships

Access: The Basics

Databases are ideal tools for tracking large volumes of related information, and Access is the most commonly used desktop database application in use today. Intended for people with little or no experience using Access, this workshop introduces database terminology and provides a comprehensive overview of basic Access features such as tables, queries, forms and reports.

Participants will:

become familiar with the Access 2007 interface and database terminology
create a new database
create, design and modify tables to hold data
enter, edit and delete data
create and use select queries
import data from an Excel spreadsheet
create a form for customized data entry
create a report for customized printouts of data

Participants should already be able to:

use a mouse
save and organize files
use command menus
create and edit basic Word and Excel documents

Access: Database Relationships

Relationships are the fundamental building blocks of complex databases and are critical to designing and working with sophisticated databases. This workshop is intended for participants who are familiar with the basic features of Access but are interested in learning how to explore and define relationships in a relational database and how to create relational forms and queries. Multivalued fields and lookup fields will be introduced.

Participants will:

explore various types of relationships in a database
explore how relationships are structured and understand referential integrity rules
build relational queries and explore how join properties work
create and work with multivalued fields and lookup fields
build relational forms
create a lookup table from a query
export data to Microsoft Excel

Participants should already be able to:

understand the basic features of Access
create simple tables
enter and edit data in tables
create simple queries

Access: Queries

Queries enable you to retrieve, analyze and manipulate data. This workshop is intended for those participants who are interested in creating and modifying queries on related tables. Various types of queries will be introduced. This workshop also covers advanced query functions such as aggregate totals and calculated expressions.

Participants will:

build relational queries and modify query properties
learn to perform mathematical and text operations in a query
create parameter queries
summarize data using groups, calculated expressions, and aggregate totals
create Crosstab queries to summarize data
create and run Action queries to create, modify and delete data
use Find Duplicates and Find Unmatched queries to locate data

Participants should already be able to:

Create and modify tables
Understand database relationships

Access: Forms

Relational forms tie together data from various tables into a single screen, facilitating easy data entry and editing. This workshop is intended for anyone who is interested in learning how to create and enhance relational forms and subforms with drop-down lists, command buttons, and calculated fields. Creating a switchboard will be introducted.

Participants will:

create relational forms and subforms
learn various navigational views
enhance forms with drop-down lists and command buttons
add calculated fields and default value properties
use Form Designer to build upon a blank form
modify form controls and properties
create an unbound combo box and modify lookup field properties
create a switchboard using the Switchboard Manager

Participants should already be able to:

work with relational databases
define database relationships between tables
create relational queries

Access: Reports

Reports can provide attractive and organized ways to share data with others. This workshop is intended for anyone who is interested in learning how to create and enhance relational reports. Participants will also learn how to create calculated fields, select sorting and grouping options, create mailing labels and a mail merge report, and export a report to PDF format.

Participants will:

produce relational reports using the Report Wizard and Report Designer
enhance and modify report design
create calculated totals and set control properties
export an Access report to a PDF format
produce mailing labels
create a mail-merge report

Participants should already be able to:

understand database relationships
create and modify tables and queries
create relational forms

Access: Designing & Packaging Databases

This workshop introduces experienced Access users to issues relating to database design and the packaging of completed databases for distribution to end users. The workshop begins with an extensive lecture and discussion section on database modeling, then proceeds into a series of hands-on exercises to implement the database design and create a usable application for end users. Also provides a brief introduction to database security considerations.

Currently there are no scheduled offerings of this workshop.

Contact the IT Services Training Coordinator to purchase self-study materials.

Participants will:

define database needs
use business rules in database design
model a database before creating it
normalize imported flat file data into separate tables
create and maintain complex table relationships
package and password protect a database
compact a database

Participants should already be able to:

understand database relationships
create and edit relational forms and reports
create a form-based application

Advanced Forms

Not available this semester