Microsoft Access: Introduction for Beginners (2 day)

Course Overview

The course introduces the delegates to the fundamental skills required to build and use a simple Access database. It is specifically designed for the first time user and those that are self-taught. It will act as an ideal stepping-stone to attending the more task based Access courses we offer.

The foundation skills will be explored through the creation of an Access database encompassing several tables (not related) and forms for data entry and manipulation. Simple queries and reports will be used to select and print reports.

The course is designed to provide an understanding and use of the four main objects (Tables, Forms, Queries & Reports). Each section will provide the delegate with the knowledge to be able to be productive on their return to work.

This Microsoft training course will help you stay competitive, sharpen your skills and could enhance your Microsoft career prospects.

Related Courses

• Microsoft Access: Advanced (1 day)
• Microsoft Access: Queries (1 day)
• Microsoft Access: Introduction, Advanced and VBA Programming in 5 days
• Microsoft Access: Introduction for Beginners
• Microsoft Access: Intermediate
• Microsoft Access: Advanced
• Microsoft Access Consultancy

Audience

• New users who are starting to use Access for the first time and require a basic understanding of the product.
• Current Data Entry Users who would like to expand their knowledge into the other elements of Access.

Skills Gained

By the end of the course the delegate will be able to:

• Understand the concept of database design
• Create tables to store data
• Produce forms for data entry
• Append, find and edit data in a table and form
• Produce queries to extract only specific records
• Share the data with others on a report

Prerequisites

• No prior knowledge of Access is required
• Delegates need to be familiar with working in a Microsoft Windows environment i.e. mouse skills, working with multiple windows and screen elements such as scroll bars, menu bars and toolbars.

Course Outline

Access Overview

• What is a database
• Object explanation
• Role Definition

Access Objects

• Moving between objects

Planning and Designing Databases

• Database Objective
• Scope Document

Planning and Designing Databases - Tables and Forms

• Document table structure
• Field Types - Text, Number, Date, Yes/No, Memo and AutoNumber
• Identify Field Sizes
• Identify the Primary Key
• Form Considerations - Data Entry

Creating Tables

• Building and Modifying Tables
• Screen Familiarisation
• Field Descriptions
• Assigning the Primary Keys
• Assigning Data Types
• Assigning Field Sizes

Building and Modifying Forms

• Create a form with the Form Wizard
• Basic Editing of Forms

Data Management

• Appending Records
• Delete records
• Editing Data

Views

• Switching between Design and View

Finding, Filtering and Sorting

• Find a record
• Filter by selection
• Sort records

Select Queries

• Data Sources
• Field Selection
• Selection Criteria Overview
• Show/Hide
• Logical Operators

Reports

• Create a report with the Report Wizard
• Preview and print a report Screen Familiarity