|
ACC-100
Access 2003 Introduction
Tuition:
$225
Course Length:
1 day
Prerequisite
Introduction to Windows or equivalent working knowledge
General knowledge of other MS Office applications (i.e. Word, Outlook,
Excel)
What past students had
to say about this class:
This course was presented very well. It could have taught my mom Access
and she doesn't even understand notepad. It was very well done as an
introduction. ~R.D. \ USMC I honestly feel that this
course was fantastic- I learned so much that will benefit my productivity.
My company will benefit greatly from the skills I obtained in class. The
instructor, Kate, was awesome and I want to take as many classes as I can. ~J.K.
\ Spectrum Marketing Energetic
instructor with realistic expectation of students. Patient with peoples
learning curve. Job well done. ~A. R. \ USMC
Course Contents
Introduction
Getting Started
-
What
is Access?
-
Starting
Access
-
The Access
Application Window
-
Working with
Access Menus
-
Basic Access
Terminology
-
Examining
Access Objects
-
Resetting the
Database Folder
-
Displaying
Help Information
-
Exiting from
Access
Setting
Up a New Database
-
Designing
a New Database
-
Creating a
New Database
-
Creating a
New Table
-
Entering
Records in Datasheet View
-
Printing the
Datasheet of a Table
-
Navigating
Through Records in Datasheet View
-
Closing a
Table/ Closing a Database
Creating
a Form/ Modifying and Manipulating Data
-
Reopening
a database/reopening a table
-
Creating
a form
-
Navigating
through records in form view/closing a form
-
Reopening
a form
-
Switching
between form view and datasheet view
-
Entering
records in form view
-
Editing
records in datasheet view and form view
-
Using
the find feature
-
Deleting
records in datasheet view and form view
-
Modifying the Datasheet View
of a Table
-
Sorting
the records in a table
Displaying selected
Data
-
Filtering
the records in a table
-
Creating a
simple query
-
Creating a
query in Design View
-
Modifying a
query
-
Including a
numeric condition in a query
-
Including a
calculated field in a query
Creating a report
Additional Access features
-
Copying,
renaming and deleting database objects
-
Compacting and Repairing a
Database
-
Backing up a database
-
Importing
spreadsheet data into an Access table
-
importing text into an access
table
Final case study
|
