Access 2007: In Easy Steps

Be the first to write a review

Want to read this on your NOOK? Request as NOOK Book from the publisher

Thank you for requesting this book as a NOOK book from the publisher.

Customers Who Bought This Also Bought

More About This Book

Overview
Product Details
Table of Contents

Advertising

Overview

Unlike other jargon-filled books of hernia-inducing proportions, Access 2007 in easy steps 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.

Product Details

ISBN-13: 9781840783209
Publisher: In Easy Steps Limited
Publication date: 5/10/2007
Pages: 192
Sales rank: 982,574
Series: In Easy Steps Series
Product dimensions: 7.30 (w) x 8.80 (h) x 0.50 (d)

Getting Started     7
What is Access 2007?     8
The Getting Started Screen     9
The Quick Access Toolbar     10
Using the Office Button     12
Personalizing Access 2007     15
Converting Older Databases     16
Using Office Online     18
Get Training Online     19
Downloading New Content     20
Downloading New Templates     21
Using Templates     22
Using the Ribbon     24
Using the Navigation Pane     25
Using the Help System     26
Designing Databases     27
Relational Databases     28
Relationship Types     30
Database Design     32
Before You Even Start Access     33
Designing Tables     34
Primary and Foreign Keys     35
Fine-Tuning Your Design     36
Creating Tables     37
The Table Window     38
Using Table Templates     39
Using Datasheet View     40
Adding and Deleting Fields     41
Data Types in Datasheet View     43
Using Design View     44
Creating aTable     45
Inserting a Design View Row     46
Deleting a Design View Field     47
Setting the Primary Key     48
Using Data Types     49
Using Attachments     51
Specifying Field Properties     52
Using Validation Rules     53
Creating an Input Mask     54
Setting a Default Value     55
Using Indexes     56
Creating a Lookup Column     58
Defining Relationship     61
The Relationships Window     62
Adding Tables     63
Specifying Relationships     64
Referential Integrity     56
Specifying Join Properties     68
Left and Right Joins     70
Working With Data     71
Entering Data     72
Inserting Rows     73
Using the Clipboard     74
Copying and Pasting Data     75
Copying Directly from Excel     76
Copying Data to Excel     77
Importing Data from Excel     78
Importing Data from Access     83
Linking to Access Databases     85
Managing Import Tasks     87
Collecting Data with Email     88
Filtering Data     94
Totalling Columns     96
Spell-Checking Data     97
Formatting Data     98
Querying Databases     101
What is a Query?     102
Using the Query Wizard     103
Query Design View     106
Adding Criteria to a Query     108
Querying Multiple Tables     109
Using Criteria for Numbers     110
Using Criteria for Text     111
Creating a Make Table Query     112
Creating an Append Query     114
Creating an Update Query     115
Creating a Delete Query     116
Using SQL     117
Using SQL     118
The Three Languages of SQL     119
Opening the SQL Window     120
Using the Select Clause     121
Using the Where Clause     122
SQL Aggregate Functions     123
Creating Union Queries     124
Creating Forms     125
What is a Form?     126
The Anatomy of a Form     127
Using a Form for Data Entry     128
Filtering Forms     130
Applying a Detailed Filter     131
Using the Form Wizard     132
Creating a Simple Form     135
Using Split Forms     136
Using Multiple Item Forms     139
Finding a Record     140
Fine-Tuning Forms     141
Using Design View     142
Using Layout View     143
Using the Field List     144
Adding Headers and Footers     145
Adding Controls to a Form     146
Fine-Tuning Controls     147
Changing Control Properties     148
Creating Calculated Controls     149
Changing Tab Order     150
Creating a Tabbed Form     151
Using Buttons     154
Creating a Modal Dialog     156
Using Macros     160
Creating Reports     161
Using the Report Wizard     162
Creating a Simple Report     166
Using Report Design View     167
Adding Fields to a Report     168
Adding Controls to a Report     169
Adding Headers and Footers     170
Sorting and Grouping Data     171
Printing Labels     172
Setting Custom Label Sizes      175
Using Print Preview     176
Printing Reports     177
Send Your Report via Email     178
Sharing Access     179
Password Protection     180
Making an ACCDE Database     182
Backing-up Access Databases     183
Splitting a Database     184
Interacting with SharePoint     186
Index     187

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:

Review Guidelines

Tell the world what you think of this product.

Add Recommendations

Your Name: Create a Pen Name or Leave Anonymously

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.

Anonymous

Posted April 16, 2012

Worth the money

Great book except, I wish that it would have taken me through an entire database setup as in other "in easy step" books.
Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.

If you find inappropriate content, please report it to Barnes & Noble

Access 2007: In Easy Steps

Overview

Customers Who Bought This Also Bought

More About This Book

Overview

Product Details

Table of Contents

Customer Reviews

Rating Distribution

5 Star

4 Star

3 Star

2 Star

1 Star

Your Rating:

Your Recommendations:

Barnes & Noble.com Review Rules

Reviews by Our Customers Under the Age of 13

What to exclude from your review:

Reviews should not contain any of the following:

Reminder:

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

Worth the money