Access+It

ACCESS IT!

Watch introduction video in class.

• Name and save a database • Create a table • Define a database table structure • Save a table • Adjust column widths • Change the page setup to landscape • Print a table || 1/2/2012 || • Format a currency field • Sort in ascending order Sort in descending order • Format a date field • Format a yes/no field • Format a hyperlink field || 1/3/2012 || • Create a query || Challenge you to figure it out, using help, a book or trial and error. Using the Movie database we created. || • Set a field size • Set a field format • Set a caption property || || In design view, click the Validation Rule box in the Field Properties Pane. Type the following: <8/31/1991
 * ~ Acitivity No.# ||~ Title ||~ New Skills Reinforced ||~ Due Date ||
 * 01/2/01 || Celebrity Addresses || • Create a database
 * 2, 4, 6 & 7 || Movies Combining || • Format a number field
 * 2, 4, 6 & 7 || Movies Combining || • Format a number field
 * Reference #6 ||  || • Sort by multiple fields
 * 8 || Jobs || • Add a description property || 1/4/2012 ||
 * 8 || Jobs || • Set field properties
 * 9 || States || • Specify a primary key || [[file:ACTIVITY 9 - STATES - STUDENTS.mdb]] ||
 * 10 || Colleges || • Create an Input Mask || [[file:ACTIVITY 10 - COLLEGES - Students.mdb]] ||
 * 14 || Driver Education Class || * Create a validation rule

Type the following from the book: Student not old enough to enroll
 * Click on the Validation Test box in the Field Properties pane
 * Enter records 11-15,
 * Try entering yourself. || [[file:ACTIVITY 14 - DRIVER EDUCATION CLASS - STUDNETS.mdb]] ||
 * 17 || PGA Tour || * in design view format, Earnings to currency with 0 decimal places
 * sort the Tour Leaders in ascending order by Number of Events
 * Create a New QUERY to determine the number of golfers in the TOUR LEADERS table who played in less than 20 tournaments for the year. Sort the query in ascending order by Number of Events.(SAVE as Less than 20 Tournaments)
 * Create a new QUERY to determine the number golfers in the TOUR LEADERS table who played in 20 or more tournaments for the year. Sort the query in ascending order by Number of Events.(SAVE as 20 or more tournaments)
 * || [[file:ACTIVITY 17 - PGA TOUR - STUDENT.mdb]] ||
 * 18 || James Bond Movies || Follow the relevant directions in the book starting at Instruction #12 through #20. || [[file:ACTIVITY 18 - JAMES BOND MOVIES - Students.mdb]] ||
 * 19 || Cars || Follow the directions in the book starting with instruction #11 and #12 || [[file:ACTIVITY 19 - CARS - Students.mdb]] ||
 * 20 || Yearbook || Follow the direction in the book starting with instruction # 10 - #19 (how could you use this feature) || [[file:ACTIVITY 20 - YEARBOOK - Students.mdb]] ||