From the course: Access: Building a Sales Database

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Brainstorming

Brainstorming - Microsoft Access Tutorial

From the course: Access: Building a Sales Database

Start my 1-month free trial

Brainstorming

- [Instructor] Brainstorming is the second step in building a database, and it's important because it helps you create the most comprehensive, useful tables from the start, with fewer things to be added after the tables are in use. So what is brainstorming? Brainstorming is really just focused thinking about one idea or subject. It opens your mind to the data you have to store, and it's a process you can do collaboratively or on your own. The process helps you prepare to take action building your database, as it enables you to forecast the forms, queries, and reports you'll need to fully utilize your data. When brainstorming about your database, the process involves three steps. I'll show you each step in detail as we develop an Access database for an imaginary training center. First, think about your training center as a business. One component is the students, so we'll start with the students' table. Think about all the things you know about the subject of the table. In this case…

Contents