IT Training	Advanced Search | Find People

Computing Workshop Descriptions - Access

• What's New in Access 2007
• The Basics
• Database Relationships
• Queries
• Forms
• Reports
• Designing & Packaging Databases
• Advanced Forms

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:

• learn basic database terminology
• create a database
• create, design and modify tables to hold data
• enter, edit and delete data
• ask questions of data using queries
• import data from an Excel spreadsheet
• create and use forms for customized data entry
• create and use reports 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. Relational forms and queries with lookup fields will be introduced.

Participants will:

• explore various types of relationships in a database
• define relationships between tables
• enforce referential integrity rules
• Work with different join types
• create lookup fields and tables
• build relational queries and forms
• 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:

• customize formatting and output of queries
• modify query properties
• build parameter queries
• perform custom searches
• create Crosstab queries to summarize data
• use aggregate totals and calculated expressions
• run Action queries to create, modify and delete table 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 forms with drop-down lists, command buttons, and calculated fields.

Participants will:

• create a form using the Form Designer
• modify form controls and properties
• create an unbound combo box
• change tab order
• create a main form and subform using the Form Wizard
• add calculated controls, checkboxes, and command buttons
• create and modify a switchboard

Participants should already be able to:

• understand database relationships
• understand Access tables and queries

Access: Reports

Reports provide you with attractive and organized ways of sharing 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 export reports to various formats.

Participants will:

• create and customize relational reports
• create calculated totals
• produce mailing labels
• create a form letter report in Access
• learn to use the Label Wizard to easily produce labels
• export Access reports in different formats

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
• understand Access tables and queries

Advanced Forms

• Not available this semester