ms access - essentials

By attending MS Access - Essentials workshop, Delegates will:

  • Gain an understanding of database concepts and terminology
  • Learn about the Access interface
  • Learn to work with table views, queries, forms, reports, and 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

In MS Access - Essentials training course, you will examine the basic database concepts, and create and modify databases and their various objects using the MS Office Access relational database application.

MS Access - Essentials class is designed for Participants who wish to learn the basic operations of the MS Access database application to perform their day-to-day responsibilities, and to understand the advantages that using a relational database application can bring to their business processes. This fundamentals course is for the individual whose job responsibilities include designing and creating new databases, tables, and relationships; creating and maintaining records; locating records; and producing reports based on the information in the database.

COURSE AGENDA

  • Describe the Relational Database Design Process
  • Define Database Purpose
  • Review Existing Data
  • Determine fields
  • Group Fields into Tables
  • Normalize Data
  • Designate Primary and Foreign Keys
  • Determine Table Relationships
  • Setting rules to ensure valid relationship
  • Examine Database Concepts
  • Exploring the User Interface
  • Use an Existing Access Database
  • Customize the Access Environment
  • Obtain Help
  • Create a Database
  • Create a Table
  • Manage Tables
  • Create a Table Relationship, Delete and Apply rules
  • Save a Database as a Previous Version
  • Modify Table Data
  • Sort Records, Add, Delete Records
  • Navigate within table
  • Define key, primary key , Indexing
  • Creating one to one to many relations
  • Work with Subdatasheets
  • Filter Records, Navigate Records
  • Form headers footers
  • Create a Query
  • Add Criteria to a Query
  • Add a Calculated Field to a Query
  • Perform Calculations on a Record Grouping
  • Use two table queries
  • Using operators within queries
  • Editing, running and deleting a query
  • Saving and closing a query
  • View Data Using an Access Form
  • Create a Form
  • Modify the design of a Form
  • View an Access Report
  • Create a Report
  • Add a Custom Calculated Field to a Report
  • Format the Controls in a Report
  • Apply an AutoFormat Style to a Report
  • Prepare a Report for Print

Copyright © 2025 All Rights Reserved by Cuesys Infotech.

Designed By  99 DESIGN AGENCY