1 / 20

Microsoft Access 2010

Microsoft Access 2010. Lesson 3, Part 1. Learning Objectives. Calibri size 11. Formatting a Table Datasheet. By default, Access creates every table in using the default font type and size. You cannot change the default font from this option only the “size” and “weight”.

dylan
Download Presentation

Microsoft Access 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related