|
|
 Microsoft Access 2003 Basics
Courseware Training Materials
 Foundation
/ Intermediate level computer training materials for delivering training to your
students, staff or clients. A courseware site licence allows you to train
an unlimited number of people, at your training center using these teaching resources.
Training Course Outlines
DATABASE CONCEPTS
-
What is a database?
-
What are databases used for?
-
What is a relational database?
-
What is a table?
-
What is a record (row)?
-
What is a field (column)?
-
What is data?
-
The difference between data and information
-
Data types
-
Common uses of large-scale databases
-
Each table in a database should contain data related to a single subject
-
Each field in a table should contain only one element of data
-
Database designers, database administrators and database users
A FIRST LOOK AT ACCESS 2003
-
Opening Access 2003
-
Closing Access 2003
-
Exploring the Access 2003 window
-
The Ribbon (Toolbar)
-
Ribbon tabs
-
Groups & Dialog Box Launcher
-
Navigating - Quick keys (shortcut keys)
-
Navigating – Pointer keys & quick keys
-
Navigating – Mouse wheel
-
Contextual tabs
- Minimizing the Ribbon
-
Quick Access Toolbar
-
The Office Button
-
Microsoft Access Help
-
Closing Microsoft Access
OPENING A DATABASE & SECURITY ISSUES
-
Opening a database
-
Security warnings
-
Trusted Locations - Trust Centre
-
Setting the default folder location within Access
CREATING A DATABASE & USING VIEWS
-
Creating a new database
-
Creating a new blank database
-
Saving a table
-
Adding and renaming fields
-
Using Datasheet View
-
Using Design View
-
Changing the view
TABLE MODIFICATION AND NAVIGATION
-
Adding Fields - Design View
-
Data Type - Overview
-
Data Type - Descriptions
-
Using the Attachment data type
-
Adjusting column width
-
Moving a column to rearrange the column order
-
Adding records to a table
-
Navigating through records within a table
-
Closing a database
-
Navigation Pane
FIELD PROPERTIES, VALIDATION & INPUT MASKS
-
Field Properties
-
Input Mask
-
Validation Rules
-
Field Properties - Guides Tables
MANIPULATING RECORDS & TABLES
-
Closing an Object - Table
-
Renaming an Object - Table
-
Editing data within a record
-
Deleting data within a record
-
Using the Undo command
-
Deleting a single record
-
Deleting multiple records
-
Save As – Database Object
-
Deleting a table
PRIMARY KEYS AND INDEXING
-
Defining a Primary Key
-
Indexing
-
Creating a single-field Index
-
Creating a multiple-field Index
-
Deleting multi-field indexes
FILTERING, SORTING & SEARCHING
-
Text Filters
-
Applying a single filter
-
Clearing a single filter
-
Creating multiple filters
-
Clearing multiple filters
-
Sorting
-
Searching
RELATIONSHIPS
-
Table relationships
-
One-to-many relationship
-
Many-to-many relationship
-
One-to-one relationships
-
Creating relationships between tables
-
Referential integrity
-
Cascade options
-
Cascade update related fields
-
Cascade delete related records
-
Enabling cascade options
-
Deleting relationships
FORMS
-
Forms overview
-
Creating forms
-
Modifying forms
-
Modifying a form title
-
Modifying a form logo
-
Modifying a form label
-
Saving a form
-
Form View
-
Adding and formatting attachments
-
Modifying records
-
Deleting records
-
Adding records using a form
-
Adding or deleting text in a record using a form
-
Closing forms
-
Opening forms
-
Deleting a form
-
Filtering a form
-
Removing a filter form a form
-
Inserting and modifying a form header
-
Inserting and modifying a form footer
QUERIES
-
What are queries?
-
Creating a simple query
-
Adding (and removing) criteria to a query
-
Running a query
-
Editing criteria in a query
-
Saving a query
-
Creating a two table query and sorting the results
-
What are Wildcards?
-
Deleting a query
-
Hiding and un-hiding fields (columns) within a query
REPORTS
-
What are reports?
-
Creating a simple report
-
Using the Report Wizard
-
Modifying the layout of a report
-
Widening a report column
-
Modifying the report title
-
Adding logos to a report
-
AutoFormating a report
-
Modifying field names within a report
-
Inserting and formatting the date & time
-
Adding available fields to a report
-
Resizing reports for printing
-
Closing a report
-
Deleting a report
PRINTING & EXPORTING ISSUES
-
What does exporting data mean?
-
What is a spreadsheet format?
-
What is text only and CSV format?
-
What is an XML file?
-
Exporting a table or query as an Excel spreadsheet using the Export Wizard
-
Exporting a table or query as a text file using the Export Wizard
-
Exporting a table or query as an XML formatted file using the Export Wizard
-
Considerations before printing
-
Print previewing
-
Which orientation, portrait or landscape?
-
Adjusting layout in Print Preview
-
Setting margins
-
Printing a complete table
-
Printing selected records
-
Printing a query or reports
-
Printing forms
|
Customisable
Courseware
