Home - Microsoft Office Training Courses - Microsoft Access 2010 Intro
Our introduction to Microsoft Access 2010 training course is designed for individuals who wish to learn the basic operations of the Microsoft Access Database program to perform their day-to-day responsibilities, and to understand the advantages that using a relational database program can bring to their business processes. Our introduction to Microsoft Access 2010 training course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database. It also provides the fundamental knowledge and techniques needed to advance to more complex Access responsibilities such as maintaining databases and using programming techniques that enhance Access applications.
Modules included on this course include how to identify the components of the Microsoft Access 2010 environment, how to identify the components of a database and organize data in tables, how to view data in tables, query a database, design forms and generate reports.
Duration: 1 day.
Location: 21st Century New Media Ltd, Elstree Film Studios, Shenley Road, Borehamwood, Hertfordshire, WD6 1JG. [Click here for a map]
Times: 10.00am to 4.30pm. For security reasons, further details are only provided upon booking.
Equipment: Our fully featured training room includes six top-of-the-range iMac computers configured to work in both Macintosh (OSX) and PC (Windows) modes, ensuring you the maximum familiarity with your chosen operating system.
Accommodation: Details of local accomodation can be found here.
Further assistance: Our FAQ help page contains the answers to many popular questions. Alternatively please call 0844 844 2428 to arrange to speak to our training manager.
COURSE CONTENT
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
5-15% discount if you book for more than one delegate!
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
Further discounts are available when booking multiple courses,
Please call our training secretary on 0844 844 2428.
