Access Database Design 1

Training

In London

£ 220 + VAT

Description

  • Type

    Training

  • Location

    London

  • Duration

    1 Day

To give users additional skills and knowledge on using the many features and functions of Access to make them more efficient and effective when processing data. Delegates will gain experience in producing database applications and the ability to create a variety of data views, queries and reports. Suitable for: This course is suitable for existing users of Access who want to get to grips with some of the more advanced features of this package as quickly as possible.

Facilities

Location

Start date

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

Start date

On request

About this course

Familiarity with the basic features of Access is required, gained either by previous experience or by attendance on an "Access Data Processing" 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 1- intermediate/advanced)
Course outlines
Database Design
What is a Relational Database?
Primary and Foreign Keys

Relationships
Database Normalisation
Theory Of Normal Forms
De-Normalisation
Naming Conventions
Designing Table Structures
Table Design - Hints And Tips
Creating Tables
Switching between views
Saving Tables
Field Properties
Field Size Property
Format And Input Mask Properties
Caption Property
Allow Zero Length Property
Indexed Property
Using Field Properties For Protection
Objectives
Required
Default Value
Input Mask
Validation Rule And Validation Text
Lookups
Table Relationships
What Is A Relationship?
Relationship Types
Creating And Editing Relationships
Using Lookups For Referential Integrity
Multi-Table Datasheet View
Price £220+VAT
Queries
Multi-Table Queries
Calculated Fields
Adding A Calculated Field To A Query
The Expression Builder
Calculating Summary Information
Crosstab Queries
General Query Properties
Checking Referential Integrity
Advanced Queries
Parameter Queries
Formatting Query Output
Query Join Types
Self Joins And Aliases
Cross Joins
Action Queries
What Is An Action Query?
Planning An Action Query
Make Table Queries
Append Queries
Delete Queries
Update Queries
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 DatabaseSetting A Database Password
Encrypting And Decrypting A Database








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 1

£ 220 + VAT