Database Basics for Architects

How to Create and Manage Databases using Microsoft Access | taught by Michael Kilkelly

Course description

Designing a building is an information intensive activity. There are thousands of decisions that need to be made. Hundreds of products need to be evaluated. Storing and retrieving building data is a major challenge on a day-to-day basis, let alone 5 – 10 years down the road.

Additionally, how can you leverage this data to inform future projects? You need real tools to keep control of your data and to put it at your fingertips. This is where databases come in.

In this mini-course, you'll learn how to create a database using Microsoft Access. We'll discuss how to structure a database and take an in-depth look the various components that make up a database, like forms and reports. We'll also look at some real-world examples of databases used to manage project-specific information.

Course Objectives

  • Understand how databases differ from spreadsheets and when it's appropriate to use one versus the other.
  • Recognize opportunities to use databases to better manage your project information.
  • Understand how to design a database using Microsoft Access.
  • Learn how to create forms to input user data into your database.
  • Learn how to create a variety of reports from the same database.

This mini-course will be presented live on December 15, 2016 at 2pm Eastern / 11am Pacific. A video replay will be available the following day.

Michael Kilkelly
Michael Kilkelly
Senior Instructor and Founder of ArchSmarter

Michael Kilkelly (michael@archsmarter.com)