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