MICROSOFT ACCESS WORKSHOPS
Microsoft Access is a database-management system that allows you to create, edit, and present a database in a variety of different ways. An electronic database's purpose is not only a means of storing a huge amount of information, but also a way of organizing your data so that you may better use that information.
Advanced
Forms
This
workshop takes the basic form object of Access another step forward. Create
and use subreports on your existing forms and learn how to enter data
on both. Formatting techniques such as changing the layout of subforms
and setting the tab order will also be demonstrated.
Advanced
Queries
This is an advanced session for the user of Access who wishes to create
more powerful queries. Topics covered include: querying multiple tables
using inner and outer joins; performing calculations in queries, both
using the totals function and customizing calculations; displaying records
with and without values; crosstab queries; parameter queries; and action
queries--delete query, update query, append query, make-table query.
Advanced
Reports
Learn
advanced techniques such as summary functions, headers and footers, concatenated
text fields, calculated values and subreports. Also, insert page breaks
and keep groups of similar information together.
Advanced
Tables
The topics covered in this advanced session include: creating relationships
among tables--using the wizard and manually; enforcing referential integrity;
creating and using lookup fields and value lists; working with subdatasheets;
and maintaining data integrity with input masks and validation rules.
Forms
Forms provide an easy way for you to enter and maintain data
in a table. Forms are more "user friendly." This workshop will show you
how to use the built-in wizard to create a form. Editing and formatting
the form will also be covered.
Queries
A query is a specialized instruction, stored as a database object,
that selects and displays specific information from a table. This workshop
cover writing queries, determining criteria, and displaying and sorting
the results.
Reports
Reports provide an effective and professional-looking way to
present your data. This workshop will show you how to create reports using
the built-in wizard. Editing and formatting the report will also be covered.
Tables
A table is a collection of data organized into rows and columns.
Tables are the cornerstone of an Access database. Without them, nothing
else is possible. This workshop will show you how to design a table from
scratch, by creating and defining field names, data types, and field properties.
Copyright
© 2006 by Marywood University
Computer Training & User Support
Learning Resources Center - 2300 Adams Avenue - Scranton, PA
18509
(570) 348-6215
Please report all errors to the Pagemaster
This page was last updated on February 12, 2008