Modifying Tables in Access 2013


Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description
Microsoft Office Access 2013 makes it easy for you to modify database tables. It allows you to customize the table fields, and control and restrict data entry. You can modify the records and sort and filter them. And, you can also customize the visual appeal by formatting the table. This course explores ways to modify tables. It will cover creating and modifying fields, controlling data entry with required fields, indexing, input masks, and data validation rules. The course will also cover ways manage records including adding, updating, deleting records, as well as sorting and filtering. Finally, it will cover ways to format a table.

Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Access 2013

Prerequisites
None

Expected Duration (hours)
1.0

Lesson Objectives

Modifying Tables in Access 2013

  • create and modify fields in Access 2013
  • control how data may be entered into a database in Access 2013
  • decide how to create fields and control data entry in Access 2013
  • add and modify records in Access 2013
  • sort and filter records in Access 2013
  • manage records in Access 2013
  • format a table in Access 2013
  • decide how to format a table in Access 2013
  • Course Number:
    mo_bgas_b02_dt_enus

    Expertise Level
    Intermediate