Main Page

   
  Table of Contents
 
Show Me Microsoft Office Access 2003
By Steve  Johnson  Perspection, Inc.
 
Publisher : Que
Pub Date : October 15, 2003
ISBN : 0-7897-3004-9
Pages : 384


Microsoft Office Access 2003 provides powerful new tools with which to manage data, find and retrieve information faster than ever, share information, and integrate solutions with server side products. Access 2003 incorporates some of the latest technologies such as XML and Microsoft SharePoint to extend data exchange over an intranet or the Internet. This book covers these changes, as well as more subtle enhancements such as the addition of smart tags, a new back up database, and an error checking function to flag common mistakes. All the most important tasks are covered, and the visual format makes it easy for upgrading users to quickly get working with the latest version, or for new users to start from the beginning and build their knowledge from the ground up. Other features include a "Troubleshooting Guide" to help solve common problems, a "Project Guide" with a listing of real-world projects by feature, and a "MOS Exam Guide" with a complete listing of MOS objectives and page numbers to locate the objectives, which gives this series a clear advantage over other visual titles.

   
  Table of Contents
Show Me Microsoft Office Access 2003
By Steve  Johnson  Perspection, Inc.
 
Publisher : Que
Pub Date : October 15, 2003
ISBN : 0-7897-3004-9
Pages : 384
Copyright
      Acknowledgements
        Perspection, Inc.
        Acknowledgements
      About The Author
        We Want To Hear From You!
      Introduction
        Find the Best Place to Start
        What's New
        How This Book Works
        Step-by-Step Instructions
        Real World Examples
        Troubleshooting Guide
        Show Me Live Software
        Microsoft Office Specialist
        Chapter 1.   Getting Started with Access
        Introduction
        What Is a Database?
        Understanding How Databases Store Data
        Starting Access
        Using Task Panes
        Opening a Database
        Finding a File or Contents in a File
        Viewing the Access Window
        Arranging Windows
        Choosing Menu Commands
        Choosing Dialog Box Options
        Working with Toolbars
        Viewing Database Objects
        Getting Help While You Work
        Getting Help from the Office Assistant
        Getting Access Updates on the Web
        Saving Your Work
        Recovering an Office Program
        Detecting and Repairing Problems
        Closing a Database and Quitting Access
        Chapter 2.   Touring Access Databases
        Introduction
        Opening a Sample Database
        Using a Switchboard
        Working with Database Objects
        Grouping Database Objects
        Hiding Windows
        Touring a Table
        Touring a Form
        Entering Data
        Touring a Query
        Touring a Report
        Creating a Database Using a Wizard
        Stepping Through a Database Wizard
        Creating a Database Using a Template
        Warnings About Templates and Add-Ins
        Chapter 3.   Planning and Creating a Custom Database
        Introduction
        Creating a New Database
        Planning Tables
        Creating Tables in a Database
        Creating a Table Using a Wizard
        Setting a Primary Key Using the Table Wizard
        Assigning Table Relationships Using the Table Wizard
        Creating a Table by Entering Data
        Importing Data into Tables
        Working with a Table in Design View
        Specifying a Primary Key in Design View
        Planning Table Relationships
        Defining Table Relationships
        Ensuring Referential Integrity
        Identifying Object Dependencies
        Modifying Object Dependencies
        Chapter 4.   Working with Fields
        Introduction
        Inserting, Deleting, and Reordering Fields
        Specifying Data Types and Field Properties
        Viewing Field Properties
        Changing Field Properties
        Updating Field Properties
        Setting Field Size
        Formatting Text Values
        Formatting Number and Currency Values
        Formatting Date and Time Values
        Creating Input Masks
        Specifying Required Fields and Default Values
        Adding a Caption to a Field
        Creating Indexed Fields
        Validating Field Values
        Using Expression Builder
        Creating a Lookup Field
        Setting Lookup Properties
        Chapter 5.   Working with Tables
        Introduction
        Working with a Table
        Moving to a Specific Record in a Table
        Searching for and Replacing Text
        Entering Data Accurately with AutoCorrect
        Using Smart Tags
        Editing Text
        Working with the Clipboard
        Checking Spelling
        Arranging Columns
        Changing the Size of Rows and Columns
        Managing Columns in Datasheet View
        Formatting a Datasheet
        Repairing Renaming Errors
        Sorting Records
        Copying and Pasting Records
        Viewing a Subdatasheet
        Filtering Out Records
        Creating Complex Filters Using Forms
        Chapter 6.   Locating Specific Information Using a Query
        Introduction
        Understanding Types of Queries
        Creating a Query in Design View
        Getting Information with a Query
        Modifying a Query in Design View
        Creating a Query Using a Wizard
        Changing the Query Fields
        Specifying Criteria for a Single Field
        Specifying Criteria for Multiple Fields
        Creating Queries with Comparison and Logical Operators
        Performing Calculations in Queries
        Creating a Parameter Query
        Finding Duplicate Fields
        Finding Unmatched Records
        Creating New Tables with a Query
        Adding Records with a Query
        Deleting Records with a Query
        Updating Records with a Query
        Summarizing Values with a Crosstab Query
        Creating SQL-Specific Queries
        Chapter 7.   Simplifying Data Entry with Forms
        Introduction
        Creating Forms
        Working with Form Controls
        Creating a Form Using AutoForm
        Creating a Form Using a Wizard
        Creating a Form in Design View
        Editing an Existing Form
        Adding and Modifying Controls
        Using the Control Wizards
        Creating a Subform
        Editing in Form View
        Entering and Editing Data in a Form
        Using Windows XP Themes in Forms
        Chapter 8.   Creating Reports to Convey Information
        Introduction
        Exploring Different Ways to Create a Report
        Creating a Report Using a Wizard
        Using Sections in Design View
        Working with Controls
        Creating a Report in Design View
        Using Toolbox Buttons and Controls
        Arranging Information
        Creating Mailing Labels
        Setting Properties
        Performing Calculations in Reports
        Grouping Records
        Inserting a Header or Footer
        Assigning a Shortcut Key to a Control
        Checking for Errors in Reports and Forms
        Changing the Page Setup
        Previewing Information
        Printing Information
        Chapter 9.   Improving the Appearance of Forms and Reports
        Introduction
        Formatting a Form or Report
        Adding Lines and Rectangles
        Changing Line or Border Thickness
        Changing Colors
        Applying Special Effects to Controls
        Applying Conditional Formatting
        Aligning and Grouping Controls
        Sharing Information Among Documents
        Copying and Pasting Objects
        Inserting a New Object
        Inserting an Object from a File
        Inserting a Picture
        Inserting Excel Charts and Worksheets
        Inserting a Graph Chart
        Formatting Chart Objects
        Moving and Resizing an Object
        Chapter 10.   Working on the Web
        Introduction
        Integrating Access and the Internet
        Creating a Hyperlink Field
        Inserting a Hyperlink to a File or Web Page
        Linking to an Object in a Database
        Linking to a New Document
        Navigating Hyperlinks
        Working with the Web Toolbar
        Exporting Database Objects to HTML
        Exporting Database Objects to ASP Files
        Holding an Online Meeting
        Creating a Data Access Page Using a Wizard
        Working with a Data Access Page in Design View
        Adding a Theme to a Page
        Grouping a Data Access Page
        Viewing a Data Access Page
        Analyze Pivot Data from the Web
        Chapter 11.   Importing and Exporting Information
        Introduction
        Importing and Linking Data
        Importing or Linking Data from an Access Database
        Importing or Linking Data from an Excel Spreadsheet
        Importing or Linking Data from a Mail Program
        Getting Data from Other Programs
        Importing and Exporting XML Data
        Exporting Data to Other Programs
        Merging Data with Word
        Analyzing Data in Excel
        Chapter 12.   Managing a Database
        Introduction
        Securing a Database
        Creating a Workgroup Information File
        Joining a Workgroup
        Creating User and Group Accounts
        Activating User Logons
        Setting User and Group Permissions
        Setting Object Ownership
        Setting a Database Password
        Encoding a Database
        Locking Database Records
        Replicating a Database
        Backing Up a Database
        Compacting and Repairing a Database
        Splitting a Database
        Documenting a Database
        Analyzing a Database
        Converting Access Databases
        Using Add-Ins
        Creating a Database Switchboard
        Managing a Switchboard
        Creating a Splash Screen
        Setting Access Startup Options
        Chapter 13.   Customizing Access
        Introduction
        Adding and Removing Toolbar Buttons
        Customizing a Toolbar
        Customizing the Menu Bar
        Editing Toolbar Buttons and Menu Entries
        Learning About Macros
        Creating a Macro
        Running and Testing a Macro
        Creating Macro Groups
        Creating Conditional Macros
        Assigning a Macro to a Button
        Assigning a Macro to an Event
        Creating a Message Box
        Controlling Access with your Voice
        Executing Voice Commands
        Dictating Text
        Recognizing Handwriting
        Using Multiple Languages
        Chapter 14.   Enhancing a Database with Programming
        Introduction
        Enhancing a Database with VBA
        Creating a Standard Module
        Understanding Parts of the Visual Basic Editor
        Creating a Sub Procedure
        Writing VBA Commands
        Running a Sub Procedure
        Copying Commands from the Object Browser
        Creating a Custom Function
        Running a Custom Function
        Creating a Class Module for a Form or Report
        Setting Project Properties
        Debugging a Procedure
        Identifying VBA Debugging Tools
        Optimizing Performance with an MDE File
        Chapter 15.   Working Together on Office Documents
        Introduction
        Viewing SharePoint Team Services
        Administering SharePoint Team Services
        Storing Documents in the Library
        Viewing Team Members
        Setting Up Alerts
        Assigning Project Tasks
        Creating an Event
        Creating Contacts
        Holding Web Discussions
        Importing and Exporting Access Data with SharePoint
        Installing Windows 2003 and SharePoint Server 2003
        Microsoft Office Specialist
        About the Microsoft Office Specialist Program
        What Does This Logo Mean?
        Preparing for a Microsoft Office Specialist Exam
        Taking a Microsoft Office Specialist Exam
        Getting More Information
        New! Features
        Microsoft Office Access 2003
        Troubleshooting
        Clip art and objects
        Columns
        Database
        Entering and editing data
        Fields
        Formatting
        Forms
        Help
        Importing and exporting
        Language, voice and handwriting options
        Macros
        Managing
        Menus, toolbars, and task panes
        Microsoft Office Specialist
        Printing
        Queries and reports
        Records
        Reports
        Searching
        SharePoint
        Spelling
        Tables
        Visual Basic (VBA)
        Views
        Web