KHDA Approved | Telephone: +971 4 4356074|info@bostonmc.com

MS Access Level 1

/MS Access Level 1
MS Access Level 1 2019-08-07T15:04:04+00:00

Microsoft Access Level 1 – Office 2016/Office 365

This training enables the delegates to use this MS Access database application to enter, store, and retrieve data for referencing and creating reports. This Microsoft 2016/Office 365 Suite application can handle a large amount of data. This training course delivers the knowledge & skills to input data into forms and tables, retrieve results through queries and present data in the form of reports. The graphical user interface facilitates the user to import or link data stored in different databases and application. Join this hands-on training in Dubai.

MS Access Training in Dubai

2 Days

Microsoft Access

7 PDUs

Personal Development Unit

MS Access Level 1

STARTING MICROSOFT ACCESS

  • Orientation to Microsoft Access
  • Create a Simple Access Database
  • Get Help in Microsoft Access

WORKING WITH TABLE DATA

  • Modify Table Data
  • Sort and Filter Records
  • Create Lookups

QUERYING A DATABASE

  • Join Data from Different Tables in a Query
  • Sort and Filter Data in a Query
  • Perform Calculations in a Query

CREATING ADVANCED QUERIES

  • Create Parameter Queries
  • Create Action Queries
  • Create Unmatched and Duplicate Queries
  • Summarize Data

GENERATING REPORTS

  • Create a Report
  • Add Controls to a Report
  • Enhance the Appearance of a Report
  • Prepare a Report for Print

CUSTOMIZING THE ACCESS ENVIRONMENT

  • The Access Options Dialog Box

DESIGNING A RELATIONAL DATABASE

  • Relational Database Design
  • Create a Table
  • Create Table Relationships 

JOINING TABLES

  • Create Query Joins
  • Join Tables That Have No Common Fields
  • Relate Data within a Table
  • Work with Subdatasheets
  • Create Subqueries

ORGANIZING A DATABASE FOR EFFICIENCY

  • Data Normalization
  • Create a Junction Table
  • Improve Table Structure

Workshop Wrap-Up

At the end of the course, students will have an opportunity to ask questions.

Best Training Institute in Dubai
View All
Soft Skills Courses
View All
PMP Project Management Professional Exam Prep Training Course Certification in Dubai
View All

Subscribe to our newsletter

Sign-up to get the latest upcoming courses straight to your inbox.
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.