COURSE FINDER

Access 2010 Developers

Categories: Microsoft Access
£880 per delegate. This may be less for special offers on specific course dates and in-company training courses

Duration: 3 days

Trainer: S047OW

Need course dates or locations to suit you? CLICK HERE TO SEND ENQUIRY...

Introduction

The first (and most important) part of any Access database is getting the design right, which is where this 3-day course begins. You'll learn about primary keys and relationships, and find out how to create an Access database consisting of multiple linked tables.

The course then goes on to show how to create queries (to display data from one or more tables) and a front-end to your system, using forms, reports and the VBA coding language.

If you've been given the job of creating an Access database - and you're not sure where to start - this is the course for you!

Prerequisites

You do not need to have used Access before to attend this course, although you should be a confident computer user.

Course Contents

Designing a database 

- Identifying the tables
- What are relationships?
- Setting a primary key
- Using multivalue fields

Creating tables 

- Defining fields
- The types of field
- Entering data

Different field types 

- Creating attachments
- Rich text format fields
- Date fields (using calendars)
- Calculated fields

Importing data 

- Importing from Excel
- Making tables from Excel

Table rules (*) 

- Record-level validation
- Basic triggers

Drawing relationships 

- Creating relationships
- Referential integrity

Creating queries 

- The query design grid
- Sorting
- Setting criteria
- Combining criteria

Advanced queries 

- Grouping and totalling
- Creating expressions
- Parameter queries

Joins 

- Creating ad hoc joins
- Types of join

Crosstab queries (*) 

- Columns, rows and values
- Overriding column headings

Action queries (*) 

- Making tables
- Updating records
- Appending records
- Deleting records

Creating forms 

- Layout and design view
- Using the form wizard
- Split forms
-Creating controls

Advanced controls (*) 

- Webbrowser controls
- Navigation bars
- Multitabs

Creating reports 

- Using the report wizard
- The group, sort and total pane
- Report design

Creating subforms 

- Multiple item forms
- Creating subforms
- Tidying up subforms

Basic VBA coding 

- Creating modules
- Using Project Explorer
- Writing comments
- Indenting code

Uses of VBA 

- Form validation
- Criteria forms
- A simple menu system

Please note that any items marked with a * will be covered if time allows.

Course Times

Usually 9.30am - 4.30pm. Course times will be confirmed in the joining instructions once the course has been booked.
The course either has new dates in data loading, or is only run as a dedicated or In Company course.
  • Corps Construct Logo
  • Safety & Health Logo
  • Hawks Logo
  • Know How Logo
  • SYNERGIETRAINING Logo
  • Induct Ltd Logo
  • Ace Safety Logo
  • 1UPACCESS Logo
  • BAM Construction Training Logo
  • Citrus Training Logo
  • 3B Training Logo
  • Astutis Logo
  • Construction Industry Training Providers Logo
  • MecSafe Logo
  • Health Life and Safety Logo
  • MI Construction Training Logo
  • Innov8 Training Logo
  • BSI Training Logo
  • OM Safety Training Logo
  • TotalComms Training Logo
  • SDA Safety Logo
  • Construction Skills People Logo
  • Phoenix Health and Safety Logo
  • Complete Health and Safety Logo
  • Harris Safety Training Logo
  • First Response Training Logo
  • Alliance Learning Logo
  • ALS Safety Logo
  • KeyOstas Logo
  • Libben Health and Safety Logo
  • Global Management Academy Logo
  • Illumine Logo
  • CCAS Health and Safety Logo
  • ROSPA Logo
  • PJH Safety Training Logo
  • OMS Logo
  • Tala Training Logo
  • PRS Health and Safety Training
  • SSG Training and Consultancy Logo
  • RB Services Logo
  • Safety Training Services Logo
  • Clarkson Evans Training Logo
  • Lighthouse Training Logo
  • The Building Safety Group Logo
  • ProSafety Logo
  • Total Training Solutions Logo
  • Kentec Training Logo
  • Total Electrical Training logo
  • NTSS logo
  • Safe Life Logo
  • Frinton Training logo
  • Envesca logo
  • The Safety Maintenance Company logo
  • APT Health and Safety logo
  • Sandwell Training Association logo
  • PC Workshops logo
  • Zero Harm Training logo
  • R2 Training logo
  • The Bradley Group logo
  • Risk Health and Safety logo
  • Wise Global Training logo
  • Smallpeice Enterprises logo
  • Total Training Company Logo
  • Sibbald Training logo
  • Highlander logo
  • Total Construction Training logo
  • e-testing logo
  • UTN Training logo
  • Collective Safety Solutions logo
Telephone Hotline (footer image)

Telephone Hotline

01933 233884

(Monday to Friday - 8:00am to 5:30pm).

© 2020 Book My Course Limited. All rights reserved

Home | About Us | Contact Us | FAQs | Privacy Policy | Terms & Conditions | Site Map | News / Articles | Cookie Policy