|
 |
 |
 |
 |
 |
 |
|
|
|
 |
|
|
Microsoft Access - Level 2 |
|
|
 |
|
|
|
 |
 |
 |
|
 |
 |
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
 |
|
The skills and knowledge covered in this course are sufficient to sort, filter, and query data, to validate data prior to data entry, and to build a small menu system to manage a database.
Learning Outcomes:
At the completion of this courseware participants will be able to:
• sort and filter data in a table
• format data in tables
• use a range of data validation techniques to protect data integrity
• export records from Access
• export records to HTML for use on the Web
• add parameters to queries to capture criteria data
• add calculated fields to queries
• create action queries to make tables, and update, append, and delete records
• understand table and query relationships and how they affect the integrity of your data
• protect your database files against unauthorised access
• use the Switchboard Manager to create a menu system.
Course Content:
• Sorting & Filtering Table Data
• Formatting Table Data
• Data Validation
• Exporting Records
• Exporting To HTML
• Parameter Queries
• Calculated Fields
• Action Queries
• Table & Query Relationships
• Database Protection
• Using The Switchboard
Target Audience:
This course is primarily designed for people who need to know how to work with data in existing databases. It is ideal for people who work in offices, clubs, schools, and offices and who need to know how to manage and manipulate database data.
Duration:
1 Day
Courseware:
High quality learning materials are available for purchase by participants. Participants will also be presented with a certificate of achievement upon completion of the course.
|
|
|
|
|
|
 |
 |
|
 |
 |
 |
 |
|
 |
 |
|
|
|
|
