Course Schedule:
Please call 8622 8900 or
email us for further information
Overview
This course shows you how 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 method:
This course uses a combination of instructor presentation, and student hands-on practical exercises. Participants will have the opportunity to apply what they have learned in the classroom throughout the course.
Who will benefit from this course?
This course is intended 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.
Pre-requisites:
This course is designed for students with a basic knowledge of Microsoft Access 2003, especially building a database file and data tables. Completion of Course 715: Introduction MS Access or equivalent knowledge is essential.
What can you expect to gain from this course?
After completing this course, you will be able to:
- sort and filter data in a table
- change the way that data in a table appears
- use data validation techniques to protect the integrity of the data
- export records from Access
- export records to HTML for use on the Web
- create queries that prompt the user for input
- create fields in queries to provide additional information
- create different types of action queries
- understand table and query relationships and what effect they can have on your data.
- protect your database files from unauthorised access
- use the switchboard manager to create a menu system.
Course Content:
Module 1:Sorting & Filtering Table Data
- Simple sorting
- Sorting on several fields
- Creating a simple filter
- Clearing a filter
- Filtering by exception
- Filtering by form
Module 2:Formatting Table Data
- Changing column widths
- Changing column headings
- Formatting the datasheet
- Changing fonts
- Moving columns
- Freezing columns
- Hiding columns
- Un-hiding columns
- Assigning default values
- Marking a required field
- Validation rules and text
- Creating a lookup field
- Working with validations
Module 4:Exporting Records
- Copying a table
- Exporting a table to Microsoft Excel
- Exporting a table to a text file
- Exporting a filtered table
- Exporting selected records
- Creating an export query
- Exporting from a query
Module 5:Exporting To HTML
- Exporting a table to HTML
- Viewing an HTML document
- Exporting a report to HTML
- Creating hyperlinks
Module 6:Parameter Queries
- Creating a parameter query
- Displaying all records
- Using parameters to display a record range
- Nominating specific data types
- Using parameters in expressions
Module 7:Calculated Fields
- Creating a calculated field
- Formatting calculations
- Calculating across two tables
- Calculating dates
- Using criteria in calculations
- Concatenating string fields
- Creating a make table query
- Viewing a table created by make table query
- Expressions and update queries
- Preparing an update query
- Running an update query
- Creating a saved update query
- Running a saved query
- Creating a delete query
- Creating an append query
Module 9:Table & Query Relationships
- Understanding join types
- Using default joins
- Orphan records
- Viewing orphan records
- Deleting orphan records
- Creating an exception query
- Viewing a query In SQL
Module 10:Database Protection
- Setting a password
- Opening a file with a password
- Removing a password
- Encoding a database file
- Decoding a database file
- Hiding database objects
- Viewing and un-hiding an object
Module 11:Using the Switchboard
- Creating a switchboard
- Creating subsidiary menus
- Creating a menu item
- Returning to another menu
- Creating a number of menu items
- Linking the menus
- Modifying the menu forms
- Changing the startup