Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel or other spreadsheet applications. Microsoft Access has the look and feel of other Microsoft Office products, including its layout and navigational aspects.
About the Course
Overview of the course:
Microsoft Access is a Database Management System (DBMS) from
Microsoft that combines the relational Microsoft Jet Database Engine
with a graphical user interface and software development tools. MS
Access manages and stores data.
Access gives you the capacity to
store data in related tables and enforce referential integrity between
tables with things like cascade update and cascade delete. It is a
member of the Microsoft Office suite of applications, included in the
professional and higher editions
Learning Outcome of Microsoft Access Training:
Level-1 This class covers the essential basics of Microsoft Access.
Topics include: opening databases and defining database objects;
creating databases manually or using the Database Wizard; planning,
creating, editing and printing tables; and customizing the appearance
and design of a table. Students will also learn how to create, manage,
and modify table relationships; create filters and queries; and query
records using expressions.
Level 2 Ideal For: Users of Access who
are skilled at the basics and want to learn to develop custom forms and
reports to manipulate, control, and present data. This class is designed
to take participants beyond the “Introduction” level. Students will
learn how to create and format forms, sub forms and reports. In
addition, the course will cover how to manage data, add controls on
forms and reports, import and export data. Creating and using advanced
Learn to work with table views, queries, forms, reports, & macros & modules.
Learn to complete the desktop application with the navigation form.
Learn about the Access interface.
Learn database design fundamentals.
Learn to work with table relationships.
Learn to work with forms at an advanced level.
Learn to work with macros.
Learn to plan a database.
Learn about database relationships.
Learn to work with queries at an advanced level.
Learn to work with reports at an advanced level.
Who needs the Microsoft Access Training course?
This course is for students who wish to learn Access Database to
achieve their daily responsibilities, and using a relational database
program can bring to Programming processes.
Fresh Computer science Graduates
Microsoft Access Training Detailed Course Content:
MS-Access (Level 1) Outline
Understanding Database Objects and Data Modelling
Using the Database Wizard / Creating a Blank Database
Querying the Database
Sorting the Database
Creating a Table in Design View /Creating a Table in Datasheet View
Using the Table Wizard to Create Tables /Planning for Multiple Tables
Editing and Printing Tables
Adding Records to a Table /Navigating Through a Table
Selecting and Modifying Records /Manipulating Data and Printing Tables
Customizing Columns and Rows /Changing the Appearance of Data
Inserting and Deleting Fields /Using the Lookup Wizard
Creating Hyperlinks /Changing Field Properties
Creating Table Relationships
Introducing Table Relationships
Editing and Deleting Table Relationships
Creating and Customizing Filters and Queries
Working with Filters /Understanding Queries
Creating a Query Using the Simple Query Wizard
Creating a Query in Design View /Customizing a Query
Working with Query Expressions
Using Expressions in a Query /Specifying Multiple Criteria
To know more about other courses in IT Academy, click here.
About Certification and Awarding Body
KHDA Certificate :
Course completion certificate attested by KHDA(Knowledge and Human Development Authority, UAE)
The Knowledge and Human Development Authority (KHDA) is responsible for the growth and quality of private education in Dubai. We support schools, universities, parents, students, educators, investors and government partners to create a high quality education sector focused on happiness and well being.
Title : MS ACCESS
For application process, please contact us.
Kindly fill the below details to download the Brochure