|
Microsoft
Access XP - Getting Started
This
course is for beginners who have little or no skills working
with the Access program.
You
will learn to : creating a Database; setting up Tables and
Fields; Enter, Sort and Delet Data; Print Reports and much
more.
Table
of Contents
What is a database
Running the program Access
Creating a New Database
Creating a New Folder
Maximising Windows
Creating a Table
Field Names, Field Types
Field Descriptions
Field Sizes, Formats
Field Input Masks
Attaching Keys
Inserting Rows
Saving and Closing a Table
Opening an existing Database
Working with Tables
Opening and Entering Data into a Table
Adjusting Column Sizes
Moving Amongst Records using Shortcuts
Exiting the Program Access
Selecting and Sorting Records
Deleting Records
Finding Specific Records
New File
Print Preview
Removing Gridlines
Page Setup, Headers and Margins
Fore/Font Colour, Fill Background Colour
Printing
Creating a Tabular Report
Editing Report Titles
Selecting and editing objects
Report Design view
Printing, Saving and Closing a Report
Switching between views
Hiding and Unhiding Columns
Line Border Colours
Forms (AutoForm, Entering data)
Assignments
|