Make your own free website on Tripod.com

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

Wildcats

Access


| Home | BIM (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, May 30 (B)
Friday, May 27 (A)/Tuesday, May 31 (A)

  • 2nd Semester Exam
    Right-click here (Save Link As...), save file as Semester Exam (Spring 2011)
    Wait for Exam Instructions...


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

 


Team “C”

  • 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

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





1A
2A 4A 4B
May
3
  • Erik C./Tiffany T.
May 3
  • Angela L.
  • Anna G.
  • Robert C.
May 3
  • OPEN
  • OPEN
  • Brittany M./Darek M.
May 4
  • Anthony P.
  • Christian Y./Brandon G.
  • OPEN
May 5
  • N/A
May 5
  • N/A
May 5
  • N/A
May 6
  • Daysia S.
  • Christian Y.
  • Brandon G.
May 9
  • OPEN
  • OPEN
May 9
  • Robert C.
  • OPEN
May 9
  • Juan G./Juan Z.
May 10
  • OPEN
  • OPEN
May 11
  • OPEN
  • Oscar C./Britney M.
  • Juan J.
May 11
  • OPEN
  • Robert C.
May 11
  • Brittany M./Darek M.
  • Selina H./Stephanie P.
  • OPEN
May 12
  • OPEN
  • OPEN
  • OPEN
May 13
  • Primo G./Brittany R.
May 13
  • Kristin C.
  • Ramses A./Stephanie M.
  • David S.
May 13
  • Fernando F./Sergio O.
  • Alejandra P.
May 16
  • OPEN
  • OPEN
May 17
  • OPEN
  • Gabriela C.
May 17
  • OPEN
  • Esai H./Alex G.
May 17
  • Jannet O.
  • Wesley R.
May 18
  • OPEN
  • Roxy Y./Troy T.
May 19
  • Emilia T./Evelyn M.
  • OPEN
May 19
  • Anna G.
  • Evelyn C./Melita P.
May 19
  • Abbey P.
  • Alejandra F.
May 20
  • OPEN.
  • Veronica Q.
May 23
  • Rei C.
  • Gabriela A.
May 23
  • Victoria L./Elliot C.
  • Armando M./Joe H.
May 23
  • Jose G./Ricardo E.
  • Kerry Z./Isidro Y.
May 24
Senior Exams
  • Daysia S.
  • Joann C./Brenda P.
May 25
  • Christine R./Alejandra D.
  • Leslie S./Iris G.
May 25
  • Blanca L.
  • Frank T.
May 25
Senior Exams
  • Esthela M.
  • Ylissa G./Jullianna B.
May 26
  • Veronica B./Alfonso F.
  • Luis C./Osvaldo L.
May 27
Exams
NO PRESENTATIONS May 27
Exams
NO PRESENTATIONS May 27
Review
  May 30
Exams
NO PRESENTATIONS
May 31 NO CLASS May 31 NO CLASS May 31
Exams
NO PRESENTATIONS    



The following assignments will be presented to the class using a PowerPoint presentation and class demonstration of the assignment(s).
Pick wisely
.