Course Code: IT 160
404 Course Visits
MS Office Access 2016 (Basic+Advanced)
Course Sector:
Information Technology
Course Dates and Locations
Choose a date and location to book your seat
No.
Date
Days
Location
Fees
Enrollment
01
28 Jul - 01 Aug 2025
5 Days
London, UK
$4,950
02
01 - 05 Dec 2025
5 Days
Dubai, UAE
$4,250
Introduction
Training course introducion / brief
Microsoft Office Access helps professionals to organize, collect and manage huge amount of data. It is an effective data management tool used to develop applications for company or any organization. This training course is designed to provide participants with the basic and advanced techniques in navigating MS Office Access 2016. 
This course covers topics such as managing data by creating database, designing forms and reports, creating subforms, and creating queries to join, filter, and sort data. This will allow participants to have a deeper understanding and skills of managing data and data entry, creating forms and dialog boxes, split databases, and much more.
Course Objectives
At the end of the training course, participants will be able to
  •  Be familiar with the ways of navigating Access 2016.
  • Manage data by creating a new database, constructing tables, designing forms and reports and creating queries to join, filter, and sort data.
  • Customize a form layout to improve usability and efficiency of data entry
  • Prepare a database for distribution to multiple users.
  • Make and modify a database switchboard and set the start-up options
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy. 
Course Audience
Who is this course for, and can benefit the most
  • Cloud Computing Engineer
  • Computer Network Specialist
  • Computer Support Specialist
  • Database Administrator
  • Information Technology Analyst
  • Information Technology Leadership
  • Information Security Specialist
  • Software/Application Developer
  • Web Developer
  • Technology sales consultant
Course Outline
The course aims and learning outcomes
Introduction to MS Office Access 2016 (Basic)
  • Getting Started with Access
  • Working with Table Data
  • Querying a Database
  • Using Forms
  • Generating Reports
Introduction to MS Office Access 2016 (Advanced)
  • Advanced Table Tasks
  • Advanced Form Tasks
Creating Subforms
  • Creating Split Forms
  • Creating Navigation Forms
Introduction to MS Office Access 2016 (Advanced)
  • Creating Advanced Queries
  • Using Subqueries
Creating Advanced Report
  • Splitting the Database
  • Add-Ons to Access
  • SQL and Microsoft Access
Providers and Associations
Providing the best training services and benefits to our valued clients
Boost certificate of completion
BOOST's Professional Attendance Certificate “BPAC” is always given to the delegates after completing the training course, and depends on their attendance of the program at a rate of no less than 80%, besides their active participation and engagement during the program sessions.
ENDORSED EDUCATION PROVIDER
Over all rating
Excellent
Average
Below average
Flexible deadlines
Customized dates accordance to your schedule
Shareable Certificate
Earn certificate upon completion
COURSE METHODOLOGY

Our Training programs are implemented by combining the participants' academic knowledge and practical practice (30% theoretical / 70% practical activities).

At The end of the training program, Participants are involved in practical workshop to show their skills in applying what they were trained for. A detailed report is submitted to each participant and the training department in the organization on the results of the participant's performance and the return on training. Our programs focus on exercises, case studies, and individual and group presentations.

Trending Courses
The most bespoke and flexible training courses
01
Sep
- 05 -
Days
Certified Business Analysis Professional- IIBA
Dubai, UAE
17
Feb
- 05 -
Days
Artificial Intelligence for Leaders
Abu Dhabi, UAE
10
Nov
- 05 -
Days
Practical Negotiation Skills for Contract Management
Jeddah, KSA
30
Jun
- 05 -
Days
The Risk Management Professional (PMI-RMP Exam Preparation)
Istanbul, Turkey
14
Sep
- 05 -
Days
Competitive Bidding: Understanding Procurement Bids
Riyadh, KSA
18
May
- 05 -
Days
Professional in Business Analysis (PMI-PBA Exam Preparation)
Jeddah, KSA
01
Sep
- 05 -
Days
Introduction to Machine Learning and Artificial Intelligence
Abu Dhabi, UAE
07
Apr
- 05 -
Days
IOSH Managing and Working Safely
Abu Dhabi, UAE
20
Jan
- 05 -
Days
Certified Treasury Professional
Dubai, UAE
13
Apr
- 05 -
Days
OSHA: Occupational Safety and Health Administration Standards
Riyadh, KSA
15
Dec
- 05 -
Days
The Business Analyst (PBA) - PMI Certified
Dubai, UAE
18
Aug
- 05 -
Days
ISO 55001 2014 Lead Auditor (Asset Management Systems) – Lead Auditor
Muscat, Oman
10
Feb
- 05 -
Days
The Scheduling Professional (PMI-SP Exam Preparation)
Dubai, UAE
24
Nov
- 03 -
Days
Happiness To Have and Hold
Dubai, UAE
20
Jan
- 05 -
Days
Leading and Building a Positive, Motivated, and Empowered Teams
Online, Virtual
10
Aug
- 05 -
Days
Emotional Intelligence and Advanced Communication Skills for Leaders
Salalah, Oman