Make your own free website on Tripod.com

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

Wildcats

Access


| Home |BCIS (II) |
| Access | Excel | MicroType | PowerPoint | Word |
Monday, December 14 (A)
  • Players Database (2004):
    • Read and review ALL instructions carefully...
    • Right-click here (Open Link in New Tab) - Players Database (2004) Directions
      • Printout #1:  Table
      • Printout #2:  Table
      • Printout #3:  Table
      • Printout #4:  Table
      • Printout #5:  Query
      • Printout #6:  Form

Tuesday, December 8 (A)
  • Registration Database (2002):
    • Read and review ALL instructions carefully...
    • Right-click here (Open Link in New Tab) - Registration Database (2002) Directions
      • Printout #1:  Labels
      • Printout #2:  Report
      • Printout #3:  Table

 

  • School Database (2008):
    • Read and review ALL instructions carefully...
    • Right-click here (Open Link in New Tab) - School Database (2002) Directions
      • Printout #1:  Table
      • Printout #2:  Report
      • Printout #3:  Report

Wednesday, December 2 (A)/Friday, December 4 (A)
  • Park Database (2005):
    • Read and review ALL instructions carefully...
    • Right-click here (Open Link in New Tab) - Park Database (2005) Directions
    • Highly recommended that you print the instructions...
    • Label Printouts as follows:
      Part I
      • Printout #1:  tblParkTable - Student Name
      • Printout #2:  tblParkTable - Student Name
      • Printout #3:  tblParkTable - Student Name

      Part II

      • Printout #4:  qryAcres300 - Student Name
      • Printout #5:  frmParkTable - Student Name

      Part III

      • Printout #6:  rptParkTable - Student Name

Monday, November 30 (A)
  • PBA Customers Database (2007):
    • Read and review ALL instructions carefully...
    • Right-click here (Open Link in New Tab) - PBA Customers (2007) Directions
    • Highly recommended that you print the instructions...
    • Label Printouts as follows:
      • Part I:  Table - Printout #1
      • Part II:  Filtered Table - Printout #2
      • Partt III:  Query - Printout #3
      • Part IV:  Query - Printout #4
      • Part V:  Labels - Printout #5
      • Part VI:  Report - Printout #6

Monday, November 23 (A)
  • ACCESS QUIZ:
    • Read and review ALL instructions carefully...
    • Right-click here (Open Link in New Tab) - Access Exam Directions
    • Highly recommended that you print the instructions...
    • Label Printouts as follows:
      • Part I:  Table - Printout #1
      • Part II:  Form - Printout #2
      • Print III:  Report - Printout #3
      • Print IV:  Report - Printout #4

Thursday, November 19 (A)
  • ON YOUR OWN:  Exercise 25 (Pg. 829):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Save Link As...) - OAC25
    • Open EACH report in Design View
      • Edit EACH Report Title to include your First and Last Name.
      • Print three (3) Reports
      • Label Printout #1, #2, and #3

 

  • ON YOUR OWN:  Exercise 26 (Pg. 834):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Save Link As...) - OAC26
    • Open EACH Report in Design View
      • Edit EACH Report Title to include your First and Last Name
      • Print two (2) Reports
      • Label Printout #4, and #5

 

  • ON YOUR OWN:  Exercise 27 (Pg. 838):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Save Link As...) - OAC27
      • Add a "Header Record" before printing labels..
      • Print Labels
      • Label Printout #6

Tuesday, November 17 (A)
  • Exercise 29 (Pg. 840):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Open Link in New Tab) - Exercise 29 Directions
    • Right-click here (Save Link As...) - AC29
    • Open the Author Report Report in Design View
      • Follow all instructions.
      • Edit the title to include your First and Last Name.
      • Print Report
      • Label Printout #1

 

  • QUIZ GRADES:
    • Quiz 1:  Concept Test - Right-click here (Save Link As...)
    • Quiz 2:  Concept Test - Right-click here (Save Link As...)

Friday, November 13 (A)
  • Exercise 27 (Pg. 837):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Open Link in New Tab) - Exercise 27 Directions
    • Right-click here (Save Link As...) - AC27
    • Step 2A
      • Open the tblMembers Table
        Add a "NEW" record with your "Header" information
        • MemberID:  99
        • FirstName:  Your First Name
        • LastName:  Your Last Name
        • MailingAddress:  Pg. 837, AC27 - 3A
        • City:  11/13/2009
      • Print Page 1 of labels
      • Circle your "Header Record" Label
      • Label Printout #1

 

  • Exercise 28 (Pg. 839):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Open Link in New Tab) - Exercise 28 Directions
    • Right-click here (Save Link As...) - AC28
    • Step 3A
      • Open the rptPhoneList Report in Design View
      • Edit the Report Title to include " - Student Name"
      • Label Printout #2
    • Step 6A
      • Print rptHours Report in Design View
      • Edit the Report Title to include " - Student Name"
      • Label Printout #3
    • Step 7A
      • Open the tblEmployees Table
      • Add a "Header Record" to the Table
      • Label Printout #4

Wednesday, November 11 (A)
  • Exercise 25 (Pg. 828):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Open Link in New Tab) - Exercise 25 Directions
    • Right-click here (Save Link As...) - AC25
    • Step 4A
      • Open the rptMemberPhoneList Report in Design View
      • Edit the Report Title to include " - Student Name"
      • Print ONLY 1 copy
      • Label Printout #1
    • Step 6
      • Open the rptPoolMailingList1 in Design View
      • Edit the Report Title to include " - Student Name"
      • Print rptPoolMailingList1 Report
      • Label Printout #2
    • Step 8
      • Open the rptClassesByPrice in Design View
      • Edit the Report Title to include " - Student Name"
      • Print rptPoolMailingList1 Report
      • Label Printout #3
    • Step 10
      • Open the rptWhoTeachesWhat in Design View
      • Edit the Report Title to include " - Student Name"
      • Print rptPoolMailingList1 Report
      • Label Printout #4

 

  • Exercise 26 (Pg. 833):
    • Read and review ENTIRE Exercise chapter carefully...
    • Right-click here (Open Link in New Tab) - Exercise 26 Directions
    • Right-click here (Save Link As...) - AC26
    • Step 7A
      • Open the rptClassesByPrice Report in Design View
      • Edit the Report Title to include " - Student Name"
    • Step 9
      • Print rptClassesByPrint Report
      • Label Printout #5
    • Step 15
      • Edit the Report Title to include " - Student Name"
      • Change Orientation:  Landscape
      • Label Printout #6

Monday, November 9 (A)

Access your grades using the Student Portal

  • Check your current grade (passing or not passing?)
  • Check for missing assignments

 

  • Exercise 23 (Pg. 819):
    QUIZ GRADE #1!
  • Read and review ENTIRE Exercise chapter carefully...
  • Right-click here (Open Link in New Tab) - Exercise 23 Directions
  • Right-click here (Save Link As...) - AC23
  • Step 1A
    Open the tblEmployees table
    Add a "NEW" record with your "Header" information
    • EmployeeID:  E999
    • Prefix:  Your Prefix (Mr. or Ms.)
    • FirstName:  Your First Name
    • LastName:  Your Last Name
    • MailingAddress:  Pg. 819, AC23 - 3A
    • City:  Weslaco
    • Position:  Physician
  • Step 3
    • Change Margins:  Top/Bottom = 1", and Left/Right = 0.25"
    • Change Orientation:  Landscape
    • Print Page 1 ONLY
    • Label Printout #1
  • Step 6
    • Change Margins:  Top/Bottom = 1", and Left/Right = 0.5"
    • Change Orientation:  Landscape
    • Label Printout #2
  • Step 8
    Open the tblTimecards table
    Add a "NEW" record with your "Header" information
    • Employee:  E999
    • WeekStartDate:  Current Date
    • HoursWorkedBase:  40
    • HoursWorkedOvertime:  0
    • Change Margins:  Top/Bottom = 1", and Left/Right = 0.5"
    • Change Orientation:  Landscape
    • Label Printout #3

 

  • Exercise 24 (Pg. 820):
    QUIZ GRADE #2!
  • Read and review ENTIRE Exercise chapter carefully...
  • Right-click here (Open Link in New Tab) - Exercise 24 Directions
  • Right-click here (Save Link As...) - AC24
    Make the necessary adjustments to the table(s), and query criteria to ensure the following:

    Post1900 Query:

    "Pg. 820, AC24 - 3A" appears in the Title field
    Your Last Name appears in the Last Name field
    Your First Name" appears in the First Name field
    Label Printout #4

    Abbotts Query:
    "Pg. 820, AC24 - 3A" appears in the Title field
    Your Last Name appears in the Author field
    Current Year appears in the Date Published field
    Label Printout #5

Tuesday, November 3 (A)/Thursday, November 5 (A)

  • 2nd Six-Weeks Exam
    Read ALL instructions carefully...
    Follow ALL instructions...
    • Right-click here (Save Link As... ) for Exam instructions - Page 1 of 2
    • Right-click here (Save Link As...) for Exam instructions - Page 2 of 2
    • Right-click here (Save Link As...) - Saxon

Friday, October 30 (A)

  • Access your grades using the Student Portal
    • Check your current grade (passing or not passing?)
    • Check for missing assignments

 

  • Exercise 21 (Pg. 808 - 812):
    • Compare Queries to Sorts/Filters
    • Create a Query with a Wizard
    • Create a Query in Query Design View
    • Display the Query Datasheet
    • Save a Query
  • Read and review ENTIRE Exercise chapter carefully...
  • Right-click here (Open Link in New Tab) - Exercise 21 Directions
  • Right-click here (Save Link As...) - AC21
  • Step 2A
    • Add a "NEW" record with your "Header" information
    • MemberID:  99
    • First:  Your First Name
    • Last:  Your Last Name
    • Address:  Pg. 812, AC21 - 3A
    • City:  Weslaco
    • Phone:  956-969-6950
    • Term Date:  Current Date
    • Select ALL columns, and resize (Best Fit)
  • Step 21A
    • Run the qryPoolMailing1 Query
    • Resize ALL columns
    • PRINT - Query Results (datasheet view)
    • Circle your "Header" record

 

  • Exercise 22 (Pg. 814 - 817):
    • Open a Query for Editing
    • Select, Move, and Delete Fields
    • Add Fields to a Query
    • Use all Fields of a Table for a Query
    • Rename a Query
    • Save a Copy of a Query
  • Read and review ENTIRE Exercise chapter carefully...
  • Right-click here (Open Link in New Tab) - Exercise 22 Directions
  • Right-click here (Save Link As...) - AC22

 

Wednesday, October 28 (A)

  • Access your grades using the Student Portal
    • Check your current grade (passing or not passing?)
    • Check for missing assignments

 

  • Exercise 19 (Pg. 798 - 801):
    • Find Text
    • Replace Data
    • Search Using Wildcards
    • Use Multiple Sorts
    • Change Column Order
    • Remove a Sort
  • Read and review ENTIRE Exercise chapter carefully...
  • Right-click here (Open Link in New Tab) - Exercise 19 Directions
  • Right-click here (Save Link As...) - AC19
  • Step 7A
    • Add a "NEW" record with your "Header" information
    • MemberID:  99
    • First:  Your First Name
    • Last:  Your Last Name
    • Address:  Pg. 801, AC19 (1)
    • City:  Class Period
    • Term Date:  Current Date
    • Select ALL columns, and resize (Best Fit)
  • Step 11
    • PRINT - tblMembers table
    • Circle your "Header" record
  • Step 16
    • Update "Header" record
    • Address:  Pg. 801, AC19 (2)
    • PRINT - tblMembers table
    • Circle your "Header" record

 

  • Exercise 20 (Pg. 803 - 806):
    • Filter a Record Subset
    • Filter By Selection
    • Filter for Multiple Selections
    • Filter for Entry
    • Filter By Form
    • Save Filter Results as a Query
  • Read and review ENTIRE Exercise chapter carefully...
  • Right-click here (Open Link in New Tab) - Exercise 20 Directions
  • Right-click here (Save Link As...) - AC20
  • Step 3A
    • Add a "NEW" record with your "Header" information
    • MemberID:  99
    • First:  Your First Name
    • Last:  Your Last Name
    • Address:  Pg. 806, AC20 (1)
    • City:  Class Period
    • Phone:  956-969-6950
    • Term Date:  Current Date
    • Select ALL columns, and resize (Best Fit)
  • Step 7
    • PRINT - tblMembers table
    • Circle your "Header" record
  • Step 9A
    • Update "Header" record
    • Term Date:  Your Birth Date
  • Step 11
    • Update "Header" record
    • Address:  Pg. 801, AC20 (2)
    • PRINT - tblMembers table
    • Circle your "Header" record

 

 

 

 

 

 

 

 

 

Thursday, September 3 (A)

  • MS-Word 101 Quiz
    • Instructions right-click here (Open Link in New Tab) - Part I, II, and III
    • Save Quiz in your Word folder as MS Word 101 (Quiz)
    • MS Word 101 (Quiz) - PowerPoint (use with Part III), right-click here (Open Link in New Tab)
    • Staple ALL work together, and in order (MicroType Lessons on top)