Wednesday, May 25 (A)/Friday, May 27 (A)
Thursday, May 26 (B)/Monday, May 30 (B)

Team “T”

• Exercise 15:  ON YOUR OWN (430)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC15
  • Step 10
    • Save form as frmEquipment - Student Name
    • Be sure to include you "Student Name" in the Form Title (Layout View)
    • Find "Metal bat" record
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
    • Right-click here (open Link in New Tab) to view sample printout...
       

Team “U”

• Exercise 16:  ON YOUR OWN (437)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC16
  • Step 2
    • Before opening form,
    • Rename form as frmRoster - Student Name
       
  • Step 3 - 4
    • You will need to widen the detail area of the form
    • Make sure that there is enough room for the Form Header section title and time
       
• Step 8
• next to "Play to Win!",
• Include PRINTOUT #4 in the unbound label
   
• Step 10
  • Be sure to include you "Student Name" in the Form Title (Layout View)
  • Find Pedro Martinez record
  • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
  • Right-click here (open Link in New Tab) to view sample printout...

Monday, May 23 (A)
Tuesday, May 24 (B)

Team “R”

• Exercise 15 (425 - 429)
• Read and review Exercise chapter
  • Understanding Layout View
  • Adjusting the Control Margins and Control Padding
  • Move Fields in the Layout
  • Size a Control
  • Delete a Control
  • Reset Tab Order
  • Align Controls with One Another
  • Change Control Formatting
• Right-click here (Save Link As...), save file as AC15
• Exercise 15:  Complete Exercise
  • Step 2 - 3
    • Rename form as frmClasses - Student Name
    • Add a form title that includes "frmClasses -Student Name" (Layout View)
       
  • Step 10
    • Find the Aerobic Kickboxing record
    • In the Notes field, enter PRINTOUT #1
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation

 Team “S”

• Exercise 16 (431 - 436)
• Read and review Exercise chapter
  • Work in Form Design View
  • Select and Move Controls
  • Resize Controls
  • Work with Headers and Footers
  • Add Page Number Codes
  • Add Date/Time Codes
  • Move Controls Between Sections
  • Insert an Unbound Label
  • Insert a Form Title
• Right-click here (Save Link As...), save file as AC16
• Exercise 16:  Complete Exercise
  • Step 2 - 3
    • Rename form as frmClasses - Student Name
    • Add a form title that includes "frmClasses -Student Name" (Layout View)
       
  • Step 10
    • Center-Align the page number code in the PAGE FOOTER
    • Find the Water aerobics record
    • In the Notes field, enter PRINTOUT #2
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
      

Thursday, May 19 (A)
Friday, May 20 (B)

Team “P”

• Exercise 14 (419 - 423)
• Read and review Exercise chapter
  • Create a Quick Form
  • Create a Form with a Wizard
  • Create a Form from Scratch
  • AutoFormat a Form
• Right-click here (Save Link As...), save file as AC14
• Exercise 14:  Complete Exercise
  • Step 4
    • Save form as frmClasses - Student Name
    • Be sure to include you "Student Name" in the Form Title (Layout View)
    • Find Advanced Yoga (Record 6)
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
    • Label Printout #1
       
  • Step 5 - 7
    • Save form as frmMembers - Student Name
    • Find Midori Wakasuki (Record 18)
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
    • Label Printout #2
       
  • Step 9
    • Save form as frmInstructors - Student Name
       

Team “Q”

• Exercise 14:  ON YOUR OWN (424)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC14
  • Step 3
    • Save form as frmRoster - Student Name
       
  • Step 6
    • Enter your First Name, Last Name in the new record...
    • Find Your Name (Record 10)
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
    • Label Printout #3
       
  • Step 8
    • Save form as frmEquipment - Student Name
    • Be sure to include you "Student Name" in the Form Title (Layout View)
    • Find Metal bat (Record 2)
    • Print SELECTED RECORD ONLY - LANDSCAPE Orientation
    • Label Printout #4

Tuesday, May 17 (A)
Wednesday, May 18 (B)

Team “N”

• Exercise 13 (414 - 417)
• Read and review Exercise chapter
  • Create a Lookup
  • Create a Value List
  • Lookup Field Values from Another Table
  • Create a Multivalved Field
• Right-click here (Save Link As...), save file as AC13
• Exercise 13:  Complete Exercise
  • Step 2
    • Make sure you close all tables
    • Rename ALL tables to include - Student Name
       
  • Step 7
    • After making the changes, and adding the new record; print the tblClassOfferings table
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print tblClassOfferings table
    • Label Printout #1
       
  • Step 16
    • Print Relationship report
    • Label Printout #2
       

Team “O”

• Exercise 13:  ON YOUR OWN (418)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC13
  • Step 2
    • Make sure you close all tables
    • Rename ALL tables to include - Student Name
    • Click the Relationship button
    • Click the Show Table button
    • Add the Categories, Roster, and Equipment tables FIRST
       
  • Step 6
    • Enter a NEW record in the Roster table - use your First Name, Last Name
    • Enter your Telephone, Position, and Category field
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print Roster table
    • Label Printout #3
    • For credit, show your Roster table and Printout #3 to the instructor...

Friday, May 13 (A)
Monday, May 16 (B)

Team “L”

• Exercise 10 (404 - 408)
• Read and review Exercise chapter
  • Related Tables
  • Enforce Referential Integrity
  • Print Relationships
  • Show Related Records
• Right-click here (Save Link As...), save file as AC10
• Exercise 10:  Complete Exercise
  • Step 2
    • Make sure you close all tables
    • Rename ALL tables to include - Student Name
       
  • Step 6
    • Print Relationship report
    • Label Printout #1
       
  • Step 17
    • Open the tblOrderDetails table
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print tblOrderDetails table
    • Label Printout #2

Team “M”

• Exercise 10:  ON YOUR OWN (409)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC10
  • Step 2
    • Make sure you close all tables
    • Rename ALL tables to include - Student Name
       
  • Step 7
    • Enter two products for John Smith (ID = 1) in the subdatasheet
    • Once both products are entered for John Smith, close ALL tables
    • Open the Equipment table, Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print Equipment table
    • Label Printout #3

Wednesday, May 11 (A)
Thursday, May 12 (B)

Team “I”

• Exercise 9 (399 - 402)
• Read and review Exercise chapter
  • Insert a Field on a Datasheet
  • Change Field Properties from Datasheet
  • Move a Column
  • Hide and Unhide Columns
  • Change Datasheet Column Widths
  • Freeze Columns
• Right-click here (Save Link As...), save file as AC09
• Exercise 9:  Complete Step 5 - 15...
  • Step 19
    • Close the tblProducts Table, and rename it to tblProducts - Student Name
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top to 0.5, Bottom Margins to 0.25", and Left/Right Margins to 0.25"
    • Print ONLY Pages 1 - 2
    • Label Printout #1
       
  • Step 23
    • Close the tblCustomers Table, and rename it to tblCustomers - Student Name
    • Open the tblCustomers - Student Name Table in Datasheet View
    • Add a "Header Record"
      • Company ID =  1
      • You First Name
      • Your Last Name
      • Current Date
      • Your Zip Code
      • Your Phone Number
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Pages 1 - 2
    • Label Printout #2

Team “J”

• Exercise 7:  ON YOUR OWN (389)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC07
  • Step 2
    • Before opening the Roster Table, rename it to Roster - Student Name
       
  • Step 7
    • Enter information for EACH blank field in the Roster table
    • Positions include:  Pitcher, Catcher, First Base, Second Base, and Third Base
    • Make-up birthdates for each player
    • Choose "Yes" for the first two, and last two players' Send Card? field
       
  • Step 8
    • Before closing the Roster Table, Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Page 1
    • Label Printout #2

Team “K”

• Exercise 9:  ON YOUR OWN (403)
• Read and follow ALL instructions carefully...
• Right-click here (Save Link As...), save file as OAC09
  • Step 1
    • Before opening the Roster Table, rename it to Roster - Student Name
       
  • Step 4
    • Use the baseball positions found on the footnote below step #4 in the textbook.
       
  • Step 5
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Page 1
    • Label Printout #3
    • Don't forget to "unhide" your "hidden" fields once you print!!!
       
  • Step 8
    • Before closing the Roster Table, Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Page 1
    • Label Printout #4

Monday, May 9 (A)
Tuesday, May 10 (B)

Team “G”

• Exercise 7 (384 - 388)
• Read and review Exercise chapter
  • Open a Table for Editing in Design View
  • Rename a Field in Design View
  • Add a Field in Design View
  • Delete a Field in Design View
  • Reorder Fields
  • Change Field Properties
• Right-click here (Save Link As...), save file as AC07
• Exercise 7:  Complete Exercise
  • Step 19
    • Close the tblProducts Table, and rename it to tblProducts - Student Name
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top to 0.5, Bottom Margins to 0.25", and Left/Right Margins to 0.25"
    • Print ONLY Pages 1 - 2
    • Label Printout #1
       
  • Step 23
    • Close the tblCustomers Table, and rename it to tblCustomers - Student Name
    • Open the tblCustomers - Student Name Table in Datasheet View
    • Add a "Header Record"
      • Company ID =  1
      • You First Name
      • Your Last Name
      • Current Date
      • Your Zip Code
      • Your Phone Number
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Pages 1 - 2
    • Label Printout #2

Team “H”

• Exercise 9 (399 - 402)
• Read and review Exercise chapter
  • Insert a Field on a Datasheet
  • Change Field Properties from Datasheet
  • Move a Column
  • Hide and Unhide Columns
  • Change Datasheet Column Widths
  • Freeze Columns
• Right-click here (Save Link As...), save file as AC09
• Exercise 9:  Complete Step 1 - 4 ONLY

Friday, May 6 (B)

Team “D”

• Exercise 4 (374 - 378)
• Read and review Exercise chapter
  • Open a Database File
  • Create a Table with a Template
  • Create a Table in Design View
  • Select a Field for the Primary Key
  • Open a Database Exclusively
  • Set a Database Password
• Right-click here (Save Link As...), save file as AC04
• Exercise 4:  Complete Exercise
  • Step 5
    • Add a "Header Record" to tblCustomers Table before printing
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Page 1
    • Label Printout #1

Team “E”

• Lesson 1:  Concept Test - Right-click here (Save Link As...)
  • Database Basics:  Pg. 350 - 352
  • Exercise 1:  Pg. 353 - 360
  • Exercise 2:  Pg. 361 - 367
  • Exercise 3:  Pg. 368 - 373
  • Exercise 4:  Pg. 374 - 379
  • Exercise 5:  Pg. 380 - 381
  • Exercise 6:  Pg. 382

Team “F”

• Lesson 2:  Concept Test - Right-click here (Save Link As...)
  • Exercise 7:  Pg. 384 - 389
  • Exercise 8:  Pg. 390 - 398
  • Exercise 9:  Pg. 399 - 403
  • Exercise 10:  Pg. 404 - 409
  • Exercise 11:  Pg. 410
  • Exercise 12:  Pg. 411 - 412

Thursday, May 5 (A)

• Access Basics Crossword Puzzle
• Right-click here (Open in New Tab...), and PRINT
  • Locate Word Bank "clues" starting on Page 350...
  • Define words/terms and build Word Bank to complete Crossword Puzzle
  • Be sure to complete, and turn-in BOTH (Word Bank & Crossword Puzzle)!!!
    

Tuesday, May 3 (A)
Wednesday, May 4 (B)

Team “A”

• Exercise 1 (Pg. 353 - 359)
• Read and review Exercise chapter
  • Start Access and Open a Database
  • Work with the Navigation Pane
  • Save a Copy of a Database
  • Open and Close Objects in a Database
  • Move through a Datasheet or Form
  • Sort Records
• Right-click here (Save Link As...), save file as AC01
• Exercise 1:  Complete Exercise

Team “B”

• Exercise 2 (Pg. 361 - 366)
• Read and review Exercise chapter
  • Enter Records
  • Edit Records
  • Select Records
  • Delete Records
  • Print Datasheets and Forms
  • Print Preview
• Right-click here (Save Link As...), save file as AC02
• Exercise 2:  Complete Exercise
  • Step 10
    • Add a "Header Record" to tblEmployees Table before printing
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Page 1
    • Label Printout #1
       
  • Step 17
    • Open tblEmployees Table
    • Select the last NINE (9)  records (including the "Header Record")
    • Resize ALL columns
    • Change to LANDSCAPE Orientation
    • Change the Top/Bottom Margins to 0.5", and Left/Right Margins to 0.25"
    • Print ONLY Page 1
    • Label Printout #2

Monday, May 2 (B)

• Access Basics Crossword Puzzle
• Right-click here (Open in New Tab...), and PRINT
  • Locate Word Bank "clues" starting on Page 350...
  • Define words/terms and build Word Bank to complete Crossword Puzzle
  • Be sure to complete, and turn-in BOTH (Word Bank & Crossword Puzzle)!!
    

Monday, April 25 (B)
Tuesday, April 26 (A)

• Database Basics (Pg. 350 - 352)
• Read and review Exercise chapter
  1. What is Access?
     A)  Pg. 350, bullet 1
     B)  Pg. 350, bullet 2
  2. What is a Database?
     A)  Pg. 350, bullet 1
     B)  Pg. 350, bullet 2
     C)  Pg. 350, bullet 3
     D)  Pg. 350, bullet 4
     E)  Pg. 350, bullet 5
  3. What is a Database Management System?
     A)  Pg. 350, bullet 1
     B)  Pg. 350, bullet 2
  4. How is an Access Database Organized?
     A)  Pg. 351, heading 1
     B)  Pg. 351, heading 2
     C)  Pg. 351, heading 3
  5. How are Tables Related?
     A)  Pg. 352, bullet 1
     B)  Pg. 352, bullet 2
     C)  Pg. 352, bullet 3
     D)  Pg. 352, bullet 4
      
• Create a new folder in your BIM I Folder, and rename it Access
• Create a new MS-Word document, save it in the new Access folder, and name it WHAT IS - student name
• Type the five (5) questions above, and type your answers in outline format using the chapter reading
• Add a document header, and PRINT