Modifying Tables in Access 2013

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
60 minutes

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.

Objective

Working with Fields in Access

  • 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
  • Managing Records

  • add and modify records in Access 2013
  • sort and filter records in Access 2013
  • manage records in Access 2013
  • Formatting Tables

  • format a table in Access 2013
  • decide how to format a table in Access 2013
  • MONTHLY SUBSCRIPTION

    $129/month
     

    ANNUAL SUBSCRIPTION

    $1295/year

    Multi-license discounts available for Annual and Monthly subscriptions.