Microsoft Access 2010 Introduction

Course

In East Anglia and Cambridge

Save 25%
£ 150 VAT inc.

Description

  • Duration

    1 Day

Suitable for: Someone would like to learn how to use Microsoft Access

Facilities

Location

Start date

Cambridge (Cambridgeshire )
See map

Start date

On request
East Anglia (Cambridgeshire )
See map

Start date

On request

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

Course review:

In this course you will learn the basics of Microsoft Access 2010 and create and modify new databases and their various objects. You will also learn how to identify the basic components of an Access database, build the structure of a database, manage data in tables, query a database, design forms and generate reports.

Microsoft Access 2010 Training Course (Beginners) Outline -

Getting Started with Access Databases

  • Identify the Elements of the Access 2010 Interface
  • Identify the Components of a Database
  • Examine the Relational Database Design Process

Building the Structure of a Database

  • Create a New Database
  • Create a Table Using the Design View
  • Manage Tables
  • Establish Table Relationships

Managing Data in a Table

  • Modify Table Data
  • Sort and Filter Records
  • Work with Subdatasheets

Querying a Database

  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping

Designing Forms

  • Create a Form
  • Modify the Design of a Form
  • View and Edit Data Using an Access Form

Generating Reports

  • Create a Report
  • Add a Control to a Report
  • Format the Controls in a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

Additional information

Payment options: Credit Card Payments Accepted

Microsoft Access 2010 Introduction

£ 150 VAT inc.