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.

Senior Instructor and Founder of ArchSmarter

Michael Kilkelly

Hi there! I'm Michael Kilkelly. I founded ArchSmarter 2014 as a way to help other architects become more productive and get the best results out of their design software. I’m a native New Englander. I live and work in Middletown, CT. Prior to starting ArchSmarter, I was an Associate at Gehry Partners in Los Angeles. I also worked for a number of design firms in the Boston area. I received my B.Arch from Norwich University and an SMArchS from MIT

Course curriculum

  1. 1
    • 01 - Database Basics

    • 02 - What is a Database?

    • 03 - Why use a Database?

    • 04 - Parts of a Database

    • 05 - Revit and Databases

    • 06 - Database Examples

    • 07 - Conclusion

    • Sample Files