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 A member of the Microsoft Office suite of applications, included in the professional and higher editions.
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 query
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
Zabeel international institute of management technology Offer High Demand in IT Courses and technology management industry. We are one of the Top ranking training institute in Dubai .
Microsoft Access Training Detailed Course Content:
MS-Access (Level 1) Outline
Understanding Database Objects and Data Modeling
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
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.