Access Introduction
Who is the course for?
If you find yourself needing to know more about what an Access database can do, this course will give you a good overview; providing practical hands-on experience with its many features.
You will finish the course with a good general knowledge on Access and how you can use it to meet your needs.
What the course will cover:
Database Overview / Terms / Planning
An overview of databases, database objects and terminology, tables, queries, forms, & reports, and relationships
Working with an existing database
- Navigating around an existing database (mouse and keyboard)
- The ribbon, window and navigation pane
- Finding help
- Opening and closing exiting tables, database and access
- Filtering & sorting data in a table
- Sorting Data, Finding & Replacing Data (using wildcards)
Working with Tables
- Creating a new simple Access database
- Design/table view
- Creating a table structure
- Formatting field properties
- Defining a Primary Key
- Editing field properties and field descriptions
- Validation Rules/text
- Adding a new field to a table
- Insert, Delete, Move and Rename Fields
- Deleting a table
- Entering and Editing Data
Queries and Filters
- Query Overview
- Sorting records
- Using filters
- Filtering by form
- Running Query
- Creating a Query
- Modifying a Query – adding, removing fields to a query and deleting a query
Creating Forms
- Creating Forms Using the Form Wizard
- Quick forms
- Designing a form
- Data Entry in Forms
- Editing form design
- Filtering from a form
- Deleting from a form
- Changing the look of forms
Reports
- Overview of Reports
- Quick report
- Creating a Report using Wizard
- Printing a report