Description

Course Objectives

At the end of this course you will be able to:

Identify the common objects of an Access database

Design and build the structure of a database

Input and maintain data

Design user-friendly data entry forms

Search the database using queries

Generate reports from your data

1 year email support service

Take a look at the consistent excellent feedback from our corporate clients visiting our site ms-officetraining co uk

With more than 20 years experience, we deliver courses on all levels of the Desktop version of Microsoft Office and Office 365; ranging from Beginner, Intermediate, Advanced to the VBA level.

Our trainers are Microsoft certified professionals with a proven track record with several years experience in delivering public, one to one, tailored and bespoke courses.

Tailored in company training courses:

You can choose to run the course exactly as they are outlined by us or we can customise it so that it meets your specific needs. A tailored or bespoke course will follow the standard outline but may be adapted to your specific organisational needs.

Introducing Microsoft Access

The Access interface

Database terminology

Access database objects

Fields and records

Properties

Designing a database

Planning and designing a table

Creating fields

Setting common field properties

Defining key fields

Working with table data

Entering and editing data

Sorting and filtering table records

Deleting records

Relationships

Why use table relationships?

Relationship types

Referential Integrity

Working with table subdatasheets

Querying a database

Creating simple Select Queries

Specifying query criteria

Sorting query results

Adding calculated fields

Designing Forms

Creating simple forms for data entry

Designing custom forms

Working with form sections

Creating sub forms

Designing Reports

Creating basic list reports

Working with grouping and sorting in a report

Adding totals to a report

Who is this course for? Who is this course for?

This course is intended for the user that wants to explore the creation of a relational database. It will focus on the structuring of the database itself and the creation of the basic functional elements of a database in order to manage data.

Requirements Requirements

Microsoft Office know-how can instantly increase your job prospects as well as your salary.

80 percent of job openings require spreadsheet and word-processing software skills

Career path Career path

Microsoft Office know-how can instantly increase your job prospects as well as your salary.

80 percent of job openings require spreadsheet and word-processing software skills

Course Images

Microsoft Access Introduction (live online classes)

By Microsoft Office Training

Booking options

Highlights

Description

About The Provider

Tags

Reviews