Using Access to Plan and Design Your Databases


show more Planning and designing your database provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Planning and designing your database

Before we can start building our database, we need to plan it out. No matter how much enthusiasm you have for building your database to organize your business, you can't just jump in and start typing, then make corrections later. All of the components are interlaced, and the more time you spend in the beginning planning and designing, the less frustration you'll have later, or worse, the less work you'll have to redo. Plan ahead. What information can you imagine ever needing to collect, even if you're not using it now: customer referral sources for marketing, additional details about the product.

The more you build in from the start the less back-filling you'll need to do later. Let's take a look at the project for this course. TwoTreesOliveOil. What information do we need to track? Customers, Sales Reps, Products, and Orders. Next, what information do we need about each one? It's helpful to write these out on paper, or in a Word document. Think about the relat...

Planning and designing your database
Video duration: 1m 33s 3h 30m Beginner

Viewers:

Planning and designing your database provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...