-------------------------------------------------
-------------------------------------------------
New Perspectives Access 2010
-------------------------------------------------
Tutorial 1 - Case Problem 1b
All Sports rehab center
Skills
Save a database with a new filename
Create a table
Rename a field
Change the data type of a field
Add fields to a table
Save a table.
Enter records
Copy records from another database
Resize columns
Create a query using the Simple Query Wizard
Create a form using the Form tool
Create a report using the Report tool
Project overview
As a private therapist, Hannah Sterling had seen her share of sport-related injuries. After many years of training, she decided to open the All Sports Rehab Center in Cherry Hill, New Jersey. Centrally located between Philadelphia and New York, Hannah can choose from among the best therapists, nutritionists, and trainers for her staff. With high school and college sports so popular in the region, she found the market was wide open for good therapists to treat and train young athletes. The All Sports Rehab Center quickly established a reputation for excellence. During the past two years, several qualified physical therapists, certified athletic trainers, strength and conditioning specialists, industrial rehabilitation, nutrition specialists, and exercise physiologists have joined Hannah’s team. As the All Sports Rehab Center continues to grow, Hannah wants to use Access to keep track of information about clients and patients, therapists, and contracts. You’ll help Hannah create and maintain an Access database to store data about her rehab center.
STUDENT start FILE
NP_Access2010_T1_CP1b_FirstLastName_1.accdb (Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions 1. Open the file NP_Access2010_T1_CP1b_FirstLastName_1.accdb and save the file as