Tutorial 2 - Case Problem 1 Pine Hill Music School
-------------------------------------------------
-------------------------------------------------
-------------------------------------------------
New Perspectives Access 2010
-------------------------------------------------
Tutorial 2 - Case Problem 1
Pine Hill Music School
Skills
Save a database with a new filename
Change a field’s properties in Design view
Change the data type in Design view
Create a caption for a field
Add a field to a table
Save a table
Import the structure of a table in an Access database
Add fields using the Data Type gallery
Delete a field
Reorder fields
Enter a record in Table Datasheet view
Import data from a text file
Create a table in Design view
Set the primary key
Import data from an Excel worksheet
Create a one-to-many relationship
Project overview
Yuka Koyama uses the Pinehill database to maintain information about the students, teachers, and contracts for her music school. Yuka asks you to help her build the database by updating one table and creating two new tables.
STUDENT start FILE
NP_Access2010_T2_CP1a_FirstLastName_1.accdb (Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions 1. Open the file NP_Access2010_T2_CP1a_FirstLastName_1.accdb and save the file as NP_Access2010_T2_CP1a_FirstLastName_2.accdb by clicking the "Save Database As" command in Backstage view. (Note: Verify that your name appears in the first record in the _SAMProjects table before you begin. If it does not, then please download a new copy of the start file from the SAM Web site.)
2. Open the Teacher table, and set field properties as shown in Table 1.
TABLE 1 Field Name | Data Type | Description | Field Size | Other | TeacherID | Text | Primary key | 7 | Caption = Teacher ID | FirstName | Text | | 20 | Caption = First Name | LastName | Text | | 25 | Caption = Last Name | Degree | Text | | 3 | | School | Text | | 50 | | HireDate | Date/Time | | |
-------------------------------------------------
-------------------------------------------------
New Perspectives Access 2010
-------------------------------------------------
Tutorial 2 - Case Problem 1
Pine Hill Music School
Skills
Save a database with a new filename
Change a field’s properties in Design view
Change the data type in Design view
Create a caption for a field
Add a field to a table
Save a table
Import the structure of a table in an Access database
Add fields using the Data Type gallery
Delete a field
Reorder fields
Enter a record in Table Datasheet view
Import data from a text file
Create a table in Design view
Set the primary key
Import data from an Excel worksheet
Create a one-to-many relationship
Project overview
Yuka Koyama uses the Pinehill database to maintain information about the students, teachers, and contracts for her music school. Yuka asks you to help her build the database by updating one table and creating two new tables.
STUDENT start FILE
NP_Access2010_T2_CP1a_FirstLastName_1.accdb (Note: Download your personalized start file from www.cengage.com/sam2010)
Instructions 1. Open the file NP_Access2010_T2_CP1a_FirstLastName_1.accdb and save the file as NP_Access2010_T2_CP1a_FirstLastName_2.accdb by clicking the "Save Database As" command in Backstage view. (Note: Verify that your name appears in the first record in the _SAMProjects table before you begin. If it does not, then please download a new copy of the start file from the SAM Web site.)
2. Open the Teacher table, and set field properties as shown in Table 1.
TABLE 1 Field Name | Data Type | Description | Field Size | Other | TeacherID | Text | Primary key | 7 | Caption = Teacher ID | FirstName | Text | | 20 | Caption = First Name | LastName | Text | | 25 | Caption = Last Name | Degree | Text | | 3 | | School | Text | | 50 | | HireDate | Date/Time | | |