Access 2013 Core Essentials

Request more details:

This one-level workshop covers the skills that students will need to make the most of Microsoft Access 2013. The course begins with the basics and progresses through several modules which cover databases, tables and records, forms, reports, queries, and much more.

Cost: €295.00

Duration: 1 Day

Cork Date: 26 Jul, 12 Sep, 21 NOV

Dublin Date: 09 Aug, 18 Oct, 11 Dec

This course is also available as a customised client specific course.

Prerequisites:

Participants are expected to be IT literate. This is not an introduction to computers course

The Basics:

Getting Started
Signing In
Creating a Database
Database Terminology
Saving a Database
Opening a Database

Your First Database:

About Security Warnings
About Relationships
Searching for Objects
Opening Database Objects
Changing the Object View
Understanding the Types of Views Available
Managing Objects

Types of Queries
Creating a Query with the Wizard
Running a Query
Understanding Query Views
Sorting and Filtering a Query

Creating Advanced Queries:

Creating and Using Parameter Queries
Creating and Using Crosstab Queries
Creating and Using Make-Table Queries
Creating and Using Multiple Table Queries
Creating and Using Append Queries
Creating and Using Delete Queries
Creating and Using Update Queries

Managing Your Database:

Compacting and Repairing a Database
Encrypting a Database with a Password
Backing Up Your Database
Exporting a Database and Database Objects
Printing Database Objects