Designing the Tables

Start Access 2010 and create a new database using the Blank web database template. When using this template, Access will create new objects such as tables and forms that are compatible with SharePoint.

Data Model Overview

The logical starting place for creating a web database is to design the tables. You will need the following tables to support the job tracking application:

• Customer contains current or potential customers.
• Phone stores customer phone numbers.
• Address stores customer and job addresses.
• Product defines products that may be included in a job.
• Service defines services offered.
• Job contains job or proposal summaries.
• JobProduct specifies products included in a job.
• JobService specifies services included in a job.