Teach Yourself Access 2007

Teach Yourself Access 2007

by Moira Stephen

Paperback

$10.79 $12.95 Save 17% Current price is $10.79, Original price is $12.95. You Save 17%.

Temporarily Out of Stock Online

Eligible for FREE SHIPPING

Overview

Teach Yourself Access 2007 by Moira Stephen

Get all-access to Access

Whether working for a small company or huge corporation, if you deal with large amounts of data you will likely need to use Access. Teach Yourself Access 2007 covers all the program's capabilities and functions. From design and table manipulation to reports, macros, and modules, this step-by-step tutorial is your authoritative guide, whether you are new to the software or a seasoned pro.

Product Details

ISBN-13: 9780071497091
Publisher: McGraw-Hill Companies, The
Publication date: 07/28/2007
Series: Teach Yourself Series
Pages: 240
Product dimensions: 5.00(w) x 7.60(h) x 0.58(d)

About the Author

Moria Stephen has written many computer books and is a college lecturer in further and higher education.

Table of Contents


Preface     ix
Getting started     1
What is a database?     2
Database jargon     3
Schematic diagram     4
Access objects     5
System requirements     6
Installing Access     7
Preparing your data     8
Normalization of data     9
Starting Access     11
Create a blank database     12
The Access screen     14
Quick Access toolbar     16
Ribbon keyboard shortcuts     18
Navigation pane     18
Status bar configuration     20
Help     20
Exiting Access     22
Database design     23
The project     24
Draw up a list of requirements     24
Identify the detail required     25
Normalization     28
Relationships     31
Create a new database     33
Open a database file     33
Close file     34
Table definition     35
Working with tables     36
Data types and properties     39
Setting up a table in Datasheet view     42
Setting up a table in Design view     44
Defining the Author table     47
Table templates     47
Relationships     49
Data entry and edit     54
Data entry in Datasheet view     55
Datasheet and Design view     61
Editing in Datasheet view     61
Formatting in Datasheet view     63
Data entry in Form view     66
Table manipulation     71
Changing the table structure     72
Adding and deleting records     76
Subdatasheet     77
Hiding columns     79
Freezing columns     80
Preview and Print     82
Form design     86
Introducing forms     87
Form tools     88
Form Wizard     90
Blank form     95
Adjusting controls in Layout view     96
Form Design     98
Labels     100
Formatting fields and controls     102
Adding bound controls     103
Combo boxes and list boxes     106
Checkboxes and buttons     107
Option group     108
Inserting images      109
Command buttons     110
Tab control     111
AutoFormat     112
Printing forms     113
Sort, filter and query     115
Simple sort     116
Multi-level sort     117
Find     118
Filter     119
Query Design     122
Select queries     126
Or conditions     126
And conditions     128
Comparison operators     128
Wild card characters     129
Parameter queries     130
Calculations     132
Date() function and calculation     135
Is Null/Is Not Null     135
Reports     137
Introducing reports     138
The Report tool     139
Blank report     141
Labels     142
Report Wizard     144
Report Design     148
Printing your report     150
Pivottables and pivotcharts     152
PivotTable view     153
Pivotcharts     161
Templates     166
Database templates     167
Exploring your database     168
Navigation pane     170
Table templates     171
Categories and groups     173
Objects, categories and groups     174
Adding objects to groups     176
Hiding groups and objects     177
Custom group maintenance     180
Macros     182
Introducing macros     183
Recording a macro object     183
Testing the macros     185
Adding the macro to a form     186
Embedded macros     187
Security and confidentiality     190
Backups     191
Database password     191
Hidden objects     193
Sharing data     194
E-mail     195
Importing data     196
Exporting data     198
Data tables     201
Author table data     202
Publisher table data     204
Book table data     206
Category table data     208
Taking it further     209
Index     211

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews