160 likes | 317 Vues
Homework 1 Hints. Homework Tips (General). Go through and do the ENTIRE homework in the same time period You will use all of the material from chap 1 & 2 Guided Exercises to do the chap 2 Applied Exercise!! You will probably forget how to do steps if you split up the work
E N D
Homework Tips (General) • Go through and do the ENTIRE homework in the same time period • You will use all of the material from chap 1 & 2 Guided Exercises to do the chap 2 Applied Exercise!! • You will probably forget how to do steps if you split up the work • Go in order of the steps (some steps build) • Give yourself AT LEAST 3-4 hours to do the homeworks
Homework Tips (General) • Compact & Repair may fix a strange bug or action in your database • Use when in doubt • SAVE OFTEN • Keep track of what file version(and the name) that you are submitting • Read the text step-by-step CAREFULLY. • Homework is graded so that ALL steps must be completed (you cannot skip around and choose) • Check that what you are modifying in design views is working in other views and looks right!
Homework (General) • Save Database First • Open with Access 2013 always • Always “Enable Content” at the top of the database • Both Object Type and All Access Options should be selected and displayed on the left side of your database.
Homework #1 • “Canned” Input Mask • Simply, (XXX) XXX – XXXX • Creating a Drop-Down Menu • Switch to DESIGN VIEW • Highlight (or Create) chosen field • Under “Data Type” select “Lookup Wizard” • Select: “I Will Type In The Values I Want”
Homework #1 • Date Function: Date() • Not a trick • Validation rule • Returns today’s date • Mathematical Rules: • <> - Date cannot equal today • > - Date must be greater than today
Homework #1 • Resumé • You must insert your resumé • If you do not have a resumé: make one • DO NOT USE SOMEONE ELSE’S • DO NOT PUT IN YOUR SOCIAL SECURITY NUMBER
Homework #1 • Grade break down: • Chap #1 GE 20% • Chap #2 GE 20% • Chap #2 AE 60% • Representative of most homework**
Homework #1 • Chap #1 Guided Exercise • Self explanatory • Chap #2 Guided exercise • You MUST be in DESIGN view for steps #8-22 • Pay attention to “General” and “Lookup” tabs at the bottom of the screen in design view • Data type is “TEXT” unless otherwise stated in design view • Step #9: • “Caption” property is on the bottom of the screen • Step #10: • “validation text & rule” are also on the bottom of the screen and are 2 separate fields
Chap #2 Guided Exercise Help • Step #11 • Make sure to set format property (at the bottom of the screen) to SHORT DATE • Step #14 • Consider when doing the Applied Exercise • Step #16-#21 • how to make a drop down** used in AE • Also forces user to ONLY select one of the pre-selected options (cannot add their own options, aka: cities) (step #21) • Step #22 forces the user to select an option (cannot be left blank) • Lookup wizard should run once data type is selected • Step #22 • Make sure to add your own record**
Chap #2 Applied Exercise • Step #1 • Steps #16-21 in Guided Exercise • Step #2 & #7 • Fill in the table in datasheet view • Step #3 • Create a new table • Add Field names “TitleCode” and “TitleName” in DESIGN view • Insert data MGR, MANAGER, etc in DATASHEET view
Chap #2 Applied Exercise • Step #4 • Step #8 &9 in GE • Field size: # of characters user is allowed to input • Caption: The Titles of each column in the table (field names) • Make sure these field names make sense • Ex. Change “F Name” to “First Name” • Ex. Make sure you changed “email” to “email address”
Step #5 (DO NOT TRY TO HARD CODE!) • Go back to “employees” table in DESIGN VIEW • Chose datatype “lookup wizard” FIRST • You will use the table “titles” for your drop down (read carefully). • Step #6 • Step #20 GE
Chap #2 Applied Exercise • Step #8 & 9 • READ CAREFULLY • Use >,<,= etc. in front of the function “Date()” • Ex. Validation rule: > Date() • This requires the date entered to be before or equal to TODAY’s date (nothing is in the parenthesis) • Step #10&11 • Use “attachment” datatype (makes the most sense correct?) • You MUST attach YOUR resume • Your name must be on it
Chap #2 Applied Exercise • Step #12 • Just add a field in DESIGN view (simple) • Step #13 (DESIGN view) • CUSTON IMPUT MASK do not give up & USE F1 and SEARCH “INPUT MASKS” choose “Control data entry formats with input masks” • You may want to take the Phone number input mask and modify it. • < and > are used to indicate uppercase and lower case. • “L” letter symbolize only a letter (requires a letter be entered) • “0” number symbolizes a number (requires a number to be entered) • “\” indicates that a certain symbol/number/letter etc. be shown • Step #14 • Go to datasheet view and CHECK to see that your input mask works by adding employee codes to each record (entry).
Troubleshooting Errors: • If you have a “Titlecode” field error in the Employees table when setting up the Employees Table. • Go to “Database Tools” • Click on “Relationships” • Delete line connecting “Title” to “Employees” • Delete “Titlecode” field in the employees table. • Re-Create a “Titlecode” field (re-start).