Access Training for Advanced Users

Taylor Mason Training

Course

Online

£ 949 VAT inc.

The best Access courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    8h

  • Duration

    1 Day

  • Start date

    Different dates available

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

Access 2007 is a database management program that makes it easy to store and find information, analyse data and create accurate reports. This course takes you step by step through advanced database tasks using Access 2007. Together with our Access 2007
Introductory-level course, this also supports the background learning for the Microsoft Certified
Specialist Exam (MCAS) 77-605.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now open

About this course

identify, set and modify data types
understand field properties and create input masks
use data validation rules, create field lookups and set default data values create and manage table relationships
create simple and advanced queries work with forms and subforms
create and format reports
import and export data and use external data sources

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

Subjects

  • Database
  • Database training
  • Queries
  • Advanced
  • Controls
  • Creating
  • Subforms
  • Expressions
  • Design
  • Calculated
  • Macros
  • Importing
  • Exporting

Course programme

Modules:

There are 15 modules in this course:

Data Types Field Properties Table Relationships Queries
  • Action Queries
  • Advanced Query Options
  • Adding Controls Creating Subforms Expressions and Tab Order
  • Creating Reports in Design View Report Wizard and Page Breaks Using Calculated Controls Creating Macros
  • Importing and Exporting
  • Linking to External Data Sources
How this course can help your business:
  • Make the most of your investment in IT
  • Use databases to store, manage, sort and analyse information Make sound business decisions based on accurate information Store customer records securely
  • Improve communication by providing staff with better access to information
  • Capitalise on and manage the knowledge, experience and information contained within your business

See related categories

Access Training for Advanced Users

£ 949 VAT inc.

The best Access courses

See all

See all