
At a Glance
600 Pages
23.5 x 17.5 x 4
Paperback
RRP $66.50
$31.75
52%OFF
or 4 interest-free payments of $7.94 with
orCompared to industrial-strength database products such as Microsoft's SQL Server, Access is a breeze to use. It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.
Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.
The Missing Credits Introduction | |
Storing Information in Tables | |
Creating Your First Database | |
Understanding Access Databases | |
Getting Started | |
Creating a New Database | |
Understanding Tables | |
Creating a Simple Table | |
Editing a Table Saving and Opening | |
Access Databases | |
Making Backups | |
Saving a Database with a Different Name or Format | |
Opening a Database | |
Opening More Than One Database at Once | |
Opening a Database Created in an Older Version of Access | |
Creating Another Database | |
The Navigation Pane | |
Browsing Tables with the Navigation Pane | |
Managing Database Objects | |
Building Smarter Tables | |
Understanding Data Types | |
Design View Organizing and Describing Your Fields | |
How Updates Work in Design View | |
Access Data Types | |
Text Memo Number Currency Date/Time Yes/No Hyperlink Attachment AutoNumber | |
The Primary Key | |
Creating Your Own Primary Key | |
Field Six Principles of Database Design | |
Choose Good Field Names | |
Break Down Your Information | |
Include All the Details in One Place | |
Avoid Duplicating Information | |
Avoid Redundant Information | |
Include an ID Field | |
Mastering the Datasheet: Sorting, Searching, Filtering, and More | |
Datasheet Customization Formatting the Datasheet | |
Rearranging Columns Resizing Rows and Columns Hiding Columns Freezing Columns | |
Datasheet Navigation | |
Sorting Filtering | |
Searching Advanced Editing | |
The Spell Checker | |
AutoCorrect | |
Special Characters | |
Printing the Datasheet | |
Print Preview | |
Fine-Tuning a Printout | |
Blocking Bad Data | |
Data Integrity Basics | |
Preventing Blank Fields | |
Setting Default Values | |
Preventing Duplicate Values with Indexes | |
Input Masks | |
Using a Ready-Made Mask | |
Creating Your Own Mask | |
Validation Rules | |
Applying a Field Validation Rule | |
Writing a Field Validation Rule | |
Creating a Table Validation Rule | |
Lookups Creating a Simple Lookup with Fixed Values | |
Adding New Values to Your Lookup List | |
Linking Tables with Relationships | |
Relationship Basics | |
Redundant Data vs. Related Data | |
Matching Fields: The Relationship Link | |
Linking with the ID Column | |
The Parent-Child Relationship | |
Using a Relationship | |
Defining a Relationship | |
Editing Relationships | |
Referential Integrity | |
Navigating a Relationship | |
Lookups with Related Tables | |
More Exotic Relationships | |
One-to-One Relationship | |
Many-to-Many Relationship | |
Relationship Practice | |
The Music School | |
The Chocolate Store | |
Manipulating Data with Queries | |
Queries | |
That Select Records | |
Query Basics | |
Creating Queries | |
Creating a Query in Design View | |
Creating a Simple Query with the Query Wizard | |
Understanding the SQL View Queries and Related Tables | |
Joining Tables in a Query | |
Outer Joins | |
Multiple Joins | |
Essential Query Tricks | |
Calculated Fields | |
Defining a Calculated | |
Field Simple Math with Numeric Fields | |
Expressions with Text Query Functions | |
Using a Function | |
The Expression Builder | |
Formatting Numbers | |
More Mathematical Functions | |
Text Functions | |
Date Functions | |
Dealing with Blank Values (Nulls) | |
Summarizing Data | |
Grouping a Totals Query | |
Joins in a Totals Query | |
Query Parameters | |
Queries That Update Records | |
Understanding Action Queries | |
Testing Action Queries (Carefully) | |
The Action Query | |
Family Update Queries | |
Append Queries | |
Creating an Append (or Make-Table) | |
Query Getting Auto Numbers to Start at Values | |
Other Than 1 Delete Queries | |
Tutorial: Flagging Out-of-Stock Orders | |
Finding Out-of-Stock Items Putting the Orders on Hold | |
Analyzing Data with Crosstab | |
Queries and Pivot | |
Tables | |
Understanding Crosstab Q | |
Table of Contents provided by Publisher. All Rights Reserved. |
ISBN: 9780596527600
ISBN-10: 0596527608
Series: Missing Manuals
Published: 12th January 2007
Format: Paperback
Language: English
Number of Pages: 600
Audience: General Adult
Publisher: O'Reilly Media, Inc, USA
Country of Publication: US
Dimensions (cm): 23.5 x 17.5 x 4
Weight (kg): 1.3
Shipping
Standard Shipping | Express Shipping | |
---|---|---|
Metro postcodes: | $9.99 | $14.95 |
Regional postcodes: | $9.99 | $14.95 |
Rural postcodes: | $9.99 | $14.95 |
How to return your order
At Booktopia, we offer hassle-free returns in accordance with our returns policy. If you wish to return an item, please get in touch with Booktopia Customer Care.
Additional postage charges may be applicable.
Defective items
If there is a problem with any of the items received for your order then the Booktopia Customer Care team is ready to assist you.
For more info please visit our Help Centre.