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.
Michael Kilkelly
Michael Kilkelly
Senior Instructor and Founder of ArchSmarter

Hi there! I'm Michael Kilkelly. I’m an architect, not a professional computer programmer. Learning to program has directly improved my quality of life. Since I can now automate tasks, I'm no longer staying up late doing tedious work in Revit. This has helped me produce better results in less time. If I can learn to program, so can you. Let me show you how!

Michael Kilkelly (