PC Simplicity Series
PB/262x200/IllusB&W. 48 pp
ISBN: 9781877431494

Microsoft Access 2010 is a program designed to create and use a database. This second Guide will take you through the more advanced functions of the software so you can become more productive. It assumes you have the skills taught in the previous Guide.
Note: You will need the Access Tables files called Golf Members and Births you created in 'Getting Started'.

Table of Contents

Lesson 1 Creating a Table Current Date Formula Short Date Format Default Value Input Mask Lesson 2 Creating a new Form Rulers and Grids Form Width Form Header Height Labels Special Effect Shadow Border Resizing Labels Fill Background Color Line Transparent Form View Drawing a Line Thick Line Moving a Label Adding Field List Inserting a Field Moving a Field Label Editing a Field Label Close Field List Panel Close Navigation Panel Delete a Field Label Lesson 3 Select Property Sheet Tab Index Order Uppercase Conversion Adding a Formula to a Field Lesson 4 Edit Field Visible Yes/No Filters Total Filter on Forms

Lesson 5 Query Design Report Design Creating a Query Join Tables Join Properties Adding Fields to a Query Table Editing Data / Refresh Datasheet View Query Sort & Criteria Saving a Query Lesson 6 Report Widening the Working area Page Headers Labels More Font Colors New Line Code Images Text Boxes Text Box Properties Date Formula Line Colour Print Preview Zoom Select All Margins Lesson 7 Attaching a Record Source Group & Sort Copy Paste Group and Sort Footer Area Sum Formula Page Break Date Formula plus 30 days Print a Report

Get your copy now.