MS Access Intermediate Course

PCWorkshops

Short course

Online

Save 10%
£ 260 VAT exempt

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Level

    Intermediate

  • Methodology

    Online

  • Duration

    1 Day

  • Delivery of study materials

    Yes

  • Personal tutor

    Yes

  • Virtual classes

    Yes

Expand your MS Access skills with this course

The MS Access intermediate course is the next step for anyone looking to further enhance their skills.
Online, Instructor-led, interactive, Practical.
1-day Course, Private 1-1

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

To understand table relationships and referential integrity. Be capable of making queries such as total queries, expression queries and action queries. Managing data, creating forms and reports.

People who need to do creative and in-depth queries of databases.

Previous experience with MS Access required.

Private 1-to-1

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Fill in your details to get a reply

We will only publish your name and question

Reviews

This centre's achievements

2018

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Access
  • Database
  • Database training
  • Tables
  • Reports
  • Forms
  • Queries
  • Data
  • Database Concepts
  • Data Retrieval

Teachers and trainers (1)

Sarah Barnard

Sarah Barnard

Coder, Instructor

Java Coding, Beginner - Advanced, JDBA, Hibernate, Spring. OO Programming. Android Studio. Excel VBA. Cobol. Databases, MS SQL Server, Oracle 11g, MySQL, Access Database, Excel, MS Power BI, Tableau, SSRS, MS SQL Server Report Builder.

Course programme

Access Intermediate Course Outline

Tables

  • Referential Integrity
  • Table Relationships

Queries

  1. Queries
  2. Wildcards
  3. Totals Queries
  4. Expression queries
  5. Action queries:
  • Make Table,
  • Inserting records
  • Append,
  • Update and
  • Delete Queries

Data

  • Importing Data
  • Exporting Data
  • Linking Data

Creating Forms

  • Creating forms, Form wizards
  • Creating a Navigation Form

Creating reports, On-screen and Paper / Pdf based. On screen queries via preprepared form

See related categories

MS Access Intermediate Course

£ 260 VAT exempt

The best Access courses

See all

See all