If you're an Access user and you're thinking of upgrading to the
newest version of Microsoft Office - Office 2007 - or if you've
already made the change, this class is for you!
Microsoft has made significant changes and improvements to this
new version of Access. In this class we'll take you on a tour of
several of the most important changes. This is your chance to see
Access 2007 in action!
We'll cover:
- The new Office Ribbon which replaces the familiar menus and
toolbars
- The new Navigation Pane which replaces the database window
and allows you to organize all of the database objects by type,
date created or modified, by related tables, or in custom groups
you create
- Tabbed objects - open tables, queries, forms, and reports can
be displayed and easily accessed from clickable tabs at the top
of the window
- Field templates which allow you to easily create pre-defined
fields by dragging them from the Field Template Pane to a
datasheet
- Two new views - Report view and Layout view - which let you
work with forms and reports interactively - a true "what you see
is what you get" design environment for forms and reports
- Using Layout view and the new Group, Sort, and Total pane to
add a group level and request a total - and see the changes live,
in your report!
- The new Total row which makes adding a sum, average, count,
maximum, or minimum to your report headers or footers easy
without manually creating a calculated field
- Using the new split form to create a form that combines a
Datasheet view and a Form view
- The powerful new Multivalued field datatype which accepts
multiple values in one field
- The new Attachment datatype that allows all types of
documents and binary files to be stored in fields in your
database without dramatically increasing the file size of the
database
- Rich text support that allows you to format text in records
with formatting options such as bold, italics, etc.
- Memo fields that can now retain a history of all changes to
the field
- Enhanced sorting and filtering tools
- New features in Access 2007 which make it easier to import
and export data into and out of Access databases
Prerequisites: Some experience with previous
versions of Microsoft Access would be helpful, but is not required.
Understanding of the benefits of using a relational database.