Type and hit enter to Search
×

Basic Microsoft Access 2019 Training Course - Oman

  • 5(793 Rating)

Course Overview

This Introduction to Microsoft Access 2019 training class starts by covering basic database concepts. Students will then learn to design and create databases and tables, query those tables, and create forms and reports.

At Course Completion:

  • Gain an understanding of database concepts and terminology.
  • Learn about the Access interface.
  • Learn to work with table views, queries, forms, reports, macros, and modules.
  • Learn to plan a database.
  • Learn database design fundamentals.
  • Learn to work with forms and the Form Wizard.
  • Learn to work with reports and the Report Wizard.

Target Audiance

  • This course is intended for students who have little or no familiarity with Microsoft Access 2019 or more experienced Access users who want to learn the topics covered in this course in the 2019 interface.

Schedule Dates

Microsoft Access 2019 – Basic
19 December 2024
Microsoft Access 2019 – Basic
19 March 2025
Microsoft Access 2019 – Basic
19 June 2025
Microsoft Access 2019 – Basic
19 September 2025

Course Content

  • Access Ribbon
  • Quick Access Toolbar
  • Object Navigation Pane
  • Access Work Surface
  • Object Overview
  • Process Overview
  • Create a Database Using a Wizard
  • Lab 1: Getting Around the Access Environment
  • After completing this module, students will be able to:
  • Understand the organization of the Access ribbon.
  • Understand context tabs in the ribbon.
  • Understand the Quick Access Toolbar and how to customize.
  • Understand the Quick Access Toolbar and how to customize.
  • Understand the Navigation Pane.
  • Understand the objects and creation process.
  • Understand the Access work surface.
  • Understand how to create databases using a wizard.

  • Questions to Ask Before You Start
  • Approaches to Database Design
  • Gathering Information
  • A Few Words about Naming Conventions
  • Normalization
  • Table Relationships
  • Lab 1: Fundamentals Exercises:
  • Asking Questions
  • Normalizing Data
  • After completing this module, students will be able to:
  • Ask questions to consider before you create a database application.
  • Understand common approaches to database design: top-down and bottom-up.
  • Go from paperwork and data samples to categorized data (data mapping).
  • Understand naming conventions for tables and other objects.
  • Understand what normalization is.
  • Understand some basic concepts of normalization and how to apply them.
  • Understand bout primary and foreign keys.
  • Understand relationships and establishing them among tables.

  • Definition and Purpose
  • Datasheet View
  • Design View
  • Lab 1: Working with Tables in Datasheet View
  • After completing this module, students will be able to:
  • Understand tables and table views in Access.
  • Work with tables in Datasheet view.
  • Add and Edit data records in Datasheet view.
  • Understand the purpose of Design view.

  • Creating an Access Database
  • Data Types
  • Create a Table in Design View
  • Lab 1: Tables Exercises:
  • Creating a New Database
  • Determining Data Types
  • Creating a Table in Design View
  • After completing this module, students will be able to:
  • Create an Access database.
  • Create a table in Design view.
  • Understand data types.
  • Assign a key field.
  • Understand input masks.
  • Use expressions to define validation rules.

  • Queries
  • Select Queries
  • Select Queries with Criteria
  • Logical Operators
  • Group and Total with Queries
  • Lab 1: Creating Select Queries:
  • Creating Select Queries
  • After completing this module students will be able to:
  • Use queries and query views.
  • Create a simple query.

  • Forms
  • Alter a Form
  • Form Record Navigation
  • Layout View and Design View
  • One-click Forms
  • Form Wizard
  • Lab 1: Forms Exercises
  • Adding Data Records in Form View
  • Creating a Form with the Form Wizard
  • After completing this module students will be able to:
  • Understand types of forms.
  • Add records using a form.
  • Understand one-click forms.
  • Create a form using the Form Wizard

FAQs

No FAQs Found
Start learning with 15.8k students around the world.
  • 3.3k
    Courses
  • 100+
    Certified Instructors
  • 99.9%
    Success Rate
Open chat
Hello
How Can We Help You?