Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School

Wildcats

Access


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

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


Thursday, February 12 (A)
Friday, February 13 (B)

ObjectivesCompare Queries to Sorts/Filters, create a Query with a Wizard, create a Query in Query Design View, display the Query Datasheet, and save a Query.

Access - Exercise 21 - Pg. 692

  • AC21 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC21 - firstname lastname)
  • Step 2.2  Rename ALL tables to include your firstname lastname
  • Step 2.3  Include your firstname lastname as part of the name of ALL Queries created.

ObjectivesOpen 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; and save a copy of a Query.

Access - Exercise 22 - Pg. 697

  • AC22 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC21 - firstname lastname)
  • Step 2.2  Rename ALL tables to include your firstname lastname
  • Step 2.3  Include your firstname lastname as part of the name of ALL Queries created.

Tuesday, February 10 (A)
Wednesday, February 11 (B)

ObjectivesFind text, replace data, search using wildcards, use multiple sorts, change column order, and remove a sort.

Access - Exercise 19 - Pg. 681

  • AC19 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC19 - firstname lastname)

ObjectivesFilter a record subset, filter by selection, filter for multiple selections, filter for entry, filter by form, and save filter results as a Query.

Access - Exercise 20 - Pg. 686

  • AC20 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC20 - firstname lastname)
  • Step 2.2:  Rename tblMembers table to tblMembers - firstname lastname

Friday, February 6 (A)
Monday, February 9 (B)

ObjectivesWork 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, and insert a form title.

Access - Exercise 16 - Pg. 672

  • AC16 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC16 - firstname lastname)
  • Step 11.1:  Enter your First and Last name in the Notes field
  • Step 11.2:  Print your form (Selected Records).

ObjectivesUse Lookups and Forms.

4th Six-Weeks Exam
Access - Exercise 17 - Pg. 674

  • AC17 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC17 - firstname lastname)
  • Step 22.1:  Use the form, add a new record
  • Step 22.2:  Enter your First and Last name in the new record
  • Step 22.3:  Print your form (Selected Records).

Wednesday, February 4 (A)
Thursday, February 5 (B)

ObjectivesCreate a Quick Form, create a Form with a Wizard, create a Form from scratch, and use AutoFormat a Form.

 BONUS ASSIGNMENT (ON YOUR OWN)
Access - Exercise 14 - Pg. 659

  • AC14 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC14 - firstname lastname)
  • Step 2.2:  Rename tblClasses table to tblClasses - firstname lastname
  • Step 4.1:  Rename tblMembers table to tblMembers - firstname lastname
  • Step 7.1:  Rename tblInstructors table to  tblInstructors - firstname lastname
  • Step 9.1:  Open the frmInstructors - firstname lastname form in FORM VIEW
  • Step 9.2:  Go to Record 1, and PRINT (Selected Records)

ObjectivesUnderstand Layout View, adjust 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, and change control formatting.

Access - Exercise 15 - Pg. 665

  • AC15 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC15 - firstname lastname)
  • Step 10.1:  Enter your First and Last name in the Notes field
  • Step 10.2:  Print your form (Selected Records).

Monday, February 2 (A)
Tuesday, February 3 (B)

  • Grades Update...
  • Click here for Access Database Assignment (Worth a Quiz Grade)...
  • See Bonus Assignment (ON YOUR OWN) below...

ObjectivesCreate a Quick Form, create a Form with a Wizard, create a Form from scratch, and use AutoFormat a Form.

 BONUS ASSIGNMENT (ON YOUR OWN)
Access - Exercise 14 - Pg. 659

  • AC14 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC14 - firstname lastname)
  • Step 2.2:  Rename tblClasses table to tblClasses - firstname lastname
  • Step 4.1:  Rename tblMembers table to tblMembers - firstname lastname
  • Step 7.1:  Rename tblInstructors table to  tblInstructors - firstname lastname
  • Step 9.1:  Open the frmInstructors - firstname lastname form in FORM VIEW
  • Step 9.2:  Go to Record 1, and PRINT (Selected Records)

Thursday, January 29 (A)
Friday, January 30 (B)

ObjectivesCreate a Lookup, create a Value List, create field values from another table, and create a Multivalued field.

Access - Exercise 13 - Pg. 653

  • AC13 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 1.1  Once saved, Save a Copy which includes your full name (AC13 - firstname lastname)
  • Step 7.1:  Rename tblClassOfferings table to tblClassOfferings - firstname lastname
  • Step 7.2:  Resize filename columns before printing
  • Step 7.3:  Print tblClassOfferings - firstname lastname (Landscape orientation)  
  • Step 7.4:  With a pen or pencil, label your printout Exercise 13 - Pg. 653 

Wednesday, January 28 (B)

ObjectivesUnderstand how database data is stored in a plain text file, import database data, export database data, save import or export steps.

Progress Reports

Access - Exercise 8 - Pg. 633

  • AC08 Database file click here (Right-click and Save Link As)...
  • AC08-A.txt data file click here (Right-click and Save Link As)...
  • AC08-B.xls data file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 1.1  Once saved, Save a Copy which includes your full name (AC08 - firstname lastname)
  • Step 10.1:  Rename tblCustomers table to tblCustomers - firstname lastname
  • Step 10.2:  Resize filename columns before printing
  • Step 10.3:  Print tblCustomers - firstname lastname (Landscape orientation)  
  • Step 10.4:  Change Top Margin to 0.75"; Bottom, Left, and Right Margins to 0.5"
  • Step 10.5:  With a pen or pencil, label your printout Exercise 8 - Pg. 633 

Tuesday, January 27 (A)
 

  • Click here for Access Database Assignment...
  • Switch to Design View to design the table
  • Print tblTable - firstname lastname (Landscape orientation)  
  • Change Top Margin to 0.5"; Bottom, Left, and Right Margins to 0.25"

Monday, January 26 (B)

  • Review Progress Report

  • Make-up Work


Thursday, January 22 (A)
Friday, January 23 (B)

ObjectivesInsert a field on a datasheet, change field properties from datasheet, move a column, hide and unhide columns, change datasheet column widths, and freeze columns.

Access - Exercise 9 - Pg. 638

  • AC09 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC08 - firstname lastname)
  • Step 2.2   Review ALL exercise pages for help with assignment!!!
  • Step 13.1:  Rename tblCustomers table to tblCustomers - firstname lastname
  • Step 13.2:  Resize filename columns before printing
  • Step 13.3:  Print tblCustomers - firstname lastname (Landscape orientation)  
  • Step 13.4:  Change Top Margin to 0.5"; Bottom, Left, and Right Margins to 0.25"
  • Step 13.5:  Be sure your printout fits on 2 pages (NOT 3
  • Step 13.6:  With a pen or pencil, label your printout Exercise 9 - Pg. 638 

Wednesday, January 21 (A)

ObjectivesUnderstand how database data is stored in a plain text file, import database data, export database data, save import or export steps.

Progress Reports

Access - Exercise 8 - Pg. 633

  • AC08 Database file click here (Right-click and Save Link As)...
  • AC08-A.txt data file click here (Right-click and Save Link As)...
  • AC08-B.xls data file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 1.1  Once saved, Save a Copy which includes your full name (AC08 - firstname lastname)
  • Step 10.1:  Rename tblCustomers table to tblCustomers - firstname lastname
  • Step 10.2:  Resize filename columns before printing
  • Step 10.3:  Print tblCustomers - firstname lastname (Landscape orientation)  
  • Step 10.4:  Change Top Margin to 0.75"; Bottom, Left, and Right Margins to 0.5"
  • Step 10.5:  With a pen or pencil, label your printout Exercise 8 - Pg. 633 

Tuesday, January 20 (B)
 

  • 2009 Barack Obama Inauguration
  • CNN Live Coverage

Friday, January 16 (B)
Monday, January 19 (A)

ObjectivesOpen 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, and change field properties.

Access - Exercise 7 - Pg. 624

  • AC07 Database file click here (Right-click and Save Link As)...
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC07 - firstname lastname)
  • Additional Instructions
  • Step 22.1:  Rename tblProducts table to tblProducts - firstname lastname
  • Step 22.2:  Resize filename columns before printing
  • Step 22.3:  Print Preview tblProducts - firstname lastname (Landscape orientation)  
  • Step 22.4:  Change Top Margin to 0.75"; Bottom Margin to 0.5", and Left, and Right Margins to 0.25"
  • Step 22.5:  With a pen or pencil, label your printout Exercise 7 - Pg. 624 (1) 
  • Step 22.6:  Rename tblCustomers table to tblCustomers - firstname lastname
  • Step 22.7:  Resize filename columns before printing
  • Step 22.8:  Print tblCustomers - firstname lastname (Landscape orientation)  
  • Step 22.9:  Change Top Margin to 0.75"; Bottom Margin to 0.5", and Left, and Right Margins to 0.25"
  • Step 22.10:  With a pen or pencil, label your printout Exercise 7 - Pg. 624 (2) 

Wednesday, January 14 (B)
Thursday, January 15 (A)

ObjectivesMicrosoft Access 2007 Pop Quiz.

Wait for Pop Quiz Handout and Instructions...

  • Follow the handout instructions
  • Print and label the three printouts according to the handout instructions

Monday, January 12 (B)
Tuesday, January 13 (A)

ObjectivesPlan a database, create a database, create a table from a datasheet, save changes to a table design, rename a field in a datasheet, and delete a field from a datasheet.

Access - Exercise 3 - Pg. 608

  • Create new database (AC03 - firstname lastname) in your My Documents/Access folder
  • Additional Instructions
  • Step 6.1:  Rename tblProducts table to tblProducts - firstname lastname
  • Step 6.2:  Resize filename columns before printing
  • Step 6.3:  Print tblProducts - firstname lastname (Landscape orientation)  
  • Step 6.4:  With a pen or pencil, label your printout Exercise 3 - Pg. 608 

ObjectivesOpen 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, and set a database password.

Access - Exercise 4 - Pg. 614

  • AC04 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC04 - firstname lastname)
  • Step 4.1:  Rename tblCustomers table to tblCustomers - firstname lastname
  • Step 7.1:  Rename tblCustomerTypes table to tblCustomerTypes - firstname lastname
  • Step 12.1:  Open tblCustomers - firstname lastname table
  • Step 12.2:  Resize columns before printing
  • Step 12.3:  Print Preview, and change to Landscape orientation
  • Step 12.4:  Change Top Margin to 0.75"; Bottom, Left, and Right Margins to 0.5"
  • Step 12.5:  With a pen or pencil, label your printout Exercise 4 - Pg. 614 (1) 
  • Step 12.6:  Close tblCustomers - firstname lastname table (Save changes)
  • Step 12.7:  Open tblCustomerTypes - firstname lastname table
  • Step 12.8:  Resize columns before printing
  • Step 12.9:  Print Preview, and change to Landscape orientation
  • Step 12.10:  Change Top Margin to 0.75"; Bottom, Left, and Right Margins to 0.5"
  • Step 12.11:  With a pen or pencil, label your printout Exercise 4 - Pg. 614 (2) 
  • Step 12.12:  Close tblCustomerTypes - firstname lastname table (Save changes)

Thursday, January 8 (B)
Friday, January 9 (A)

ObjectivesEnter database records, edit database records, select database records, delete database records, print datasheets and forms, and use Print Preview.

Access - Exercise 2 - Pg. 602

  • AC02 Database file click here (Right-click and Save Link As)...
  • Save to your My Documents/Access folder
  • Additional Instructions
  • Step 2.1  Once saved, Save a Copy which includes your full name (AC02 - firstname lastname)
  • Step 10.1:  Please note that you can NOT create a header on printout
  • Step 10.2:  Add a new record.  Type your Firstname and Lastname.
  • Step 10.3:  Type the Class Period (1A, 2A, 2B, 3B, or 4B) in the Address field 
  • Step 10.4:  Print Preview, and change to Landscape orientation
  • Step 10.5:  Change Top Margin to 0.75" and Bottom Margin to 0.5"
  • Step 10.6:  With a pen or pencil, label your printout Exercise 2 - Pg. 602 (1) 
  • Step 17.1:  Please note that you can NOT create a header on printout
  • Step 17.2:  Print Preview, and change to Landscape orientation
  • Step 17.3:  Change Top Margin to 0.75" and Bottom Margin to 0.5"
  • Step 17.4:  With a pen or pencil, label your printout Exercise 2 - Pg. 602 (2)

Monday, January 12 (B)
Tuesday, January 13 (A)

ObjectivesPlan a database, create a database, create a table from a datasheet, save changes to a table design, rename a field in a datasheet, and delete a field from a datasheet..

Access - Exercise 3 - Pg. 608

  • Create new database (AC03 - firstname lastname) in your My Documents/Access folder
  • Additional Instructions
  • Step 6.1:  Rename tblProducts table to tblProducts - firstname lastname
  • Step 6.2:  Resize filename columns before printing
  • Step 6.3:  Print tblProducts - firstname lastname (Landscape orientation)  
  • Step 6.4:  With a pen or pencil, label your printout Exercise 3 - Pg. 608 

Tuesday, January 6 (B)
Wednesday, January 7 (A)

  • Mr. Gonzalez's Web Site
  • BCIS I - Web Site
  • "My Documents" Folders
  • Set-up Two (2) Printers

ObjectivesStart Microsoft 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, and sort database records.

Access - Exercise 1 - Pg. 595

  • Access Handout (Getting Started with Access 2007):  Pg. 585
  • Access Handout (Database Basics):  Pg. 586 - 588
  • Access Handout (Exercise 1 Skills Covered):  Pg. 589 - 594
  • Access Handout (Exercise 1):  Pg. 595
    • AC01 Database file click here (Right-click and Save Link As)...
    • Save to your My Documents/Access folder
    • Once saved, Save a Copy which includes your full name (AC01 - firstname lastname)