Access 2016: Developing a Database

Date/Time
Date(s) - 01/16/2019 - 01/17/2019
9:30 am - 11:30 am

Location
IML (Eggers Hall, room 062)

Category(ies)

• Training

Please note – this is a two-day training session.
You must be able to attend both days during the time specified.

*DAY 1: Wednesday, January 16th, 9:30 am – 11:30 am

*DAY 2: Thursday, January 17th, 9:30 am-11:30 am

An Access database can be as small as a single table that tracks one topic of information, or a database can contain many tables – each one related to a specific purpose. A database that stores information in multiple related tables is referred to as a relational database.

Good table structure is the foundation of a well-designed relational database. Creating a table that is structured properly begins by understanding database concepts. When you understand the “theory” behind developing a database and what good table structure is, you ensure fewer problems in the management of your data. The source of a query, form, or report object begins with a table – taking the time up front to design proper tables and establish correct relationships will make the creation of other objects easier, and ensure accurate results.

In this workshop, we will begin by going over important database concepts: What is the purpose of your database and each table within the database? What fields do you want to keep track of? Which field is going to be the “primary key?” What type of data will each field track, and do you want to set any limits to that field?

After creating your tables, you will have to get them to “talk to each other.” You do this in the Relationships window by defining your primary table, your related table, and the common field you’ll use to link them together. During this process, we will also cover the important concept of “referential integrity,” which helps to ensure accurate results when creating other database objects.

This two-day training session is a great starting point for anyone new to database development. If you are the owner of a database, and would like a refresher on database concepts, please join us!