Microsoft Access 2019

by South And City College Birmingham Claim Listing

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.

Price : Enquire Now

Contact the Institutes

Fill this form

Advertisement

South And City College Birmingham Logo

img Duration

Please Enquire

Course Details

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. 

 

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
  • Birmingham Branch

    Digbeth Campus High Street Deritend, Digbeth, Birmingham

Check out more MS Access courses in UK

The Finance and Management Business School Logo

Certificate in IT User Skills Level 1

This course is aimed at learners who can already send and receive emails, or browse the internet but now want to gain the skills needed to work in a modern office. You will learn to use the most commonly used Microsoft Office programmes.

by The Finance and Management Business School [Claim Listing ]
Olas Logo

Microsoft Access

Microsoft Access course is offered by Olas. Olas uses a variety of delivery methodologies and believe a blended learning approach leads to the participants retaining the knowledge learnt through the learning event.

by Olas [Claim Listing ]
Acuity Training Logo

Introduction to PowerPoint Course

This 1-day Introduction & Intermediate PowerPoint training course is the quickest way to master the basics of PowerPoint. It is a hands-on course designed for beginners. It includes plenty of time for experimenting with what you are being taught, trying things out for yourself and asking question...

by Acuity Training
Berkeleyme School of Management and Sciences Logo

Certificate In Application of MS. Excel (Advanced Level)

This certification is awarded by Berkeley – a US based corporate training body which is an established name in training and coaching especially in Accounting, Finance and Financial Reporting.

by Berkeleyme School of Management and Sciences [Claim Listing ]
Etopia Training Logo

Microsoft Access (Intermediate)

A hands-on instructor-led Microsoft Access training course helping people wanting to improve existing Access skills to enhance a database by creating more advanced queries, forms and reports. 

by Etopia Training [Claim Listing ]

© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy