Microsoft Access

Excel With Business

Course

Online

£ 59 VAT inc.

The best Access courses

See all

See all

Description

  • Type

    Course

  • Level

    Intermediate

  • Methodology

    Online

  • Class hours

    10h

  • Duration

    Flexible

  • Online campus

    Yes

  • Delivery of study materials

    Yes

  • Support service

    Yes

  • Virtual classes

    Yes

From creating custom web apps and tracking assets to organising contacts and managing inventory, you’ll master Access 2013 with this 10-hour video training course.
Microsoft Access is a database program that allows you to manage your data in the most efficient way possible. From creating custom web apps and tracking assets to organising contacts and managing inventory, the incredible range of functions will transform how you manage data.

Best of all, it is easily accessible to anyone with just a basic knowledge of spreadsheets.

We’ll take you from complete beginner to intermediate user in just 10 hours on this video training course.

Facilities

Location

Start date

Online

Start date

Different dates availableEnrolment now closed

About this course

How to set-up a database—on your desktop, or on the web.
How to add records, and save and delete data.
To explore the Ribbon interface and how to work with touch devices.
To use table templates to create forms and add custom elements.
To sort data and run queries.
Macros and how they work.
How to import data from external sources.

CPD UK

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

2019

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 4 years

Subjects

  • Access
  • Web
  • Microsoft Access
  • Getting started
  • Interface
  • Toolbars
  • Ribbon
  • Key Tips
  • Shortcuts
  • Keyboard
  • Access Options

Course programme

Syllabus:

Section 1: Foundation
  • Unit 1.1 - Introduction
  • Unit 1.2 - Getting Started
Section 2: The User Interface
  • Unit 2.1 - The Ribbon and Toolbars
  • Unit 2.2 - Keyboard Shortcuts and Key Tips
  • Unit 2.3 - Access Options
Section 3: Tables, Forms & Data
  • Unit 3.1 - Tables
  • Unit 3.2 - Importing Data
  • Unit 3.3 - Backup, Restore, and Repair
  • Unit 3.4 - Datasheet View
  • Unit 3.5 - Relationships
  • Unit 3.6 - Forms
  • Unit 3.7 - Subforms
Section 4: Queries, Expressions and Reports
  • Unit 4.1 - Queries
  • Unit 4.2 - Expressions
  • Unit 4.3 - Reports
  • Unit 4.4 - Printing
Section 5: Data Types and Form Controls
  • Unit 5.1 - Data Types
  • Unit 5.2 - Form Controls
Section 6: Streamlining workflow
  • Unit 6.1 - Modal, Dialogs, and Macros
  • Unit 6.2 - Web App Basics
  • Unit 6.3 - Exporting
  • Unit 6.4 - Application Parts
  • Unit 6.5 - Advanced Access Options
  • Unit 6.6 - Info Tab
  • Unit 6.7 - Security
Section 7: Closure
  • Unit 7.1 - Conclusion

See related categories

Microsoft Access

£ 59 VAT inc.

The best Access courses

See all

See all