• Professional Development
  • Medicine & Nursing
  • Arts & Crafts
  • Health & Wellbeing
  • Personal Development

Course Images

Microsoft Access Introduction  (live online classes)

Microsoft Access Introduction (live online classes)

  • 30 Day Money Back Guarantee
  • Completion Certificate
  • 24/7 Technical Support

Highlights

  • Delivered Online

  • Two days

  • All levels

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

About The Provider

Microsoft Office Training Ltd has been delivering training solutions for several years offering a variety of courses that cover all the apps of the Microsoft Office ranging fr...

Read more about Microsoft Office Training

Tags

Reviews