Basic Access tables 2007

Course details

Microsoft Office Access 2007 makes creating and manipulating database tables. You can choose between a Datasheet view and a design ± or create tables from scratch; but also © n can base your tables in one of the many predefined templates are available. The introduction of the Ribbon and contextual tabs in Access 2007 makes creating tables aáºn is more intuitive and offers Tá © techniques of handling more simple data. In this course templates using tables, views ± o design data sheet, creating fields, data types and properties that can be modified is explained; In addition, the use of masked input fields and indexing shown. Also © n a tour of the display, editing, scanning, sorting, and filtering records quest, plus data printing and the implementation and maintenance of relationships of tables is done.

• create a table from a template in a given situation
• identify the elements of a table from Access 2007
• identifying table templates
• create a table using the Datasheet view
• create a table using the design view or ±
• modify a table
• modify a table in the design view or ±
• create a validation rule
• create a masked input field in a table
• applying an indexing table
• create a table from a template
• modify a table
• create a table in Datasheet view and add a validation rule
• create a mask input
• manipulate data records in Access 2007
• view, edit and navigate through records
• sort and filter data
• find and replace data
• print records
• create a relationship
• filter information table
• create a relationship
• modify a relationship
• create a relational database in Access 2007