Access 2007 in easy steps

Unlike other jargon-filled books of hernia-inducing proportions Access 2007 In Easy Steps is a slim, easily read tome that neatly demonstrates the important functions of Access 2007 in a clear and concise manner without necessitating a trip to the doctor.

The narrative closely follows the database development life-cycle providing a natural progression from the first principles of good database design to advanced features such as the creation of Forms and Reports. Access 2007 In Easy Steps equips you with the basic skills needed to interact with Access 2007 on a daily basis using meaningful and appropriate examples that are based on real-life databases. Use Access 2007 In Easy Steps to learn how to integrate Access 2007 with Sharepoint Services, work with your Access 2007 database when away from the office, and collect data using email.

Andrew Unsworth is a freelance writer currently residing in the quaint Berkshire hamlet of Slough. He is a member of the British Computer Society and when not sat in front of the computer trying to beat deadlines can be found sharpening his IT skills at the offices of Resource Productions. Unlike many other authors of 'how-to' computer books he doesn't snowboard, jump off mountains, or otherwise endanger his life by any other means but sometimes wishes that he did.

1. Getting Started
   • What is Access 2007?
   • The Getting Started Screen
   • The Quick Access Toolbar
   • Using the Office Button
   • Personalizing Access 2007
   • Converting Older Databases
   • Using Office Online
   • Get Training Online
   • Downloading New Content
   • Downloading New Templates
   • Using Templates
   • Using the Ribbon
   • Using the Navigation Pane
   • Using the Help System
2. Designing Databases
   • Relational Databases
   • Relationship Types
   • Database Design
   • Before You Even Start Access
   • Designing Tables
   • Primary and Foreign Keys
   • Fine-Tuning Your Design
3. Creating Tables
   • The Table Window
   • Using Table Templates
   • Using Datasheet View
   • Adding and Deleting Fields
   • Data Types in Datasheet View
   • Using Design View
   • Creating a Table
   • Inserting a Design View Row
   • Deleting a Design View Field
   • Setting the Primary Key
   • Using Data Types
   • Using Attachments
   • Specifying Field Properties
   • Using Validation Rules
   • Creating an Input Mask
   • Setting a Default Value
   • Using Indexes
   • Creating a Lookup Column
4. Defining Relationships
   • The Relationships Window
   • Adding Tables
   • Specifying Relationships
   • Referential Integrity
   • Specifying Join Properties
   • Left and Right Joins
5. Working With Data
   • Entering Data
   • Inserting Rows
   • Using the Clipboard
   • Copying and Pasting Data
   • Copying Directly from Excel
   • Copying Data to Excel
   • Importing Data from Excel
   • Importing Data from Access
   • Linking to Access Databases
   • Managing Import Tasks
   • Collecting Data with Email
   • Filtering Data
   • Totalling Columns
   • Spell-Checking Data
   • Formatting Data
6. Querying Databases
   • What is a Query?
   • Using the Query Wizard
   • Query Design View
   • Adding Criteria to a Query
   • Querying Multiple Tables
   • Using Criteria for Numbers
   • Using Criteria for Text
   • Creating a Make Table Query
   • Creating an Append Query
   • Creating an Update Query
   • Creating a Delete Query
7. Using SQL
   • Using SQL
   • The Three Languages of SQL
   • Opening the SQL Window
   • Using the SELECT Clause
   • Using the WHERE Clause
   • SQL Aggregate Functions
   • Creating Union Queries
8. Creating Forms
   • What is a Form?
   • The Anatomy of a Form
   • Using a Form for Data Entry
   • Filtering Forms
   • Applying a Detailed Filter
   • Using the Form Wizard
   • Creating a Simple Form
   • Using Split Forms
   • Using Multiple Item Forms
   • Finding a Record
9. Fine-Tuning Forms
   • Using Design View
   • Using Layout View
   • Using the Field List
   • Adding Headers and Footers
   • Adding Controls to a Form
   • Fine-Tuning Controls
   • Changing Control Properties
   • Creating Calculated Controls
   • Changing Tab Order
   • Creating a Tabbed Form
   • Using Buttons
   • Creating a Modal Dialog
   • Using Macros
10. Creating Reports
    • Using the Report Wizard
    • Creating a Simple Report
    • Using Report Design View
    • Adding Fields to a Report
    • Adding Controls to a Report
    • Adding Headers and Footers
    • Sorting and Grouping Data
    • Printing Labels
    • Setting Custom Label Sizes
    • Using Print Preview
    • Printing Reports
    • Send Your Report via Email
11. Sharing Access
    • Password Protection
    • Making an ACCDE Database
    • Backing-up Access Databases
    • Splitting a Database
    • Interacting with SharePoint