Alison Balter's Mastering Microsoft Office Access 2003

by
Edition: 1st
Format: Paperback
Pub. Date: 2003-12-08
Publisher(s): Sams Publishing
List Price: $64.99

Rent Book

Select for Price
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Summary

bull; Alison Balter is a highly-experienced independent trainer and consultant for major corporations including Shell Oil and Prudential Insurance. She is also the author of more than 300 internationally marketed computer training videos. bull; Utilizes Alison's proven, solution-oriented style to teach Access. bull; Includes all the techniques that an Access developer needs to know.

Author Biography

Alison Balter is the president of InfoTechnology Partners, Inc., a computer consulting firm based in the rural Santa Rosa Valley Area, close to Camarillo, California. Alison is a highly experienced independent trainer and consultant specializing in Windows applications training and development. During her 19 years in the computer industry, she has trained and consulted with many corporations and government agencies. Since Alison founded InfoTechnology Partners, Inc. (formerly Marina Consulting Group) in 1990, its client base has expanded to include major corporations and government agencies such as Shell Oil, Accenture, Northrop, the U.S. Drug Enforcement Administration, Prudential Insurance, Transamerica Insurance, Fox Broadcasting, the U.S. Navy, and others.

InfoTechnology Partners, Inc., is a Microsoft Certified Partner, and Alison is a Microsoft Certified Professional. Alison was one of the first professionals in the computer industry to become a Microsoft Certified Solutions Developer.

Alison is a partner in the multimedia training company Blast Through Learning, Inc., and is the author of more than 300 internationally marketed computer training videos and CD-ROMs, including 18 Access 2000 videos, 35 Access 2002 videos, and 15 Access 2003 videos. These videos and CD-ROMs are available by contacting Alison's company, InfoTechnology Partners, Inc. Alison travels throughout North America, giving training seminars on Microsoft Access, Visual Studio .NET, Microsoft SQL Server, Visual Basic, and Visual Basic for Applications. She is also featured in several live satellite television broadcasts for National Technological University.

Alison is a regular contributing columnist for Access/Office/VB Advisor as well as other computer publications. She is also a regular on the Access, Visual Studio .NET, SQL Server, and Visual Basic national speaker circuits. She was one of four speakers on the Visual Basic 4.0 and 5.0 World Tours seminar series co-sponsored by Application Developers Training Company and Microsoft.

Alison is also the author of six other books published by Sams Publishing: Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, and Learning Office Access 2003 in 24 Hours. Alison is a coauthor of three Access books published by Sams Publishing: Essential Access 95, Access 95 Unleashed, and Access 97 Unleashed.

An active participant in many user groups and other organizations, Alison is a past president of the Independent Computer Consultants Association of Los Angeles and of the Los Angeles Clipper Users' Group.

On a personal note, Alison keeps herself busy horseback riding, skiing, ice skating, running, lifting weights, hiking, traveling, and dancing. She most enjoys spending time with her husband, Dan, their daughter, Alexis, their son, Brendan, and their golden retriever, Brandy.

Alison's firm, InfoTechnology Partners, Inc., is available for consulting work and on-site training in Microsoft Access, Visual Studio .NET, Visual Basic, and SQL Server, as well as for Windows Server 2003, Windows 2000, Windows NT, Windows 98, Windows XP, PC networking, and Microsoft Exchange Server. You can contact Alison by email at Alison@InfoTechnologyPartners.com, or visit the InfoTechnology Partners Web site at http://www.InfoTechnologyPartners.com.

Table of Contents

Introduction
THE BASICS OF ACCESS DEVELOPMENT
Access As a Development Tool.Why This Part Is Important
What Types of Applications Can You Develop in Access? Access As a Scalable Product
What Exactly Is a Database? Getting to Know the Database Objects
Object Naming Conventions
Hardware Requirements
How Do I Get Started Developing an Access Application? What's New in Access 2002 and 2003? Practical Examples: The Application Design for a Computer Consulting Firm
Summary
What Every Developer Needs to Know About Databases and Tables.Why This Part Is Important
Creating a New Database
Building a New Table
Selecting the Appropriate Field Type for Your Data
Working with Field Properties
The All-Important Primary Key
Working with the Lookup Feature
Working with Table Properties
Using Indexes to Improve Performance
Access Tables and the Internet
Adding Smart Tags to Your Tables
Creating a Pivot Table or Pivot Chart from a Table
Viewing Object Dependencies
Database Specifications and Limitations
Table Specifications and Limitations
Practical Examples: Designing the Tables Needed for a Computer Consulting
Firm's Time and Billing Application
Summary
Relationships: Your Key to Data Integrity.Why This Part Is Important
Introduction to Relational Database Design
Establishing Relationships in Access
Establishing Referential Integrity
Looking at the Benefits of Relationships
Examining Indexes and Relationships
Practical Examples: Establishing the Relationships Between the Tables Included in the Time and Billing Database
Summary
What Every Developer Needs to Know About Query Basics.Why This Part Is Important
What Is a Query, and When Should You Use One? Everything You Need to Know About Query Basics
Ordering Your Query Result
Refining Your Query with Criteria
Working with Dates in Criteria
Understanding How You Can Update Query Results
Building Queries Based on Multiple Tables
Creating Calculated Fields
Getting Help from the Expression Builder
Summarizing Data with Totals Queries
Excluding Fields from the Output
Nulls and Query Results
Refining Your Queries with Field, Field List, and Query Properties
Building Parameter Queries When You Don't Know the Criteria at Design Time
Adding Smart Tags to Your Queries
Creating a Pivot Table or Pivot Chart from a Query
Query Specifications and Limitations
Practical Examples: Building Queries Needed by the Time and Billing
Application for a Computer Consulting Firm
Summary
What Every Developer Needs to Know About Forms.Why This Part Is Important
Uses of Forms
Anatomy of a Form
Creating a New Form
Working with the Form Design Window
Selecting the Correct Control for the Job
Control Morphing
Conditional Formatting
What Form Properties Are Available, and Why Should You Use Them? What Control Properties Are Available, and Why Should You Use Them? Bound, Unbound, and Calculated Controls
Using Expressions to Enhance Your Forms
The Command Button Wizards: Programming Without Typing
Building Forms Based on More Than One Table
Basing Forms on Queries: The Why and How
Access Forms and the Internet
Adding Smart Tags to Your Forms
Creating a Pivot Table or Pivot Chart from a Form
Form Specifications and Limitations
Practical Examples: Designing Forms for Your Application
Summary
What Every Developer Needs to Know About Reports.Why This Part Is Important
Types of Reports Available
Anatomy of a Report
Creating a New Report
Working with the Report Design Window
Selecting the Correct Control for the Job
What Report Properties Are Available and Why Use Them? What Control Properties Are Available and Why Use Them? Inserting Page Breaks
Unbound, Bound, and Calculated Controls
Using Expressions to Enhance Your Reports
Building Reports Based on More
Table of Contents provided by Publisher. All Rights Reserved.

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.