| Contents
The objectives of this course are to become familiar with the principles of databases and to be able to use M/S Access in the creation of your own database.
Basic Access Skills
- Opening an existing database
- Opening Access
- Saving a database
- The Database window
- Creating a new table
- Defining a primary key
- Saving the table structure
- Editing a table structure
- Indexing
Datasheet View
- Table Views
- Entering data
- Viewing data in a table
- Using the record selectors
- Finding a record
- Modifying data
- Adding a new record
- Deleting a record
Forms
- Relationship window
- Sorting records
- Creating a new form
- Changing view mode
- Adding text to the header and footer
- Entering data using a form
- The record selectors
- Printing a form
- Page set-up
- Using a filter in a form
- Filter by selection
- Removing the filter
- Using a filter in a table
- Creating Combo boxes
Introduction to Relationships
- Creating a relationship
- Deleting a relationship
- Saving a relationship
Sorting, Formatting and Printing
- Formatting and printing a datasheet
- Changing the page layout
- Printing only selected records
- Hiding and unhiding columns
- Moving columns
Queries
- Creating a new query
- Selecting fields to appear in the query
- Resizing columns
- Removing fields from a grid
- Adding and removing criteria
- Running the query
- Hiding and unhiding fields
- Saving the query
- Sorting data in a query
- Moving fields
- Adding a second table to a query
- Printing a query
Reports
- Creating reports based on tables
- Adding text to headers and footers
- Reports based on queries
- Adding a Sum field
- Creating Mailing labels
- Printing a report
|
