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

Microsoft Access 2007 is a program designed to create and use a database. This first Guide will take you through getting started and building your confidence in the skills needed to use the software productively.

Table of Contents

Lesson 1 What is a Database Running the MS Access program Creating a New Database Creating a New Folder Working the main menu Creating a Table - Design View - Field Name, Data Type, Description Setting up a field Field Properties (Format, Size, etc) Input Mask Inserting a New Row Primary Keys Yes (No Duplication) Saving a Table Design Closing a Database Exiting the MS Access program Lesson 2 Opening a Database Opening a Table Entering Data to a Table Column Widths Correcting Saving a Table Moving around with Shortcuts Table Design View Table Datasheet View MS Access Templates Lesson 3 Opening a File Sorting Selecting a Record Deleting a Record Find Adding fields and updating data Lesson 4 Removing Gridlines Print Preview Zooming In and Out Landscape Page Setup Removing Headings Close Print Preview Print Fill/Back Color Fill/Font Color Font and Size Italics and Bold

Lesson 5 The Report Creating a Report (Report Wizard) Editing Labels Selecting and Moving Labels Font/Fore Color Report Headers/Footers Saving a Report Lesson 6 Table Design view Table Datasheet view Opening a Report Preview Report Design view Lesson 7 Creating a Database Setting up fields in a Datasheet Field Properties Selecting Multiple Columns Hiding Columns Unhide Columns Datasheet Formatting Window Lesson 8 Forms Form View New Records Entering Text to a Form Saving a Form AutoFormat Form Form Design View Removing a Selection Removing Fields Fill/Back Color Next/Last Record Refresh Go To Moving through the Records Lesson 9 Report Wizard (Grouping fields) Report Design View Report Preview Save As Deleting a Form Closing the Navigation Panel Lesson 10 Yes/No formats Selecting Multiple Columns Report Page Setup

Get your copy now.