Teach Yourself Access 2007

Overview

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.

...
See more details below
Available through our Marketplace sellers.
Other sellers (Paperback)
  • All (4) from $1.99   
  • Used (4) from $1.99   
Close
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any BN.com coupons and promotions
$1.99
Seller since 2006

Feedback rating:

(62256)

Condition:

New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Acceptable
Former Library book. Shows definite wear, and perhaps considerable marking on inside. 100% Money Back Guarantee. Shipped to over one million happy customers. Your purchase ... benefits world literacy! Read more Show Less

Ships from: Mishawaka, IN

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$1.99
Seller since 2009

Feedback rating:

(25844)

Condition: Good
Giving great service since 2004: Buy from the Best! 4,000,000 items shipped to delighted customers. We have 1,000,000 unique items ready to ship! Find your Great Buy today!

Ships from: Toledo, OH

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
$13.99
Seller since 2015

Feedback rating:

(60)

Condition: Good
Buy with Confidence. Excellent Customer Support. We ship from multiple US locations. No CD, DVD or Access Code Included.

Ships from: Fort Mill, SC

Usually ships in 1-2 business days

  • Standard, 48 States
$29.51
Seller since 2015

Feedback rating:

(364)

Condition: Very Good
Very good.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Page 1 of 1
Showing All
Close
Sort by
Sending request ...

Overview

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.

Read More Show Less

Product Details

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

Meet the Author

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

Read More Show Less

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
Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)