Access Database Design 2

Training

In London

£ 220 + VAT

Description

  • Type

    Training

  • Location

    London

  • Duration

    1 Day

To give users an insight into some of the more advanced features in Access. Delegates will gain further understanding of database design principles, advanced forms, reports and query design, including using calculations. Suitable for: This course is suitable for existing users of Access who want to customise forms, queries and reports.

Facilities

Location

Start date

London
See map
100a Chalk Farm Road, NW1 8EH

Start date

On request

About this course

Participants on this course should have a good working knowledge of Access, gained from prior attendance on an "Access Database Design 1" course

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

Access – Database Design


(Part 2- Intermediate/Advanced)
Course outlines
Forms
What is a Form?
Form Sections
Form Controls
Form Control Layout
Using Form Controls
Control Properties
Control Wizards
Multiple Table Forms

Advanced Form Design
Using Advanced Forms Features
The Form Worksurface

Creating a Calculated Control

Adding a Graphic to a Form

Multi-Table Forms

Using the Subform Control

Switchboard Forms


Access And The Internet


Using Hyperlinks

Using Hyperlinks in Forms

Exporting Datasheet Views to Html

Data Access Pages


Reports


Using Report Wizards as the Basis for Reports

Report Sections

Report Controls

Report Control Layout

Using Specific Controls

Publishing Datasheet Views on the Internet

Adding Hyperlinks to Datasheet Views

Adding Hyperlinks to Html Pages


Advanced Report Design


Applying Sorting and Grouping to Reports

Performing Calculations on Reports

Adding a Graphic to a Report

Using the Subreport Control

Modifying Section Properties

Using the Chart Wizard


Importing, Exporting, and Linking Data


Importing From other Data Sources

Linking Data

Exporting Data


Database Management Tools


Database Administration

Documenting the Database Structure

Backing up and Restoring a Database

Compacting and Repairing a Database

Setting a Database Password

Encrypting and Decrypting a Database

Fee £220+VAT

Additional information

Support: Pass training may be able to help pay for individuals booking alone, or people on income support or other similar benefits. Discounts are also available to companies.
Payment options: All Courses can be held privately at our premises or otherwise.

Access Database Design 2

£ 220 + VAT