Microsoft Access 2016 – Beginner

From £240.00

This course is an introduction to Microsoft Access 2016 and is designed for learners who have not previously used Access and might be unfamiliar with database software in general. It introduces delegates to the basic concepts of a relational database system as well as some of the things that are possible with Microsoft Access, including creating database systems, entering and deleting data in database files, producing information in forms and reports and generating queries.

Description

 


Course Code ASR01856

 

This Microsoft Access 2016 Beginner course is  designed for learners who have not previously used Access and might be unfamiliar with database software in general. It introduces  learners to the basic concepts of a relational database system as well as some features that are possible with Microsoft Access, including creating database systems, entering and deleting data in database files, producing information in forms and reports and generating queries.  This is an interactive course, packed with exercises and provides a good foundation on which to continue learning and creating databases with Microsoft Access.   Upon completion of the course, delegates will be able to:

 

  • Understand how to use and navigate your way around  Access
  • Using lookup tables to design databases
  • Use Access 2016 to create database structure
  • Modify the structure of existing tables and use the attachment data type
  • Find and replace data and delete records
  • Add records to new tables
  • Add transitional records to lookup databases
  • Work with records in database tables
  • Sort and filter records in table
  • Create queries, and sort and filter the results
  • Modify queries and perform operations in queries
  • Create, modify, and work with forms and use formsto sort and filter records
  • Create reports and  modify and print reports
Type Details
Delivery Method Direct delivery via tutor-led training session, offering you interactive training in a small classroom setting.  Packed with exercises and hands-on experiences, this course enables you to apply what you have learnt back in the workplace and professionally.
Entry Requirements
This course assumes that you have little or no knowledge or experience of using the Excel 2016 software. A general understanding of personal computers and the Windows operating system environment would be beneficial.
Progression The natural progression is Access Intermediate.
Duration 9:30 am to 4:30 pm
Location Aspyra Training: 46-48 Alfreton Road Nottingham NG7 3NN.  Alternatively, Aspyra can also deliver the training in your location or on your own site at a mutually convenient date and time.  Offsite rates apply.

Additional information

Weight 1 kg
Course Dates

15 January 2024, 19February 2024, 18 March 2024, 15 April 2024, 20 May 2024, 17 June 2024, 15 July 2024, 19 August 2024, 16 September 2024, 21 October 2024, 18 November 2024, 16 December 2024

Delegates

Delegates x 1, Delegates x 2, Delegates x 3, Delegates x 4, Delegates x 5, Delegates x 6

Reviews

There are no reviews yet.

Be the first to review “Microsoft Access 2016 – Beginner”