Access 2010 - Introduction level

View our full Access Course Schedule or call 0845 485 1173 today for more details

You can view this course outline as a PDF for printing

Access 2010 Introduction

1 Day Course

Objectives

By the end of the day you will know how to:

• Understand basic database concepts
• Plan and design databases
• Create tables
• Alter tables
• Create and edit records
• Create and modify queries
• Create and modify forms
• Create and modify reports

Prerequisites

• A basic understanding of Microsoft Windows, and familiarity with a keyboard and mouse

Course Contents

Unit 1: Getting started

• Topic A: Database concepts
• Topic B: Exploring the Access environment
• Topic C: Getting help

Unit 2: Databases and tables

• Topic A: Planning and designing databases
• Topic B: Exploring tables
• Topic C: Creating tables

Unit 3: Fields and records

• Topic A: Changing the design of a table
• Topic B: Finding and editing records
• Topic C: Organizing records

Unit 4: Data entry rules

• Topic A: Setting field properties
• Topic B: Working with input masks
• Topic C: Setting validation rules

Unit 5: Basic queries

• Topic A: Creating and using queries
• Topic B: Modifying query results and queries
• Topic C: Performing operations in queries

Unit 6: Using forms

• Topic A: Creating forms
• Topic B: Using Design view
• Topic C: Sorting and filtering records

Unit 7: Working with reports

• Topic A: Reports
• Topic B: Modifying and printing reports

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message