5910 Breckenridge Pkwy Suite B, Tampa, FL. 33610
(800) 272-0707

SkillSoft Explore Course

Productivity & Collaboration Tools     Microsoft Office 2010     Access 2010     Microsoft Office 2010: Beginning Access
Microsoft Office Access 2010 makes it easy for you to create and modify database tables. This course discusses how basic tables are built, including creating fields and defining data types and properties, and how to modify them. It also demonstrates the use of primary keys, masked input fields, and indexing, as well as creating validation rules for the data.

Objectives

Basic Tables in Access 2010

  • recognize the correct naming convention for tables
  • create tables in Design view
  • create tables in Datasheet view
  • create a primary key for a table
  • create input masks for table fields
  • create indexes for table fields
  • create validation rules
  • modify tables
  • create a basic table
  • modify a basic table