More

MS Access 2010: Complete

PRICE
£39.00 (inc VAT)
£32.50 (ex VAT)
Credit cards
Quantity
Details

Buying for business and need more details? Find out how eCourses can help.

DISCOUNTS ARE AVAILABLE FOR THIS COURSE
Buy 5 or more copies of this course to qualify for a bulk discount. Simply select the number of people who require training, and your discount will be applied when you check out.

Overview

Are you looking to improve your knowledge of Access 2010? This course collection is ideal if you're a beginner or want to increase your knowledge. It will take you through the full range of functionality, from beginner level to using the advanced features and applications. Learn how to perform tasks at your own pace by following easy step-by-step actions and complete your training in bitesize chunks. Bookmarking allows you to dip in and out, so you can learn whenever suits you, plus you can jump directly to specific topics of interest quickly and easily.

MS Access 2010: Complete

Details

Using interactive exercises and software simulations, you’ll quickly become familiarised with the Access 2010 environment and its documents, functions and features. The course modules are:

MS Access 2010: Introduction - In this course, you will become familiar with the basics of using the Microsoft Access program. You will learn how to use and design tables and create various types of queries over them for purposes of an effective information retrieval.

MS Access 2010: Intermediate - In this course, you will learn advanced techniques of designing tables and queries. You will acquaint yourself in depth with the creation and use of forms.

MS Access 2010: Advanced - This course focuses on the creation of reports, data access pages and macros. It will also familiarise you with the options for database management, data import and export, as well as with the SQL language.

Modules

MS Access 2010: Introduction

  • Introduction to databases; The Microsoft Access environment; Table creation in datasheet view; Table design view; Special field types
  • Work within extensive tables; Looking up and editing data; Data sorting and filtering; Designing databases
  • Field selection and data sorting via queries; Work with criteria for select queries; Calculated items
  • Analysis of table relations; Relationships and referential integrity; Linked tables in queries; Relation features
  • Lookup column; Queries with parameters; Functions and formula creator


MS Access 2010: Intermediate

  • Field indexing and data validation; Totals; Aggregate functions; Crosstab query; Action queries
  • Data normalization; Make-Table query; Form creation using wizard; Working with form; Creating forms in design view
  • Working with form controls; Calculated form fields; Combo Box in forms; Option buttons in forms
  • Organising Form fields; Creating a Form with a subform; Subform insertion in design view; Form as a user interface

MS Access 2010: Advanced
  • Report creation; Reports with calculations; Graphical editing of Reports; Additional report options; Pivot table and chart
  • Object dependencies and properties inheritance; Macro basics; Assigning a macro to a button; Data validation using macros; Data evaluation via macros
  • Database print and documentation; Importing Access Objects and splitting a database; Data exporting; Program import and export; XML format
  • Navigation in a database; Security and privacy in databases; SQL language

Certificate

learndirect certificate will be emailed to you when you have successfully completed the course.

Quantity
Details

Buying for business and need more details? Find out how eCourses can help.

DISCOUNTS ARE AVAILABLE FOR THIS COURSE
Buy 5 or more copies of this course to qualify for a bulk discount. Simply select the number of people who require training, and your discount will be applied when you check out.

×