MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
ISBN: 0735623252
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 234
Pages: 234
Authors: John Viescas, Jeff Conrad
- Table of Contents
- Back Cover
- Microsoft Office Access 2007 Inside Out
- About the CD
- Sample Applications
- System Requirements
- Support Information
- Conventions and Features Used in This Book
- Design Conventions
- Syntax Conventions
- Introduction
- Getting Familiar with Access 2007
- About This Book
- Part 1: Understanding Microsoft Access
- Chapter 1: What Is Microsoft Access?
- What Is a Database?
- Access as an RDBMS
- Access as an Application Development System
- Deciding to Move to Database Software
- Chapter 2: Exploring the New Look of Access 2007
- Getting Started-A New Look for Access
- Understanding Content Security
- Understanding the New Ribbon Feature
- Understanding the New Navigation Pane
- Using the Single-Document vs. Multiple-Document Interface
- Modifying Global Settings via the Access Options Dialog Box
- Chapter 3: Microsoft Office Access 2007 Overview
- Exploring a Desktop Database-Housing Reservations
- Exploring a Project File-Conrad Systems Contacts
- The Many Faces of Access
- Part 2: Building an Access 2007 Desktop Application
- Chapter 4: Creating Your Database and Tables
- Creating a New Database
- Creating Your First Simple Table by Entering Data
- Creating a Table Using a Table Template
- Creating a Table in Design View
- Defining Fields
- Defining a Primary Key
- Defining a Table Validation Rule
- Understanding Other Table Properties
- Defining Relationships
- Adding Indexes
- Setting Table Design Options
- Creating a Default Template for New Databases
- Printing a Table Definition
- Database Limitations
- Chapter 5: Modifying Your Table Design
- Before You Get Started
- Deleting Tables
- Renaming Tables
- Changing Field Names
- Moving Fields
- Inserting Fields
- Copying Fields
- Deleting Fields
- Changing Data Attributes
- Reversing Changes
- Using the Table Analyzer Wizard
- Taking a Look at Lookup Properties
- Working with Multi-Value Lookup Fields
- Changing the Primary Key
- Compacting Your Database
- Chapter 6: Importing and Linking Data
- Creating a Data Source to Link to an ODBC Database
- Importing vs. Linking Database Files
- Importing Data and Databases
- Importing Spreadsheet Data
- Importing Text Files
- Modifying Imported Tables
- Linking Files
- Collecting Data via E-Mail
- Chapter 7: Creating and Working with Simple Queries
- Selecting Data from a Single Table
- Testing Validation Rule Changes
- Working in Query Datasheet View
- Chapter 8: Building Complex Queries
- Selecting Data from Multiple Tables
- Using a Query Wizard
- Summarizing Information with Totals Queries
- Using Query Parameters
- Customizing Query Properties
- Editing and Creating Queries in SQL View
- Limitations on Using Select Queries to Update Data
- Creating PivotTables and PivotCharts from Queries
- Chapter 9: Modifying Data with Action Queries
- Updating Groups of Rows
- Creating a New Table with a Make-Table Query
- Inserting Data from Another Table
- Deleting Groups of Rows
- Troubleshooting Action Queries
- Part 3: Creating Forms and Reports in a Desktop Application
- Chapter 10: Using Forms
- A Tour of Forms
- Moving Around on Forms and Working with Data
- Adding Records and Changing Data
- Searching for and Sorting Data
- Printing Forms
- Chapter 11: Building a Form
- Starting from Scratch-A Simple Input Form
- Working with Quick Create Commands and the Form Wizard
- Simplifying Data Input with a Form
- Chapter 12: Customizing a Form
- Working in Layout View
- Enhancing the Look of a Form
- Setting Control Properties
- Setting Form Properties
- Setting Form and Control Defaults
- Chapter 13: Advanced Form Design
- Basing a Form on a Multiple-Table Query
- Creating and Embedding Subforms
- Displaying Values in an Option Group
- Using Conditional Formatting
- Working with the Tab Control
- Creating Multiple-Page Forms
- Introducing ActiveX Controls-The Calendar Control
- Working with PivotChart Forms
- Chapter 14: Using Reports
- A Tour of Reports
- Printing Reports
- Chapter 15: Constructing a Report
- Using the Report Command
- Using the Report Wizard
- Building a Report in Layout View
- Chapter 16: Advanced Report Design
- Building a Query for a Complex Report
- Creating the Basic Facility Occupancy By Date Report
- Defining the Grouping and Sorting Criteria
- Setting Section and Report Properties
- Using Calculated Values
- Creating and Embedding a Subreport
- Adding a PivotChart to a Report
- Part 4: Automating an Access Application
- Chapter 17: Understanding Event Processing
- Summary of Form and Report Events
- Understanding Event Sequence and Form Editing
- Chapter 18: Automating Your Application with Macros
- Uses of Macros
- The Macro Design Facility-An Overview
- Defining Multiple Actions
- Grouping Macros
- Understanding Conditional Expressions
- Using Embedded Macros
- Using Temporary Variables
- Trapping Errors in Macros
- Understanding Macro Actions That Are Not Trusted
- Making Your Application Come Alive with Macros
- Converting Your Macros to Visual Basic
- Chapter 19: Understanding Visual Basic Fundamentals
- The Visual Basic Development Environment
- Variables and Constants
- Declaring Constants and Variables
- Collections, Objects, Properties, and Methods
- Functions and Subroutines
- Understanding Class Modules
- Controlling the Flow of Statements
- Running Macro Actions and Menu Commands
- Trapping Errors
- Some Complex Visual Basic Examples
- Chapter 20: Automating Your Application with Visual Basic
- Assisting Data Entry
- Validating Complex Data
- Controlling Tabbing on a Multiple-Page Form
- Automating Data Selection
- Linking to Related Data in Another Form or Report
- Automating Complex Tasks
- Automating Reports
- Part 5: Linking Access and the Web
- Understanding Static Web Pages
- Understanding Static Web Pages
- Viewing Static HTML Pages
- Creating Dynamic Web Pages
- Creating Dynamic Web Pages
- Sharing Your Data with SharePoint
- Chapter 22: Working with Windows SharePoint Services
- Working Within the Windows SharePoint Services User Interface
- Using Windows SharePoint Services from Access
- Migrating an Access Database to a Windows SharePoint Services Site
- Chapter 23: Using XML
- Using XML in Microsoft Access
- Modifying Table Templates
- Customizing the Ribbon with XML
- Part 6: After Completing Your Application
- Chapter 24: The Finishing Touches
- Fine-Tuning with Performance Analyzer
- Disabling Layout View
- Defining Switchboard Forms
- Controlling How Your Application Starts and Runs
- Performing a Final Visual Basic Compile
- Chapter 25: Distributing Your Application
- Using Linked Tables in a Desktop Database
- Understanding Runtime Mode
- Creating an Execute-Only Database
- Creating an Application Shortcut
- Encrypting Your Database
- Packaging and Signing Your Database
- Understanding the Access 2007 Developer Extensions and Runtime
- Appendix: Installing Your Software
- Installing the Microsoft Office System
- Installing SQL Server 2005 Express Edition
- Converting from a Previous Release of Access
- Index to Troubleshooting Topics
- Index
- A
- B
- C
- D
- E
- F
- G
- H
- I
- J
- K
- L
- M
- N
- O
- P
- Q
- R
- S
- T
- U
- V
- W
- X
- Y
- Z
- List of Figures
- List of Tables
- List of Examples
- List of Sidebars
- CD Content
MicrosoftВ® Office Access(TM) 2007 Inside Out (Microsoft Office Access Inside Out)
ISBN: 0735623252
EAN: 2147483647
EAN: 2147483647
Year: 2007
Pages: 234
Pages: 234
Authors: John Viescas, Jeff Conrad