Make your own free website on Tripod.com

Mr. Gonzalez's Website
Weslaco East High School

Wildcats

Access


| Home |BCIS (II) |
| Access | Excel | MicroType | PowerPoint | Word |

Friday, December 12 (A)
Tuesday, December 16 (A)

  • Grade Check/Update
  • Tech Prep of the Rio Grande Valley, Inc.
  • Video...
  • PowerPoint Presentation...
  • Click here to access the Tech Prep website...
  • Wait for instructions on how to register...
  • Successful registration will count as a 10-POINT BONUS on Semester Exam Grade!!!

 

Access Semester Practice Exam - Fall 2008

  • Wait for printed instructions
  • Use Microsoft Access 2007
  • Right-click here (Access Semester Practice Exam (December 2008)),
    Save Link As...Access Semester Practice Exam (December 2008) - Firstname_Lastname


Monday, December 08 (A) - Wednesday, December 10 (A)
 

  • Access Pop Quiz

  • Click here to download/print INSTRUCTIONS...

  • 3 Quiz Grades!!!

  • Deliverables (Printouts) - One page each:

    1. TABLE - Firstname Lastname (Landscape)

    2. FORM - Firstname Lastname

    3. REPORT - Firstname Lastname (Landscape)


Thursday, December 04 (A)
 

  • Activity 6.5 - Creating a Lookup Field with Multiple Columns

  • Pg. 430 - 432 (Steps 1 - 11)


  • Activity 6.6 - Creating an Input Mask Using a Wizard

  • Pg. 432 - 433 (Steps 1 - 7)


  • Activity 6.7 - Creating a Custom Input Mask

  • Pg. 433 - 435 (Steps 1 - 11)


  • Activity 6.8 - Classifying Fields as Required

  • Pg. 436 - 438 (Steps 1 - 6)


Objectives:

  1. Create Indexes and Change Sort Order

  2. Create Relationships Between Tables

  3. Create Forms and Reports with Related Tables


  • Activity 6.9 - Assigning Default Values to Fields

  • Pg. 438 - 439 (Steps 1 - 7)


  • Activity 6.10 - Setting Validation Properties

  • Pg. 439 - 442 (Steps 1 - 10)


  • Activity 6.11 - Testing a Validation System in a Form

  • Step 15:  Print Form

  • Pg. 442 - 444 (Steps 1 - 16)


Outcomes (Project 6B):  Build and work with related tables.

 

 

 


Tuesday, December 02 (A)
 

Chapter 6:  Designing and Building a Relational Database (MS-Access 2007)

Objectives:

  1. Customize Table Fields (Activity 6.1 - 6.3)

  2. Structure Data Input (Activity 6.4 - 6.7)

  3. Validate Input (Activity 6.8 - 6.11)

Outcomes (Project 6A):  Structure and validate data in a database.


  • Activity 6.1 - Adding Captions to Fields

  • Right-click here (a06A_Classes), Save Link As...6A_Classes_Firstname_Lastname

  • Pg. 420 - 422 (Steps 1 - 11)


  • Activity 6.2 - Creating a Yes/No Field and Set a Default Value

  • Pg. 422 - 424 (Steps 1 - 6)


  • Activity 6.3 - Creating and Populating an Attachment Field

  • Rename Instructors table to Instructors Firstname Lastname

  • Right-click here, Save Link As...a06A_Patel

  • Right-click here, Save Link As...a06A_Booth

  • Pg. 424 - 427 (Steps 1 - 16)

  • Save REPORT (Step 16)

  • Print REPORT (AFTER saving in Step 16)...


  • Activity 6.4 - Creating a Lookup Field from a Typed List

  • Pg. 428 - 430 (Steps 1 - 10)


  • Activity 6.5 - Creating a Lookup Field with Multiple Columns

  • Pg. 430 - 432 (Steps 1 - 11)


  • Activity 6.6 - Creating an Input Mask Using a Wizard

  • Pg. 432 - 433 (Steps 1 - 7)


  • Activity 6.7 - Creating a Custom Input Mask

  • Pg. 433 - 435 (Steps 1 - 11)


Objectives:

  1. Create Indexes and Change Sort Order

  2. Create Relationships Between Tables

  3. Create Forms and Reports with Related Tables

Outcomes (Project 6B):  Build and work with related tables.