Exercise 1: Modifying the table structure of a Web database
Access 2010 templates are accessible from Access Backstage and are ready-to-use and free database solutions complete with tables, queries, forms, and reports built for common scenarios. In addition to the templates shipped with Access 2010, there are numerous third party templates available at office.com.
Many times, you may find that it is much easier to customize a template to a customer’s unique needs rather than start from scratch. In this exercise, you will learn how to perform tasks related to template customization and save development time.
Consider the needs of a human resources manager who needs to track job applicants. A good place to start in a situation like this is to see if there are any templates available that you could use as a starting point. In Access 2010, the Contacts Web Database template serves as an excellent starting point for a job applicant tracking system. Since the purpose of this exercise is to get experience modifying web database objects, we will use the Contacts Web Database template as a starting point for this exercise.
Task 1 – Create an Access Table
One common customization task when starting with a template is to modify the structure of existing tables in the template to suit your unique needs. Besides generic contact information, a job applicant tracking system needs to keep track of the details of the jobs that are available. In the first task, you will create a new database based on the Contacts Web Database template and then create a new table called Jobs for tracking available job details.
Task 2 – Modify the Contacts table
In addition to adding tables to a template, you often need to modify existing tables. In this task, you will modify the contacts table to store additional information related to tracking a job applicant.
Exercise 1 Verification
In order to verify that you have correctly performed all steps of exercise 1, proceed as follows: