|
Course aim
This course is an introduction to the relational database, Microsoft Access
2007. The course comprises a mixture of demonstrations, tutor-led examples
and student exercises.
Who should attend?
Delegates should be familiar with the Windows environment. No prior knowledge
of database terminology or Microsoft Access is assumed. The course includes
no programming.
Training style
Informal and participative using a combination of trainer input, discussion
and practical exercises. This approach ensures the training meets the
needs of both the group and individual participants.
|
Course contents
The Access Environment
Introduction to database terminology
Starting Access and opening a database
Database objects
Navigating around the ribbons
The Office button - trusted settings
The Quick Access toolbar
Adding extra database commands
Security warnings and online Help
Using Database Tables
Opening a table in datasheet view
The navigation pane
Moving around a table and entering data copying,
moving and deleting data
Undoing changes
Changing the layout and appearance of the data sheet
Finding and sorting data
Filtering data by selection
Filtering data by form
Saving a filter as a query
Creating New Databases and
Tables
Planning a new database
Creating a new database
Creating a database table
Setting default formats
The input mask
Setting default values for new records
Validating data entry
Setting up primary keys and indexing fields
Saving and modifying table structures
Using the lookup wizard
Setting relationships between tables
Referential integrity
Inserting subdatasheets
|
Designing Forms
Why create a form?
The Create ribbon
Types of form
Using AutoForm and the Form Wizard
Changing forms in design view
Adding fields to forms
Creating forms based on multiple tables
Changing subforms
Form and control properties
Form design menus
Setting filters on forms
Adding command buttons and other control objects on forms
Using Select Queries
What is a query?
The simple Query Wizard
Find Duplicates Query Wizard
Creating a query in Design View
Saving and printing queries
Queries with multiple tables
Joining tables in a query
Calculations and summaries in queries
Using queries in forms and reports
Reporting
Why design a report?
The Report Layout Tools ribbon
Using AutoReport
Using Report Wizards
Modifying reports in Design View
Sorting and grouping data
Some report and section properties
Mailing labels
Merge It with Microsoft Word
Analyse performance and table
|
