Microsoft Access 2010

1. Microsoft Access 2010 Lesson 3, Part 1 Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

2. Learning Objectives Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

3. Calibri size 11 Formatting a Table Datasheet By default, Access creates every table in using the default font type and size. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

4. You cannot change the default font from this option only the “size” and “weight”. Another Option Would Be: You could try using the Font button in the Theme group. Alternatively switch to design view. Click the Format tab and then Select All. You can then use any combination from the Font Group to change the format. Switch back to datasheet and you will see the changes there. Changing the default font & size Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

5. Use the Home Ribbon to change the appearance Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

6. Change the table background & gridline colors Click the “launcher” under the Text Formatting group. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

7. Change the table background & gridline colors Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

8. Add cell special effects to enhance the appearance of the table. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

9. Click & Drag method Double-click between column headers Shortcut Menu Default size The default size of the cells, columns, and rows in a table can be modified. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

10. To keep an area of a visible while you scroll to another area, you can freeze one or more of the fields (columns). The fields that you freeze move to the leftmost position on the datasheet. Freezing, Unfreezing and Hiding Columns Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

11. Export a table . . . Exporting a table as a Web page (HTML) or Adobe Acrobat (PDF) will allow for the table data to be viewed without being altered. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

12. Design View Modifying Field Properties Each field in a table has properties that are dependent upon the data type of the field. Field properties can only be viewed in Table Design View. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

13. Available Field Properties depends on the “data type” Modifying Field Properties con’t Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

14. Change the Field Size in Properties Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

15. Input Mask or Lookup Field Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

16. Example of Input Mask Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

17. Input Mask – con’t Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

18. You can create a lookup field that stores multiple values per record. Example of Lookup Field Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

19. Apply a Smart Tag to a database Smart Tags can also be used to schedule meetings, add contacts to instant messaging, and enable a slew of other conveniences all from within an Access database. Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787

20. Apply a Smart Tag to a database –con’t Access Lesson 3 Lesson Plans Michele Smith – North Buncombe High School, Weaverville, NC 28787