Course length:  1/2-day

Course Description

Microsoft’s Office Access is Microsoft’s popular database program.  Microsoft Access is an information management tool that allows you to store, report, and analyze information within a relational database. If you're trying to use Excel to manage large amounts of information, then chances are Microsoft Access will be helpful to you. Access makes it easy to keep track, organize, and sort your data.

This course guides access users through the process of planning a relational database in Access. Although you can always make changes to your database when necessary, a little planning before you begin can save time later on. When you plan a database, consider how you will use the data. What kind of data are you collecting? What kind of data are you entering? How are data values related to one another? Can your data be organized into separate, smaller groups? What kinds of safeguards can you create to ensure that errors do not creep into your data? As you consider these questions, you should apply the answers as you structure your database.

In this advanced Microsoft Access course, students will be guided through planning a database and practice the initial stages of building tables and relationships.

Prerequisites

Access Part 1 equivalent Knowledge

Access Part 2 or equivalent Knowledge

Course Outline

Determine the Purpose of the Database

Plan and Organize Tables and Fields

Understand and Determine Relationship Types Between Tables

Specify a Primary Keys and Foreign Keys

Understand Junction Tables and Compound Keys

 

Understand and Choose Data Types

Build the Basic Structure of Tables in Design View

Establish Relationships in Access

Normalize Excel Data and Import into Access

You may also be interested in:

Access Mastering Queries

Access VBA