IT Computer Training Courses Edinburgh, Glasgow, Scotland: Microsoft Access Level 1 Computer Training: iTrain Scotland: Microsoft Office 2016 Training, Adobe Training, Windows 10 training, Office 2013 training, Computer Courses, Computer training room equipment hire

Classroom with tutor
or
Live virtual classroom

1 Day

Training Options:

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Classroom with tutor
or
Live virtual classroom

1 Day

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Public Schedule

Onsite anywhere in UK

Company course

Tailored content

Microsoft Access Level 1

Suitable for versions 2016 / 2013 / 2010

Whether you are a new user or have been using Access for years, this course will vastly increase your understanding of Access. Existing users will learn how to get the most out of Access, break any bad habits, learn shortcuts and discover a massive range of hints and tips from our expert Access trainers.

Course content

Prerequisites

This course is aimed at those people who will be designing a database from scratch or maintaining an existing database.

Course goals

Delegates will learn fundamental principles of relational database concepts and the use of these concepts when designing and building a database in Microsoft Access. Delegates will also learn shortcuts and tips about how to use Access in the most efficient way.

Topics

Getting Started

Relational Database Concepts
Relationships
Planning a database
Using Access to design and build a database

Creating Tables

Naming Conventions
Field Names
Data Types
Lists
Assigning a Primary Key Field
Field Properties

Datasheet view

Record Entry
Cancel Record
Modify Record
Delete Record
Format Datasheet
Print/Preview
Hide/Show
Sort
Find

Filters

Edit/Sort
Apply
Field Selection
Advanced Filter

Forms

Wizard
Create
Auto Form
Add Record
Views
Design Form
Design Layout
Toolbars
Controls
Selection Techniques
Align Control
Align Text
Vertical Spacing
Horizontal Spacing
Grids
Colour Palette
Adjust Tab Order

Enhancing a Form

Adding Fields
Combo Boxes
List Boxes
Calculated Fields
Modify Properties

Queries

Creating in design view
Using search criteria
Comparison Operators
Wildcards
Parameter Queries
Totals Queries
Calculated Fields
Multiple tables
Joins in tables

Understanding Relationships

Primary Keys
One-to-Many
Relationship Diagram

Basic Reports

Using Wizards

Office 2016 features

What's new
Cloud storage and OneDrive
Office 365
Signing-in to Office 2016
Using Office 2016 on multiple devices
Easier file sharing
Views are Easier to Modify
Callouts for Setting Properties
Related Items Control
AutoComplete Control
Drill-Through Links
Getting Started Window
Office Backstage View
Navigation Pane
Status Bar
Tabbed documents
File Type
Formatting
New Table Features
Sorting and Filtering
Datasheet Total Row
Adding Fields
New Form and Report Features
Quick Create
New Layout Views
New Report View
Group and Sort
Stacked and Tabular Layouts

Prices

Prices below are for scheduled courses held in our Edinburgh Training Centre or Live Virtual Classroom. Major discounts available for onsite or private courses: click General Enquiry button below to enquire about private courses.

Group discount

1 place £ 205 n/a

2 places £ 410 n/a

3 places £ 615 £ 565

4 places £ 820 £ 665

5 places £ 1025 £ 765

6 places £ 1230 £ 865

7 places £ 1435 £ 965

8 places £ 1640 £ 1065

		Group discount
1 place	£ 205	n/a
2 places	£ 410	n/a
3 places	£ 615	£ 565
4 places	£ 820	£ 665
5 places	£ 1025	£ 765
6 places	£ 1230	£ 865
7 places	£ 1435	£ 965
8 places	£ 1640	£ 1065