Flylib.com
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
Year: 2007
Pages: 234
Authors:
John Viescas
,
Jeff Conrad
BUY ON AMAZON
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
Year: 2007
Pages: 234
Authors:
John Viescas
,
Jeff Conrad
BUY ON AMAZON
ADO.NET 3.5 Cookbook (Cookbooks (OReilly))
Connecting to a Secured Access Database
Accessing Deleted Rows in a DataTable
Combining Data in Tables from Heterogeneous Data Sources
Displaying an Image from a Database in a Windows Forms Control
Using ADO.NET Design-Time Features in Classes Without a GUI
CompTIA Project+ Study Guide: Exam PK0-003
Answers to Assessment Test
Schedule Planning
Cost Planning
Other Planning Processes
Project Execution
Building Web Applications with UML (2nd Edition)
Role of Modeling
Document Object Model
Activities
HTML Frames
Glossary Application Tag Libraries
A Practitioners Guide to Software Test Design
Boundary Value Testing
Pairwise Testing
Data Flow Testing
Exploratory Testing
Section IV - Supporting Technologies
Introduction to 80x86 Assembly Language and Computer Architecture
Parts of a Computer System
Branching and Looping
String Operations
The Assembly Process
Floating-Point Arithmetic
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 100 Definitions
Article 328 Medium-Voltage Cable Type MV
Article 394 Concealed Knob-and-Tube Wiring
Article 408: Switchboards and Panelboards
Tables 11(A) and 11(B)
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies