Associated Courses

Excel 2013 Core Skills

Word 2013 Core Skills

Outlook 2013 Core Skills

PowerPoint 2013 Core Skills

pdfCourse Outline

Duration

2 Day

Price

£400 per person

Pre-Requisites

No knowledge of Microsoft Access 2013 is assumed.

Course tailoring service

Our tailoring service is a luxury you can afford, allowing you to combine elements of related courses producing a bespoke
solution, designed specifically to fulfil your training needs. Is there any better way to meet all of your training objectives and maximise your training ROI?

Kit supply

Running a course at your facilities might sound like a good idea until you start thinking about the practicalities of equipment usage and the
impact this could have on day to day business, so why not let us bring the necessary
equipment with us?

Access 2013 Core Skills

Learn how to

Content

Overview of Access 2013
Introduction to Database Concepts and Terminology
An Introduction to Access 2013
The Access 2013 Interface
Database Planning and Design
Creating a Database

Principles of Table Design
Normalizing Data
Normalizing Data for Fourth and Fifth Normal Forms
Analyzing Table Relationships
Establishing and Testing Referential Integrity

Creating Tables
Examining a Table
Access Data Types
Creating a Table with the Table Wizard
Creating a Table in Design View
Types of Primary Keys

Working with Tables
Adding Records
Modifying the Table Design
Finding and Editing Records
Deleting, Adding, and Copying Records and Values
Filtering and Sorting the Data Sheet

Data Integrity
Preventing Blanks
Preventing Duplicates
Creating Input Masks
Validation Rules
Using a Lookup

Using Select Queries
Selecting Fields and Sorting Records
Refining the Results of a Query
Using Queries to Perform Calculations
Joining Tables in a Query

Query Joins and Crosstab Queries
Joining Tables and Working with Join Properties
Creating Crosstab Queries
Editing Limitations in Query Datasheets

Changing Data with Queries
Update Queries
Append Queries
Delete Queries

Creating and Using Forms
Creating a Form
Modifying the Form Design
Using a Form to Locate and Organise Information
Multiple-Table Forms
Performing Calculations on a Form
Adding Combo Boxes to a Form
Adding Unbound Controls

Using Advanced Form Techniques
Organising Field Placement
Using Functions to Control Data Entry
Adding an Option Group to a Form
Using a Form as the User Interface
Creating a Form that Contains a Subform
Creating a Navigation System

Creating and Using Reports
Creating a Report
Creating a Report that Contains Totals
Working with Subreports
Working with Groups

Maintaining a Database
Managing a Database and its Objects
Database Maintenance
Securing a Database