Microsoft Access Fundamentals

Category: Aci Code Requirements And Specifications For Concrete Design, Construction And Repair Training

Course Description

Course Objectives

  • An overview of the features available in Microsoft Access
  • Learn how to use an Access database
  • Learn how to create databases and simple tables
  • Learn how to build data-entry forms
  • Learn how to display data and produce reports.

Who Should Attend

  • IT Professionals who provide tech support
  • Business Users with database requirements

Benefit of Attending

  • By the end of this course you will be able to:
  • Gain proficiency in the basic features of Microsoft Access and use it effectively to organise information
  • Manage your data by creating simple databases and relational databases
  • Construct simple and complex tables
  • Create queries to filter and sort data, and join data from different tables
  • Design and format the look and appearance of forms
  • Get the know-how to create and present reports based on the data entered
  • Acquaint yourself with the various printing options available in Access and use them to print different objects.

Course Outline

  • Work in Access
  • Understand database concepts
  • Explore tables
  • Explore forms
  • Explore queries
  • Explore reports
  • Preview and print Access objects
  • Create databases from templates
  • Create databases and tables manually
  • Manipulate table columns and rows
  • Refine table structure
  • Create relationships between tables
  • Create forms by using the Form tool
  • Change the look of forms
  • Change the arrangement of forms
  • Sort information in tables
  • Filter information in tables
  • Filter information by using forms
  • Locate information that matches multiple criteria.