IT Training & Education
View Workshop Charges and Policies
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. (read the full description)
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 define relationships in a relational database and how to create relational forms and queries. Multivalued fields and lookup fields will be introduced.
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. (read the full description)
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 introduced. (read the full description)
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 a PDF format. (read the full description)
In this hands-on lab session, you will integrate and reinforce the skills you learned in Access: The Basics, Access: Database Relationships, Access: Queries, Access: Forms and Access: Reports to independently create relationships, queries, forms, and reports from an existing database. You will be given guidelines to accomplish specified tasks within the database. (read the full description)
Note: You can only register for this workshop as part of the Access 2007 End-User Certificate Series.
In this workshop, participants will learn how to make forms more flexible and practical. Access offers many tools to help with data entry, accuracy and validity. This workshop is a continuation of the Access: Forms workshop and will explore more advanced features of forms such as adding option groups, applying conditional formatting, linking forms, and creating multiple-page forms. (read the full description)
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. (read the full description)
Currently there are no scheduled offerings of this workshop in Indianapolis. You can, however, order these materials for self-study.
