|
Course aim
This course is for users of databases created in Microsoft Access 2007
who need to manage the data.
Who should attend?
Delegates should be familiar with the Windows 95/98/ME/NT/2000 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 and Forms
Opening a table
Opening a form
Entering data
Copying, moving and deleting data
Undoing changes
Finding and sorting data
Filtering data by selection
Filtering data by form
Saving a filter as a query
|
Using Select Queries
What is a query?
The Simple Query Wizard
Creating a query in Design View
Query selection criteria
Saving and printing queries
Queries with multiple tables
Table joins within queries
Calculations and summaries in queries
Reporting
Why design a report?
Using Report Wizards
Modifying reports in Design View
Sorting and grouping data
Calculated fields on reports
Total fields on reports
Some report and section properties
Mailing labels
Charts
Merge It with Microsoft Word
Analyze table and performance
|
