MS Access

Introduction
access 2007 fundamentals
introduction to databases
starting access 2007
the getting started page and opening a database
what’s new in access 2007
understanding the access program screen
understanding the ribbon
using the office button and quick access toolbar
using keyboard commands
using contextual menus
using help
database basics
working with database objects
tour of a table
adding, editing and deleting records
tour of a form
tour of a query
tour of a report
previewing and printing a database object
selecting data
cutting, copying and pasting data
using undo and redo
checking your spelling
using the zoom box
exiting access 2007
creating and working with a database
planning a database
creating a new database
creating a table
modifying a table
creating a query
sorting a query
using and and or operators in a query
creating a form with the form wizard
creating a report with the report wizard
creating mailing labels with the label wizard
converting an access database
finding, filtering, and formatting data
finding and replacing data
sorting records
using common filters
filtering by selection
filtering by form
creating an advanced filter
adjusting and rearranging rows and columns
changing gridline and cell effects
changing the datasheet font
freezing a column
hiding a column
functions
sql queries
joins
sub queries
forms and reports
reports.