New Perspectives on Microsoft Office Access 2013 …

1 CIS117DM Trollen Tentative Assignments Fall 2014 New Perspectives on Microsoft Office Access 2013 comprehensive Asg # Description & Errata Estimated Time 1 Read the course syllabus. Send an email to Type CIS117 and your first and last name in the subject line (eg: CIS117- Joe Student). In the message body, state that you have read the syllabus. If you have questions regarding the syllabus, you may include them in the message body or we can discuss them in class. I ll reply to your message with your student code (eg: R2D2), which you ll need to view online grade updates. 60 2 Data File Setup 1. Launch a web browser and navigate to 2. Do the item below that is appropriate for your situation: you have a Windows PC and have Access 2013 do CIS117 Data File Setup you have a Windows PC but don't have Access 2013 do CIS117 Data File Setup you have a do CIS117 Data File Setup you use do CIS117 Data File Setup 3.

2 Read/Study/Do Setting a Trusted Folder in MS Access 45 3 Read/Study/Do Access Tutorial 1 Creating a Database, pages AC 1 AC 44. Make the following changes: Pages AC 2&3: Each session begins with a Visual Overview illustration. Get in the habit of taking time to review it as you begin each session. Visual Overviews are also useful as you work through end-of-chapter cases and when you review the material before exams. This one identifies the name and purpose of several important areas of the Access screen. Page AC 7, step 1: If you re not using Windows 8 click Start > All Programs > Microsoft Office 2013 > Microsoft Access 2013 , then skip to step 3. Page AC 8, step 1: You obtained your data files in assignment #2 (above). Page AC 9, step 3: Add your name after Chatham (eg: Chatham Tom Trollen). This Chatham database file will be used in several future Tutorials. Be sure to work carefully to prevent problems in future Tutorials!

3 Page AC 9, step 5: Navigate to your \CIS117 Data Files\Access1\Tutorial folder so the file will be created there. Page AC 17, step 1: Be careful to enter these records exactly as illustrated. You ll have problems in the future if you don t! Page AC 26, step 1: If you re not using Windows 8 click Start > All Programs > Microsoft Office 2013 > Microsoft Access 2013 , then skip to step 3. Page AC 26, step 6: Navigate to your \CIS117 Data Files\Access1\Tutorial folder. Page AC 43, add a new step 4: Launch Windows Explorer and backup your file by copying it to the CIS117 Data Files\Access1\Tutorial folder on your USB flash drive. Send your file as an e-mail attachment to including the assignment number (eg: CIS117 Assignment #3) in the subject line. Be sure to retain a copy of each homework submission email you send in case I don t receive your original message (eg: spam, message bounces, full inbox, etc.)

4 Review the Quick Check questions on page AC 23 and page AC 44. Answers are available at Use password efcodd117 to open. Review the material in Tutorial 1 and consider adding appropriate notes to your exam crib sheet. 90 CIS117DM Trollen Tentative Assignments Fall 2014 4 Do Tutorial 1 Case 4 Stanley EcoTours on pages AC 49 AC 50. Make the following changes: Page AC 49, step 1: Add your name at the end of the file (eg: Stanley Tom Trollen). Save your new database in the \CIS117 Data Files\Access1\Case4 folder. Page AC 50, step 4: Be careful to enter these records exactly as illustrated. You ll have problems in future end-of-chapter cases if you don t! Page AC 50, step 9: Skip this step. Page AC 50, add a new step 17: Exit Access and then use Windows Explorer to backup your file to the CIS117 Data Files\Access1\Case4 folder on your USB flash drive. Send your file as an e-mail attachment to including the assignment number in the subject line.

5 Be sure to retain a copy of each homework email you send in case I don t receive your original message (eg: spam filtered, message bounces, full inbox, etc.). 45 5 Read/Study/Do Tutorial 2 Building a Database and Defining Relationships, Session , pages AC 51 AC 75. Make the following changes: Page AC 59, step 1: Your file should be in your CIS117 Data Files\Access1\Tutorial folder. Page AC 75, step 5: Exit Access . Launch Windows Explorer and backup your file to the CIS117 Data Files\Access1\Tutorial folder on your USB flash drive. Review the Quick Check questions on page AC 75. Answers are available at 45 6 Read/Study/Do Tutorial 2 Building a Database and Defining Relationships, Session , pages AC 76 AC 104. Make the following changes: Page AC 78, step 4: Enter these records carefully. You ll have problems later on if you don t! Page AC 100, step 2: If you see tables whose names begin with MSysNavPane, right-click each table s title bar, then click Hide Table.

6 Then click Show Table in the Design tab s Relationships group. Now do the step as written. Page AC 103, add a new step 12: Launch Windows Explorer and backup to CIS117 Data Files\Access1\Tutorial on your USB flash drive. Review the Quick Check questions on page AC 104. Answers are available at Review the material in Tutorial 2 and consider adding appropriate notes to your exam crib sheet. 90 7 Do Tutorial 2 Case 4 Stanley EcoTours on pages AC 113 AC 114. Make the following changes: Page AC 113, step 1: Your file should be in your \CIS117 Data Files\Access1\Case4 folder. Click the Enable Content button after opening the file. Page AC 114, step 14: If you see tables whose names begin with MSysNavPane, right-click each table s title bar, then click Hide Table. Then click Show Table in the Design tab s Relationships group. Now do the step as written. Page AC 114, add a new step 16: Use Windows Explorer to backup your file to the CIS117 Data Files\Access1\Case4 folder on your USB flash drive.

7 Send your file as an e-mail attachment to including the assignment number in the subject. 60 8 Read/Study/Do Access Tutorial 3 Maintaining and Querying a Database, Session , pages AC 115 AC 139. Make the following changes: Page AC 138, step 10: Exit Access . Launch Windows Explorer and backup your file to the CIS117 Data Files\Access1\Tutorial folder on your USB flash drive. Review the Quick Check questions on page AC 139. Answers are available at 45 CIS117DM Trollen Tentative Assignments Fall 2014 9 Read/Study/Do Access Tutorial 3 Maintaining and Querying a Database, Session , pages AC 140 AC 170. Make the following changes: Page AC 169, add a new step 6: Exit Access and then use Windows Explorer to backup your to the CIS117 Data Files\Access1\Tutorial folder on your USB flash drive. Review the Quick Check questions on page AC 170. Answers are available at Review the material in Tutorial 3 and consider adding appropriate notes to your exam crib sheet.

8 45 10 Do Tutorial 3 Case 4 Stanley EcoTours on pages AC 176 AC 177. Make the following changes: Step 4: When you modify the ToursByPrice query to display the total Price By Person, have the result appear at the bottom of the datasheet, beneath the detail rows. Step 12: Exit Access , Use Windows Explorer to backup your file to the CIS117 Data Files\Access1\Case4 folder on your USB flash drive. Steps 13-15: Omit. Send your file as an e-mail attachment to including the assignment number in the subject. 60 11 Read/Study/Do Access Tutorial 5 Creating Advanced Queries and Enhancing Table Design, Session on pages AC 233 AC 253. Make the following changes: Page AC 246, step 3: Be sure to drag the fields to the second column, as indicated. Page AC 253, step 11: Exit Access . Use Windows Explorer to rename your file to include your name (eg: Clinic Tom ). Then copy the file to the CIS117 Data Files\Access2\Tutorial folder on your USB flash drive.

9 Review the Quick Check questions on page AC 253. Answers are available at 30 12 Read/Study/Do Access Tutorial 5 Creating Advanced Queries and Enhancing Table Design, Session , pages AC 270 AC 293. Page AC 275, step 2: There is no Visit Num field. The author means Visit ID 1552. Page AC 283, step 7: I didn t see qryPatientsByName listed among the items that depend on tblVisit. Skip this step if you don t either! Page AC 291, step 5: You designated your \CIS117 Data Files folder as a Trusted Folder in an earlier assignment (Setting a Trusted Folder in MSAccess). If it is listed now, skip ahead to step 8. If not, continue with steps 5-7. Page AC 292, add new step 8: Use Windows Explorer to backup your file to the CIS117 Data Files\Access2\Tutorial folder on your USB flash drive. Review the Quick Check questions on page AC 293. Answers are available at Review the material in Tutorial 5 (sessions 1 and 3) and consider adding appropriate notes to your exam crib sheet.

10 60 13 Read/Study/Do Guided Tour: Lookup Wizard: List of Values, available at Send your file as an e-mail attachment to 20 CIS117DM Trollen Tentative Assignments Fall 2014 14 Do Tutorial 5 Case 4 Stanley EcoTours on pages AC 299 AC300, steps 1-7 and 13-17 only (skip steps 8-12). Make the following changes: Step 1: Click the Enable Content button after opening the file. Step 4: To clarify, qryNonBrazilOrPeruTours should show all countries except Brazil and Peru. It should show neither Brazil nor Peru. Add a new step between steps 6 and 7: Janice is considering a $200 discount for any tour lasting more than 6 nights. Create a query that shows, for all Tours, TourID, TourName, Nights, PricePerPerson, and a calculated column named ProposedRate that shows either the regular PricePerPerson or the discounted rate, depending on whether the tour lasts more than 6 nights. Sort the rows in descending order of number of nights.