Microsoft Access 2019

Introduction

What is the Microsoft Office Access 2019 course?

Microsoft Access is Microsoft’s popular database creation and management program. Databases are widely used to collate and manage customer information and survey results. They’re used in any situations where you need to store and analyse large amounts of data, reliably and efficiently.

We’re proud of our excellent rating on Trustpilot, with over 12,000 reviews from our past students.

Course code

R5DA

Location

Varies

Price

£35

Suitability

Is the Microsoft Office Access 2019 right for me?

This Microsoft Office Access 2019 course is ideal for you if you want to quickly understand Microsoft Access 2019 and help towards a potential job, promotion, running your own business, or for personal use.

Careers

How will the Microsoft Office Access 2019 course advance my career?

This course will help any Office Administrator or IT Administrator who utilises the Microsoft Access software to manage relational databases that are at the heart of business operations.

Why study with us

Why study the Microsoft Office Access 2019 online course with e-Careers?

We have developed an expert team over the last 10 years since our inception. In that time, we have trained over 625,000 delegates globally, which has helped offer the highest quality training, and we have earned a 5-star rating on Trustpilot, from over 12,000 students.

  • This great value three course package will take you from beginner to advanced level
  • If databases play a part in your current or potential job role, this course package contains all you need to achieve full proficiency
  • Take an official Microsoft exam, and match your skills to recognised standards

Course Details

What are the Microsoft Office Access 2019 online course modules?

  • Microsoft Access 2019: Introduction
  • Microsoft Access 2019: Intermediate
  • Microsoft Access 2019: Advanced

What does the Microsoft Office Access 2019 course cover?

  • The basics of working in the Access program
  • Key database terminology
  • Various ways of creating tables and practise setting the properties of their fields
  • Further analyse the data in a table through select queries, including the creation of calculated fields
  • Understand how to set relations between tables and ensure their referential integrity
  • Create simple forms and reports
  • Create calculated fields in queries that operate with functions
  • Practise creating totals queries and parameter queries
  • Properties of table joins and examine how they can affect the result of queries
  • Create forms in the Design view and insert calculated fields into them
  • Design and edit reports, and learn to perform various calculations in them
  • Learn how to insert controls into forms and reports, including subforums and sub reports.
  • Action queries
  • Different types of queries in the SQL view and get acquainted with the essential clauses of this language
  • Create and use macros to automate your work with databases
  • Importing and exporting of objects and their data
  • Printing options of different objects in detail
  • The normalisation of data
  • The options of navigation in a database

Other Courses at DGC

ICB Affiliate & Associate Certificate in Bookkeeping & Accounts (Level 2 & 3)

e-careers the home of professional qualifications. Book Today!

Course OverviewThis ICB Bookkeeping training package contains the ICB Level 2 Certificate in Bookkeeping and ICB Level 3 Certificate in Bookkeeping and Accounts, from ICB’s main qualifications in bookkeeping and accounts. The courses will provide the foundations in bookkeeping, teaching you skills including: The basic principles o...

Digital Marketing

This course is ideal for anyone who wants to understand the essentials of how to deliver an effective digital marketing campaign. Digital Marketing will be stripped back to its core; removing buzzwords and jargon, to ensure you leave with hands on knowledge that you can implement in your business.By the end of the day you will be able to...

Official CompTIA CySA+ Cyber Security Analyst (CS0-002 Cyber Security Series) Certification

e-careers the home of professional qualifications. Book Today!

Course OverviewThe CompTIA Cyber Security Analyst (CySA+) online course is a globally recognised, vendor-neutral certification that uses behavioural analytics to improve the overall state of IT security through preventing, detecting and combatting Cyber Security threats. CySA+ is the most up-to-date security analyst certification to cover...