Training at Blue Novation

 

 

Since 1988, Blue Novation has designed and delivered exceptionally high standard training solutions to businesses in both the private and public sector. The quality of training we deliver is of paramount importance to us.

Our approach ensures that delegates enjoy their training whilst gaining the additional skills and knowledge to become more productive in the workplace.

Access Introduction

This intensive course is designed to give delegates an understanding of some of the major features and functions within Microsoft Access.

Course Topics

Access Basics

database terminology • relational databases • opening an existing database file • creating a new database file • the database window

Using Tables

the table window • adding/deleting a record • searching for specific records  copying information • editing data in a field • sorting records  resizing and moving columns and rows • freezing and hiding columns

Creating a Database Table

creating a table • the Primary key • data types for fields in a table • adding a field to an existing table input masks • data validation • field properties

Setting Relationships between Tables

types of relationships • creating the relationships • enforcing referential integrity

Database Forms

creating a form with the wizard • entering/editing information • adding/removing controls • changing a controls appearance • editing the form layout • creating a combo box

Querying Information

creating a single/multiple table query • adding criteria to select records

Creating Reports

creating a Report with the wizard • previewing and printing a report • creating a grouped and totals report • changing the appearance of a report

 

Follow on Courses

Access Intermediate
Access Advanced

Course Dates

Course Dates

On Request

Course Duration

1 day

Course Timings

9:30-16:30

Location

Ipswich

Prerequisites

Delegates must be experienced with using a mouse and working in the Windows environment.

Training Formats

Private course · tailored · 1 to 1 (all instructor led)

Manuals

A comprehensive course manual provides support throughout the course and upon your return to the office.

Not found the course you are looking for?

 

We can create a tailored workshop to suit your
specific business requirements. Get in touch to find out more.

BlueNovation_logo_WA

 

 

Address: Contact us on:
NG7 Columba House, Adastral Park, 0345 11 88 150Call now
Martlesham Heath, Ipswich, IP5 3RE Email us[email protected]