From the course: Access Quick Tips

Storyboarding

- [Instructor] There's no substitute for planning, no matter what you're doing. An Access database is certainly no exception. Storyboarding your database-to-be entails brainstorming about the data you want to store and use, and making lists of what you know about the data in question. Think of every little thing you know about your customers, products, et cetera, or in my case, my students, the enrollments, and classes. Write every item down. Don't worry yet about what you'll call things, just write it down. You can also type them into a document, which will make reorganizing them later much easier. Think, too, about how you'd break that information down into separate tables. For a training program, you might have a table of classes offered, another for the instructors who teach the classes, and another for the students who take them. As you decide which tables you'd need to build to organize all the pieces of information your brainstorming produced, reorganize the information into those tables.

Contents