|
Brilliant Access 2007 Pocket Book
Exactly what you need to know - just when you need it!
Brilliant Access 2007 Pocket Book is a handy, visual quick-reference guide to the most common features, tasks and problems, that you will come across when using Access 2007 in any day-to-day situation at home or in the office.
brilliant Microsoft Access 2007 Pocket Book
Brilliant
Access 2007 Pocket Book delivers the answers you need when you are faced with an unfamiliar or problematic task in Access 2007. Short, concise explanations and a highly visual, step-by-step approach make it really easy to learn and master any task or problem that you come across Keep it on your desk, in your bag - or even in your pocket - and you will always have the answers you need, just when you need them.
Brilliant Access 2007 includes:
* Foolproof step-by-step instructions for accomplishing specific tasks
* Numerous screenshots illustrating every step
* Jargonbuster boxes explaining new or unfamiliar terms in plain English
* Timesaving tips to give you ideas on cutting corners and avoiding confusion
* Additional information on key topics to expand your knowledge of a particular feature or concept.
* Important information boxes identifying areas where new users often run into trouble, and offering practical hints and solutions to these problems
Brilliant Pocket Books are handy, accessible resources that you will turn to time and time again when faced with a problem or an unfamiliar task and need an answer at your fingertips.
CONTENTS:
Introduction
1. What's New in Access 2007
· Using The Ribbon
· Taking Advantage of the Quick Access Toolbar
· Working with the Navigation Pane
· Other New Tools and Features to Watch For
2. Access 2007 Fundamentals
· Opening Access
· Function Keys
· View Options
· Saving in Access
· Exiting Access
3. Understanding Access 2007
· Databases and Objects
· Tables
· Forms
· Queries
· Reports
· Macros
· Modules
· The Sandbox Operating Mode
· Changing the Registry Key
4. The New File Format
· Understanding the New File Format
· Converting a Database into an Access 2007 File
5. Database Fundamentals
· Understanding Databases
· Designing a Database
· Setting Up Primary Categories
· Adding Subcategories
· Choosing Primary Keys
· Establishing Table Relationships
· Analysingthe Design
6. Creating a Database
· Creating a New, Blank Database
· Creating a Database from a Template
· Opening an Existing Database
· Copying a Database
· Closing a Database
7. Publishing a Database to a Sharepoint Site
· What Are Sharepoint Services?
8. Finding Information in Your Database
· Finding Words or Phrases
· Replacing Words or Phrases
9. Collecting Information Using Outlook 2007
· When to Use Electronic Data Collection
· Things to Know Before You Collect Electronic Data
· Collecting Data Via the E-Mail
· Managing Your Data Collection Replies
10. Table Relationships and Design
· Understanding Table Relationships
· Creating a Table Relationship
· Changing a Table Relationship
· Deleting a Table Relationship
· Designing a Table
11. Creating Tables
· Creating a New, Blank Table in an Existing Template
· Creating a Table from a Template
· Creating a Table with Links or Imported Information
· Entering Data in a Table
· Setting Table Properties
· Setting the Primary Key for a Table
· Removing the Primary Key for a Table
12. Copying or Exporting Table Data
· Copying Data from Another Source into Your Table
· Exporting a Table to a Sharepoint Site
13. Editing Tables
· Changing Column Width
· Changing the Row Height
· Changing Font Style and Size
· Freezing a Column
· Changing the Look and Feel of Your Table
· Deleting Records
14. Saving, Closing or Deleting a Table
· Saving a Table
· Closing a Table
· Deleting a Table
15. Using Fields in a Table
· Inserting a New Field into a New Table
· Inserting a New Field into an Existing Table
· Adding an Existing Field to a Table
· Changing a Field's Content
· Deleting a Field
· Moving or Copying Data in a Field
· Hiding or Unhiding a Field
· Setting Field Properties
16. Working with Lookup Columns
· What is a Lookup Column?
· Lookup Field Properties
· Creating a Lookup Column Using the Lookup Wizard
· Changing a Lookup Column
· Changing a Field to a Lookup Column
17. Using Forms
· Understanding Forms
· Form Wizard
· Entering Data into a Form
18. Creating Forms
· Creating a Form Using the Form Tool
· Creating a Form Using the Split Form Tool
· Creating a Form with the Blank Form Tool
· Creating a Form That Contains a Sub Form
· Adding a Logo to Your Form
19. Working with Field Controls
· What Are Field Controls?
· Moving Field Controls
· Changing the Size of a Control
20. Adding Special Controls
· Using Windows Visual Theme In Controls
· Adding Text Box Controls
· Creating a List Box or Combo Box
· Creating a Calculated Control
· Creating a Command Button
· Creating an Option Group
· Inserting Date and Time into a Form or Report
21. Using Expressions
· Understanding Expressions
· Creating an Expression Using the Expression Builder
22. Using Conditional Formatting
· Applying Conditional Formatting to a Control Based on its Own Value
· Using an Expression to Apply Conditional Formatting to Controls
· Changing the Conditional Formatting of a Focus Control
· Removing Conditional Formatting
23. Sorting and Finding Data
· The Difference Between Sorting and Filtering
· Sorting a Table, Query or Form
· Sorting Records in Case-Sensitive Order
· Sorting Records in a Customised Order
· Sorting Records Based on Numeric Values Stored in a Text Field
· Sorting Records by Date Values
24. Using Filters
· Understanding Filters
· Filtering Table Data by Selection
· Applying Advanced Filters
· Saving Filters as Queries
25. Reporting Fundamentals
· Understanding Report Sections
· Choosing Record Sources for Your Report
· Using Totals, Averages, Percentages or Running Sums in Reports
26. Creating a Report
· Creating a Report Using the Report Wizard
· Creating a Report Using the Report Tool
· Creating a Report Using the Blank Report Tool
· Creating and Using Subreports
· Creating a Grouped or Summary Report
27. Saving or Editing a Report
· Modifying Your Report in the Layout View
· Modifying Your Report in the Design View
· Creating Alternating Row Colours
28. Previewing, Printing and E-Mailing A Report
· Viewing Your Report
· Printing Your Report
· E-Mailing Your Report
29. Creating a Query
· Understanding Queries
· Creating a Select Query Using the Query Wizard
· Creating a Union Query
· Creating and Running an Update Query
· Creating and Running an Append Query
· Creating a Make Table Query
30. Adding to a Query
· Adding Criteria to a Query
· Adding Calculations to a Query
31. Editing a Query
· Editing Data in a Query
· Finding, Hiding or Eliminating Duplicate Data
32. Summarizing and Saving Queries
· Summarizing Query Values
· Saving the Query Results
33. Joining Tables and Queries
· Using Inner Joins
· Using Outer Joins
· Using Cross Joins
· Using Unequal Joins
· Removing a Join
34. Using Multivalued Fields in a Query
· Displaying a Multivalued Field in a Query
· Displaying a Bound Value in a Query
· Searching for More Than One Query in a Multivalued Field
· Using a Query as a Mailmerge Source
35. Working with Attachments
· Adding an Attachment Field to a Table
· Attaching A Field Directly to a Table
· Using Attachments with Forms and Reports
· Saving Attached Files to Other Locations
· Removing Attached Files
36. Importing and Exporting
· Understanding Importing and Exporting Operations
· Running, Saving and Scheduling an Import Operation as a Specification
37. Printing in Access
· Printing an Access File
· Printing in Landscape Orientation
· Creating and Printing Labels
· Customising Labels
38. Using Macros
· Understanding Macros
· New Macro Features in Access 2007
· Creating a Macro
· Fixing a Macro
· Enabling or Disabling Macros
39. Working with Security Settings
· The Trust Center
· Adding or Removing A Developer from a Trusted Location
· Changing a Trusted Location
· Encrypting Your Database
· Opening an Encrypted Database
· Removing a Password from an Encrypted Database
· Using the Package-and-Sign Feature
|
