Examples of Poor Primary Keys

1. Examples of Poor Primary Keys Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

2. Primary Key & Foreign Key Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

3. Modifying a Table in Design View Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

4. Data Type hyperlink Hyperlinks Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

5. Record Selector New Record Button Adding & Editing Records After table creation, records CAN be added to the table. The table must be viewed in Datasheet view in order to add data. The user can click in any individual area of a record to enter data. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

6. Edit Mode Add & Editing – con’t Record Navigation Buttons Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

7. To change data in a record – click inside the cell. To delete data from a record …select the content and press delete. Adding & Editing – con’t To delete a record…right-click the record selector and select “delete record”. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

8. Moving & Deleting Fields Fields in a table can be moved to better organize the table for data entry. Deleting a field in a table will delete all data that appears in that field as well. You can also delete or move rows of data. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

9. Select the “gray” box to the left of the “field name” you want to move. Next, “drag n’ drop” to new location. Move a Field in Design View See the results?? Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

10. To delete the “Field Name” select the field name and press delete. How to delete a field in Table Design View To delete the entire “field” you can select the row, right click and select “delete rows” Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

11. Delete a record using cut Deleting Records Now, the record for “Smith, Michele” is now deleted. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

12. Deleting a row in Datasheet View Deleting a row will permanently remove an entire record of data from the table. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

13. Printing Tables Individual tables can be printed without printing the entire database. Using Print Preview will allow the user to see how the table will appear printed. Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

14. Printing Tables Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

15. Use the zoom controls to help zoom in or out of the table. Printing Tables Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

16. Zoom in or out using the Print Preview Tab and the Zoom Group Printing Tables Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

17. Under the Print Preview tab there are several options you can use to change document settings before printing. Printing Tables Access Lesson 2 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787