Alison Balter's Mastering Microsoft Office Access 2003
, by Balter, Alison- ISBN: 9780672325502 | 0672325500
- Cover: Paperback
- Copyright: 12/8/2003
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.
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. |
The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.
The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.