Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School
2009 - 2010

Wildcats

Access


| Home | BCIS (I) |
| Access | Excel | Internet | MicroType|
|
PowerPoint | 
Word|

TO AVOID LOSING 10 POINTS (EACH PRINTOUT),
BE SURE TO STAPLE ALL OF YOUR WORK TOGETHER
IN ORDER - KEYBOARDING LESSON(S) ON TOP


Monday, December 14 (A)/Tuesday, December 15 (B)/Thursday, December 17 (B)

  • Right-click here (Save Link As...), save file as Semester Exam (Fall 2009)
    Semester Exam (Fall 2009)
    • Part I (Table) - 20 Points
    • Part II (Form) - 20 Points
    • Part III (Query) - 30 Points
    • Part IV (Form) - 30 Points
    • Bonus (Report) - 10 BONUS Points

Friday, December 11 (B)

  • SEMESTER EXAM - Monday, December 14, 2009 (A)/Tuesday, December 15, 2009 (B)
    NEED TO KNOW LIST:
     
      Exercise 2 (Pg. 361 - 366)
    • Enter Records
    • Edit Records
    • Select Records
    • Delete Records
    • Print Datasheets and Forms
    • Print Preview
       

      Exercise 3 (Pg. 368 - 372)

    • Plan a Database
    • Create a Database
    • Create a Table from a Datasheet
    • Save Changes to a Table Design
    • Delete a Field from a Datasheet
       

      Exercise 4 (Pg. 374 - 378)

    • 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
       

      Exercise 7 (Pg. 384 - 388)

    • 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
       

     


      Exercise 9 (Pg. 399 - 402)
    • Insert a Field on a Datasheet
    • Change Field Properties from Datasheet
    • Move a Column
    • Hide and Unhide Columns
    • Change Datasheet Column Widths
    • Freeze Columns
       

      Exercise 14 (Pg. 419 - 423)

    • Create a Quick Form
    • Create a Form with a Wizard
    • Create a Form from Scratch
    • AutoFormat a Form
       

      Exercise 15 (Pg. 425 - 429)

    • Understanding Layout View
    • Adjusting the Control Margins and Control Padding
    • Move Fields in the Layout
    • Size a Control
    • Delete a Control
    • Align Controls with One Another
    • Change Control Formatting
       

      Exercise 16 (Pg. 431 - 436)

    • 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

Monday, December 7 (B)/Wednesday, December 9 (B)
Tuesday, December 8 (A)/Thursday, December 10 (A)

  • 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

 

  • 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

 

  • QUIZ GRADE #1
  • 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...
         

 

  • QUIZ GRADE #2
  • 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...

Thursday, December 3 (B)
Friday, December 4 (A)

  • 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


       

  • 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

 

  • Tech-Prep RGV
  • Click here to sign-up...

Wednesday, December 2 (A)

  • 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


       

  • 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...

Monday, November 30 (A)
Tuesday, December 1 (B)

  • 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

 

  • 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

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

  • 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

 

  • Exercise 7:  ON YOUR OWN (389) - QUIZ GRADE #1
  • 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

 

  • Exercise 9:  ON YOUR OWN (403) - QUIZ GRADE #2
  • 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

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

  • 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

 

  • 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

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

  • 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

 

  • 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
  • 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

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

  • Exercise 3 (Pg. 368 - 372)
  • Read and review Exercise chapter
    • Plan a Database
    • Create a Database
    • Create a Table from a Datasheet
    • Save Changes to a Table Design
    • Delete a Field from a Datasheet
  • Create a new Database, save file as AC03
  • Exercise 3:  Complete Exercise
    • Step 4A
      • Add a "Header Record" to tblProducts Table before printing
      • Resize ALL columns
      • Change to LANDSCAPE Orientation
      • Print ONLY Page 1
      • Label Printout #1

 

  • Football Monday...?

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

  • 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

 

  • 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, November 9 (A)
Tuesday, November 10 (B)

  • 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 BCIS 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

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

  • Exercise 4 (Pg. 397 - 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 #2

 

  • Lesson 1:  Concept Test - Right-click here (Save Link As...)