Microsoft Access 2016 - Beginner
Aspyra Training
Summary
Pay in Full or arrange payment by instalments directly with Aspyra
- Certificate of completion - Free
Add to basket or enquire
Location & dates
NOTTINGHAM
Nottinghamshire
NG73NN
United Kingdom
Overview
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.
Certificates
Certificate of completion
Digital certificate - Included
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
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.
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.
Career path
The natural progression is Access Intermediate.
Questions and answers
Reviews
Currently there are no reviews for this course. Be the first to leave a review.
Legal information
This course is advertised on reed.co.uk by the Course Provider, whose terms and conditions apply. Purchases are made directly from the Course Provider, and as such, content and materials are supplied by the Course Provider directly. Reed is acting as agent and not reseller in relation to this course. Reed's only responsibility is to facilitate your payment for the course. It is your responsibility to review and agree to the Course Provider's terms and conditions and satisfy yourself as to the suitability of the course you intend to purchase. Reed will not have any responsibility for the content of the course and/or associated materials.