* Version 2010 available for all course dates after Oct
1/10.
Course Prerequisites
Required: Knowledge of Windows Introduction topics and ability
to use keyboard and mouse. Recommended: Use of one or more other
programs, such as Excel or Word.
Course Description
This course is intended as a
starting point for Access beginners, or people who use databases created
by others. The main focus is to learn how to create tables and
queries. Table topics: field names, types, setting the properties for
each field, entering records, sorting, finding, filtering, and
formatting. Query topics: the grid, adding tables, entering criteria,
parameters, calculations, and totals. A brief look at forms and
reports is also covered. From here, we highly recommend the
Intermediate Level I course to learn about relational databases, forms
and reports.
Detailed List of Topics
|
Overview
What is a
Database?
Database
Objects in Access
Creating /
Opening Databases
Tables
(Design View)
Creating a
Table
Adding Fields
Field Data
Types
Saving
Insert Fields
Moving Fields
Change Field
Name
Change Field
Data Type
Working with Attachments (version 2007
only)
Field Size
Format &
Decimal Places
Default Value
Caption
Validation
Rule/Text
Required
Allow Zero
Length
Indexed
Input Mask
Tables
(Datasheet View)
Entering Data
Adding
Pictures
Zoom and Line
Breaks
Column
Widths/Row Height
Navigating
Records
Formatting
Cells
Hiding
Columns
Freezing
Columns
Cut, Copy &
Paste
Deleting
Records
AutoNumbers
Sorting
Finding
Filter by
Selection
Text Filters, Number Filters, Data
Filters (version 2007 only)
Filter by
Form
Save Filter
as Query
|
Queries
Creating
Queries
Adding Fields
to Grid
Entering
Criteria
Running a
Query
Sorting and
Hiding
Saving a
Query
Moving
Columns
Performing
Calculations
Formatting
Columns
Parameter
Queries
Totals
Queries
Forms
AutoForms
Split Forms (version 2007 only)
Design & Form Views
Layout View (version 2007 only)
Moving/Sizing Controls
Edit
Text Labels
The
Form Header/Footer
Entering Data in the Form
Reports
AutoReports
Report Bands
Adjusting
Controls
Merging
Fields
Previewing
and Printing
Database Objects
Rename
Objects
Making a Copy
Deleting
Objects
|
