Basic Access 2007 Tables

Course details

Microsoft Office Access 2007 makes it easy for you to create and manipulate database tables. You can choose between a Datasheet view and a Design view to create tables from scratch, or you can base your tables on one of the many pre-defined templates. The introduction of the Ribbon and contextual tabs in Access 2007 makes table creation even more intuitive, and provides you with easier data manipulation techniques. This course explains the use of table templates, Design and Datasheet views, field creation, data types, and modifiable properties, and demonstrates the use of masked input fields and indexing. The course also explores viewing, editing, navigating, sorting, finding, and filtering records, in addition to printing data and implementing and maintaining table relationships.

• create a table from a template in a given scenario
• identify the elements in an Access 2007 table
• identify the table templates
• create a table using Datasheet view
• create a table using Design view
• modify a table
• modify a table in Design view
• create a validation rule
• create a masked input field in a table
• apply indexing to a table
• create a table from a template
• modify a table
• create a table in datasheet view and add a validation rule
• create an input mask
• manipulate data in records in Access 2007
• view, edit, and navigate records
• sort and filter data
• find and replace data
• print records
• create a relationship
• filter table information
• create a relationship
• edit a relationship
• create a relational database in Access 2007