Access - Part 1 (UT-MS-Acc-P1)


Course Description

Focuses on the design and construction of an Access database —viewing, navigating, searching, and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms, and reports.

Course Objectives

In this course, you will create and manage an Access database. You will:

  • Navigate within the Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Course Outline

1 - GETTING STARTED WITH ACCESS

  • Topic A: Launch Access and Open a Database
  • Topic B: Use Tables to Store Data
  • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
  • Topic D: Use Forms to View, Add, and Update Data
  • Topic E: Use Reports to Present Data
  • Topic F: Get Help and Configure Options in Microsoft Access

2 - CREATING TABLES

  • Topic A: Plan an Access Database
  • Topic B: Start a New Access Database
  • Topic C: Create a New Table
  • Topic D: Establish Table Relationships

3 - CREATING QUERIES

  • Topic A: Create Basic Queries
  • Topic B: Perform Calculations in a Query
  • Topic C: Sort and Filter Data in a Query

4 - CREATING FORMS

  • Topic A: Start a New Form
  • Topic B: Enhance a Form

5 - CREATING REPORTS

  • Topic A: Start a New Report
  • Topic B: Enhance Report Layout

6 - PROMOTING QUALITY DATA INPUT

  • Topic A: Restrict Data Input Through Field Validation
  • Topic B: Restrict Data Input Through Forms and Record Validation

7 - IMPROVING EFFICIENCY AND DATA INTEGRITY

  • Topic A: Data Normalization
  • Topic B: Associate Unrelated Tables
  • Topic C: Enforce Referential Integrity

 

There are no prerequisites for this course.

Course Information

Length: 2 day

Format: Lecture and Lab

Delivery Method: n/a

Max. Capacity: 16



Schedule

Contact Us

UPCOMING COURSES
Date
Geography & Location
Days
Cost
CLC
GTR
Mar 13, 2024 - 2 day(s)
Mar 13, 2024
AMER
Remote EST
AMER, Remote EST
2
$590 USD
$590 USD
Apr 02, 2024 - 2 day(s)
Apr 02, 2024
AMER
Remote-EST
AMER, Remote-EST
2
$590 USD
$590 USD
Apr 22, 2024 - 2 day(s)
Apr 22, 2024
AMER
Remote-EST
AMER, Remote-EST
2
$590 USD
$590 USD
May 09, 2024 - 2 day(s)
May 09, 2024
AMER
Remote EST
AMER, Remote EST
2
$590 USD
$590 USD
May 28, 2024 - 2 day(s)
May 28, 2024
AMER
Remote EST
AMER, Remote EST
2
$590 USD
$590 USD
Jun 13, 2024 - 2 day(s)
Jun 13, 2024
AMER
Remote EST
AMER, Remote EST
2
$590 USD
$590 USD

Do you have more questions? We're delighted to assist you!

1-877-797-2799
info@firefly.cloud