Microsoft Access 2010 Introduction
Course
In East Anglia and Cambridge
Description
-
Type
Course
-
Location
-
Duration
1 Day
Suitable for: Someone would like to learn how to use Microsoft Access
Facilities
Location
Start date
Start date
Start date
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
Microsoft Access 2010 Introduction