linkedin

Home - Courses - IT Training Courses - postTitle –

 

Microsoft Access Training Course

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
  • Certification Body
  • Download Brochure

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

Microsoft Access Training Course
Microsoft Access Training Course

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 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
  • Payroll Specialists

Microsoft Access Training Detailed Course Content:

MS-Access (Level 1) Outline

Access Fundamentals

Introducing Access

Obtaining Help

Understanding Database Objects and Data Modelling

Creating Databases

  • Using the Database Wizard / Creating a Blank Database
  • Querying the Database
  • Sorting the Database

Creating Tables

  • 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 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
  • Specific Queries
  • Reports

Working with Query Expressions

  • Using Expressions in a Query /Specifying Multiple Criteria
  • Creating Calculated Fields /Performing Mathematical Calculations

Access 2003 (Level 2) Introduction to Forms

Introduction to Forms

  • Understanding Forms
  • Understanding Naming Conventions
  • Using Forms
  • Opening a Form
  • Navigating Through Forms
  • Managing Data with Forms
  • Printing a Form
  • Closing a Form
  • Creating Auto Forms
  • Creating Forms with the Form Wizard

Working with Forms in Design View

  • Using Design View
  • Understanding the Parts of a Form
  • Resizing Sections on a Form
  • Using AutoFormat
  • Working with Controls
  • Selecting Controls
  • Manipulating Controls
  • Formatting Controls
  • Applying Conditional Formatting
  • Adding Controls to Forms
  • Creating Forms in Design View
  • Understanding Controls
  • Inserting the Date and Time
  • Understanding the Toolbox
  • Adding a Bound Text Box
  • Adding a Label
  • Adding Option Buttons
  • Adding Check Boxes
  • Using List Boxes and Combo Boxes
  • Adding a Tab Control
  • Adding a Calculated Control
  • Creating a Calculated Control
  • Adding Graphic Elements
  • Adding Lines, Rectangles, and Images
  • Managing Properties
  • Changing the Properties of a Control
  • Changing Section Properties
  • Changing Form Properties

Working with Sub Forms

  • Introduction to Subforms
  • Creating and Using Subforms

Introduction to Reports

  • Understanding Reports
  • Understanding Naming Conventions
  • Using Reports
  • Opening, Printing, and Closing Reports
  • Creating Auto Reports
  • Creating Reports Using Wizards
  • Creating a Standard Report
  • Creating a Mail Merge with Access Data
  • Creating Labels
  • Creating a Chart

Working with Reports in Design View

  • Using Design View
  • Understanding the Parts of a Report
  • Resizing Sections on a Report
  • Using AutoFormat
  • Working with Controls
  • Selecting, Manipulating, and Formatting Controls
  • Applying Conditional Formatting
  • Adding Controls to Reports
  • Creating Reports in Design View
  • Understanding Controls
  • Inserting the Date and Time
  • Inserting Page Numbers
  • Understanding the Toolbox
  • Adding a Bound Text Box
  • Adding a Label
  • Adding Graphic Elements
  • Adding Lines, Rectangles, and Images
  • Managing Properties
  • Changing Properties
  • Changing the Report Layout
  • Sorting and Grouping Records
  • Working with Page Breaks
  • Adding Calculated Controls
  • Creating a Calculated Control
  • Concatenating Text
  • Adding a Subreport to an Existing Report

Importing and Exporting Data

  • Importing Data
  • Importing Spreadsheet Data
  • Importing a Text File
  • Linking Tables to an External Source
  • Exporting Data
  • Exporting a Database Object to Another Access Database
  • Exporting Data to a Text File
  • Exporting Data to a Spreadsheet or Rich Text Format
  • Exporting Data to Microsoft Applications using Office Links

Using Advanced Query Wizards

  • Creating CrossTab Queries
  • Creating a Crosstab Query
  • Using Advanced Query Wizards
  • Finding Duplicate Values
  • Finding Unmatched Records

Working with Action Queries

  • Creating a New Table from Query Results
  • Creating a Make-Table Query
  • Running the Make-Table Query Again
  • Updating Records Using an Action Query
  • Appending Records Using An Action Query
  • Deleting Records Using an Action Query

Working with Specialized Queries

  • Working with Parameter Queries
  • Creating a Parameter Query
  • Creating Advanced Parameter Queries
  • Using Queries to Create Forms and Reports
  • Creating Total Queries
  • Creating an Auto Lookup Query
  • Using Joins in Queries
  • Understanding Joins
  • Creating an Outer Join Query
  • Creating a Self-Join Query

Database Management

  • Managing Database Objects
  • Copying a Database Object
  • Deleting a Database Object
  • Managing Database Files
  • Compacting and Repairing a Database File
  • Converting a Database File
  • Optimizing Database Performance
  • Using the Table Analyzer
  • Using the Performance Analyzer
  • Using the Database Documenter

Managing Table and Query Properties

  • Understanding Field Properties of Tables
  • Using Validation Rules
  • Setting the Validation Rule Property
  • Requiring Data Entry
  • Allowing Zero-Length Data Entry

Indexing Fields

  • Setting the Indexed Property
  • Using the Indexes Window
  • Creating a Multiple Field Index
  • Changing the Decimal Places Property
  • Working with the Input Mask
  • Using the Input Mask Wizard with a Text Field
  • Using the Input Mask Wizard with a Date/Time Field
  • Creating an Input Mask Manually
  • Working with the Display Control Property
  • Setting and Changing Table Properties
  • Setting the Description Property
  • Setting the Validation Rule and Validation Text Properties
  • Setting the Filter Property
  • Setting the Order By Property
  • Working with Properties in Queries
  • Working with Field Properties in Queries

To know more about Microsoft Access, click here.

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

whatsaapnow
Quick Enquiry