Access Level 1
This practical, hands-on course is designed for database users who need to acquire Access skills quickly and effectively. Practice tasks and case studies ensure that fundamental techniques can be applied quickly in a demanding financial and business environment.
No previous knowledge of Access is necessary, but you need to be able to manage and navigate Windows, save and retrieve documents and use a mouse to select data.
- Create a database containing related tables
- Create and identify relationships between tables and define referential integrity
- Work with data, including sorting and filtering records
- Select data with queries and control selection by setting criteria and parameters
- Define and run queries using multiple tables
- Add calculated fields to queries
Overview of Access:
The concept of a relational database; managing information effectively; working with databases and how Access objects work together to allow you to add, edit, find and report on information.
Creating databases and tables:
Creating a table; using the Table Wizard; defining field names and data types; overview of available data types; establishing a primary key; saving the table definition.
Setting field and table properties:
Validating data entry; using the Expression Builder; creating an index.
Creating relationships between tables:
An overview of relationships; defining and understanding one-to-one, one-to-many and many-to-many relationships; normalising data; working with the relationships window; setting referential integrity and related options.
Entering and editing information:
Opening and closing databases and tables; entering data in the datasheet; how records are saved; editing records; shortcuts for entering repeating information and dates; working with sub-datasheets.
Locating, filtering and sorting records:
Finding records; sorting records; sorting on more than one field; defining and applying filters; clearing filters and sorting.
Changing column widths; choosing the font; printing the datasheet.
Selecting data with queries:
Creating queries; refining selection by setting criteria and parameters; adding calculated fields to a query; querying multiple tables; creating summary queries; setting query properties; saving and running queries.
Introducing forms and reports:
Creating basic forms and reports using wizards