Modifying Tables in Access 2013

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

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