Access in easy steps by Mike McGrath -- Read -- Imperial Library of Trantor

Index

Cover Title Copyright Contents 1 Getting Started

Introducing Access Launching the Access app Exploring the user interface Customizing Quick Access Managing files Backstage Personalizing Access options Converting older databases Using Access templates Searching for templates Getting some Help Applying Access updates

2 Designing Databases

Arranging related data Understanding relationships Developing database design Producing data Tables Optimizing database design

3 Creating Tables

Exploring the Table window Working in Datasheet View Formatting Datasheets Working in Design View Managing rows Setting the Primary Key Selecting data types Attaching objects Calculating fields Specifying field properties Stating Validation Rules Creating an Input Mask Defining a Default Value Referencing Indexes Providing a Lookup Column

4 Defining Relationships

The Relationships window Specifying relationships Enforcing integrity Specifying Join properties Directing Joins

5 Handling Data

Entering data Using the Clipboard Copying data to/from Excel Importing data from Excel Importing data from Access Managing import tasks Exporting data from Access Filtering data Totaling fields Checking spelling Formatting Tables

6 Making Queries

Introducing Queries Employing the Query Wizard Working with Query Design Adding criteria to a Query Querying multiple Tables Stating criteria for numbers Specifying criteria for text Creating a Make Table Query Creating an Append Query Creating an Update Query Creating a Delete Query

7 Coding Queries

Introducing SQL Exploring the SQL window Using the Select clause Using the Where clause Employing SQL functions Combining Union Queries

8 Producing Forms

Designing a Form Entering data via a Form Filtering Form data Employing the Form Wizard Providing a Simple Form Offering a Split Form Presenting Multiple Items Finding a record

9 Enhancing Forms

Working with Design View Employing the Field List Working with Layout View Adding Headers and Footers Adding controls to a Form Fine-tuning Form controls Changing control properties Creating Calculated controls Adjusting the Tab Order Producing a Tabbed Form Using Command Buttons Displaying a Modal Dialog Executing Macros

10 Supplying Reports

Exploring the Report Wizard Providing a Simple Report Working with 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 Sending Reports via email

11 Sharing Access

Protecting with passwords Preventing alteration Securing with backups Splitting databases Interacting with SharePoint

Backcover