Microsoft Office Tutorials and References
In Depth Information
| Case Problem 5
Work with the skills
you’ve learned, and
explore some new
skills, to create a data-
base for an Internet
There are no Data Files needed for this Case Problem.
Always Connected Everyday Chris and Pat Dixon own and manage Always Connected
Everyday (ACE), a successful Internet service provider (ISP) in your area. ACE provides
Internet access to residential and business customers and offers a variety of access plans,
from dial-up and DSL to wireless. Figure 5-46 shows the pricing options for the access
plans ACE offers.
Dial-up no e-mail
Wireless city economy
Wireless city basic
Wireless city advanced
Wireless city business
Wireless rural basic
Dial-up plans are available in all communities served by ACE, and DSL and wireless
access are limited by a customer’s proximity to DSL phone lines or wireless towers.
Within each type of service—dial-up, DSL, and wireless—ACE offers low-cost plans with
either slower access speeds or fewer capabilities and more expensive plans with either
higher access speeds or greater service and features.
Chris and Pat need you to create a database to track their plans, customers, and service
calls. The process of creating a complete database—including all fields, tables, relation-
ships, queries, forms, and other database objects—for ACE is an enormous undertaking.
You will start with just a few database components, and then you will create additional
objects and functionality in subsequent tutorials.
Complete the following steps to create the database and its initial objects:
1. Read the appendix titled “Relational Databases and Database Design” at the end of
2. If you are not familiar with ISPs, use your Web browser to find out more about
them, so that you know common terminology and offerings.
3. The initial database structure includes the following tables and fields:
a. The tblAccessPlan table includes the fields shown in Figure 5-46, along with a
primary key field, which you can define as an AutoNumber field.
b. The tblCustomer table includes a unique customer account number; an optional
company name; and first name, last name, address, city, state, zip, phone, access
plan ID (foreign key), next billing date, and e-mail address for the customer; and
the customer’s user ID and password for accessing ACE’s Web site.