Tutorial 2 - Case Problem 1 Pine Hill Music School Essay

------------------------------------------------- ------------------------------------------------- ------------------------------------------------- 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†¦show more content†¦Yuka exported the student data that she was maintaining in another computer system to a text file, and she asks you to add this data to the end of the Student table. a. Specify â€Å"support_NP_A10_T2_Student.txt† as the source of the data. (The file â€Å"support_NP_A10_T2_Student.txt† is available from the SAM Web site.) b. Select the option: Append a copy of the records to the table. c. Select Student as the table. d. In the Import Text Wizard dialog boxes, choose the option to import delimited data, to use a comma delimiter, and to import the data into the Student table. Do not save the import steps. 12. In Design view, create a new table using the table design shown in Table 3. Specify ContractID as the primary key. Save the table using the name Contract. TABLE 3 Field Name | Data Type | Description | Field Size | Other | ContractID | Text | Primary key | 4 | Caption = Contract ID | StudentID | Text | Foreign key | 7 | Caption = Student ID | TeacherID | Text | Foreign key | 7 | Caption = Teacher ID | LessonType | Text | | 25 | Caption = Lesson Type | LessonLength | Number | 30 or 60 minutes | Integer | Caption = Lesson Length | LessonCost | Currency | | | Format = CurrencyDecimal Places = 0Caption = Lesson Monthly Cost | RentalCost | Currency | Monthly rental charge for instrument | | Format = CurrencyDecimal Places = 0Caption = Monthly Rental Cost | 13. Switch to Datasheet view, and then use the StartShow MoreRelatedMastering Graduate Studies 1e32499 Words   |  130 PagesACADEMIC INTEGRITY RESEARCH LIBRARY KNOWLEDGE SKILLS COMMUNICATION EXPECTATIONS CAREER PATH  IMPRINT Title Mastering Graduate Studies EDITION 1 CONTRIBUTORS Editor: Alexis DiVincenzo Consulting Editors: Mark Alexander, Nicole Quow-Thomason Art Direction Senior Art Director: Miranda Hildebrand Art Development and Design: Jo DeSnyder-Rolfe Permissions contact Grand Canyon University 3300 W Camelback Rd Phoenix, AZ 85017 602.639.7500 Copyright Information Grand Canyon University. AllRead More_x000C_Introduction to Statistics and Data Analysis355457 Words   |  1422 PagesIntroduction to Statistics and Data Analysis This page intentionally left blank Introduction to Statistics and Data Analysis Third Edition Roxy Peck California Polytechnic State University, San Luis Obispo Chris Olsen George Washington High School, Cedar Rapids, IA Jay Devore California Polytechnic State University, San Luis Obispo Australia †¢ Brazil †¢ Canada †¢ Mexico †¢ Singapore †¢ Spain †¢ United Kingdom †¢ United States Introduction to Statistics and Data Analysis, Third EditionRead MoreManaging Information Technology (7th Edition)239873 Words   |  960 PagesCONTENTS: CASE STUDIES CASE STUDY 1 Midsouth Chamber of Commerce (A): The Role of the Operating Manager in Information Systems CASE STUDY I-1 IMT Custom Machine Company, Inc.: Selection of an Information Technology Platform CASE STUDY I-2 VoIP2.biz, Inc.: Deciding on the Next Steps for a VoIP Supplier CASE STUDY I-3 The VoIP Adoption at Butler University CASE STUDY I-4 Supporting Mobile Health Clinics: The Children’s Health Fund of New York City CASE STUDY I-5