In this course, students will use Access 2016 to manage their data, creating a new database, constructing tables,designing forms and reports, and creating queries to join, filter, and sort data.

starstarstarstarstar

* Actual course outline may vary depending on offering center. Contact your sales representative for more information.

Learning Objectives

Upons successful completion a student will have a be able to create a database and design forms and reports.

1
  • What is A Relational Database

  • What is a database?
    What makes data a database and not a spreadsheet?
    What makes a relational database 'relational'?
    What are the parts of a relational database?
    Chapter summary

2
  • Exploring Microsoft Access

  • Opening and viewing Microsoft Access
    Touring the access window
    Exploring the main parts of an access database
    Using the access Help Features
    Using the navigation pane
    Chapter recap

3
  • Planning a Relational Database

  • Planning a database
    Identifying classes
    Identifying class attributes
    Identifying objects

4
  • Splitting Information into Tables

  • The first rule- making sure every record is unique
    breaking columns down to their lowest forms
    Another rule- avoiding repeats of information
    Another rule- avoiding multiples of the same column
    Another rule- columns need to relate to a primary key

5
  • Designing and Building a Database

  • Building a database from an existing template
    Creating a database
    Testing tables in a database

6
  • Designing Database Tables

  • Creating table lookups
    Using table field properties
    Using input masks
    Using Validation rules
    Changing field structure in tables

7
  • Creating Table Relationships

  • Importing Data from an Access Database 1
    Importing data from excel

8
  • Importing data into Access

  • Importing Data from an Access Database 1
    Importing data from excel 105

9
  • Creating Forms

  • Creating a basic form 111
    Creating a form with the form wizard
    Creating a split form
    Creating Subforms

10
  • Form Design

  • Enhancing the appearance of a form 128
    Changing form layout
    Using Form Properties
    Adding command buttons to a form

11
  • Creating Basic Queries

  • Creating a Query with a Wizard
    Creating a Query from Scratch
    Editing a Query

12
  • Creating Basic Reports

  • Creating a Report from a Table 156
    Creating a Report from a Query
    Examining Report Types
    Documenting the database

Audience

This course is designed for the beginning end user with some working knowledge of Windows OS.

Language

English

Prerequisites

There are no stated prerequisites for this course. Please check with your representative for details.

$700

Length: 2.0 days (16 hours)

Level:

Not Your Location? Change

Course Schedule:

To request a custom delivery, please chat with an expert.

Loading...