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.
- 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 (firstname.lastname@example.org)