Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010. You'll learn how to build database applications, create Web-based databases, develop macros and VBA tools for Access applications, integrate Access with SharePoint, and much more.
Mark Collins has developed software for more than 25 years, mostly using the Microsoft stack. He has served many roles including development manager, architect, team lead, database administrator, and project manager. He has extensive experience in retail (point-of-sale and inventory) and customer relationship management (CRM) solutions. Mark currently serves as a senior software engineer for a non-profit organization, providing a custom CRM, mail processing, and fulfillment system.
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more.
Using a practical, hands-on approach, this book will take you through all the facets of developing Access-based solutions, such as data modeling, complex form development, and user interface customizations. You'll then deploy your solution to the web and integrate it with other external data sources. This book is full of handy tricks to help you get the most out of what Access has to offer, including its comprehensive set of features and tools for collecting, using, and acting on business data, whether your data is in Access or stored on another platform. You'll also see how to smoothly integrate your applications with SQL Server databases and other Office programs, such as Outlook.
- Introduction
- Defining and Relating Tables
- Using Data Macros
- Designing Queries
- Creating PivotTables
- Standard Forms
- Creating a CheckOut Form
- Creating a Customer Admin Form
- Enhancing Product Administration
- Enhancing the User Experience
- Branding with Themes and Styles
- Reports
- Upsizing
- Distributing the Application
- Publishing to the Web
- Integrating Outlook
- Using External Data
- Miscellaneous Features
- Security
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business.
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more.
Using a practical, hands-on approach, this book will take you through all the facets of developing Access-based solutions, such as data modeling, complex form development, and user interface customizations. You'll then deploy your solution to the web and integrate it with other external data sources. This book is full of handy tricks to help you get the most out of what Access has to offer, including its comprehensive set of features and tools for collecting, using, and acting on business data, whether your data is in Access or stored on another platform. You'll also see how to smoothly integrate your applications with SQL Server databases and other Office programs, such as Outlook.
- Introduction
- Defining and Relating Tables
- Using Data Macros
- Designing Queries
- Creating PivotTables
- Standard Forms
- Creating a CheckOut Form
- Creating a Customer Admin Form
- Enhancing Product Administration
- Enhancing the User Experience
- Branding with Themes and Styles
- Reports
- Upsizing
- Distributing the Application
- Publishing to the Web
- Integrating Outlook
- Using External Data
- Miscellaneous Features
- Security
Über den Autor
Mark Collins has developed software for more than 25 years, mostly using the Microsoft stack. He has served many roles including development manager, architect, team lead, database administrator, and project manager. He has extensive experience in retail (point-of-sale and inventory) and customer relationship management (CRM) solutions. Mark currently serves as a senior software engineer for a non-profit organization, providing a custom CRM, mail processing, and fulfillment system.
Inhaltsverzeichnis
- Introduction
- Defining and Relating Tables
- Using Data Macros
- Designing Queries
- Creating PivotTables
- Standard Forms
- Creating a CheckOut Form
- Creating a Customer Admin Form
- Enhancing Product Administration
- Enhancing the User Experience
- Branding with Themes and Styles
- Reports
- Upsizing
- Distributing the Application
- Publishing to the Web
- Integrating Outlook
- Using External Data
- Miscellaneous Features
- Security
Klappentext
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010 and the many sources of data available to your business. In this book, you'll learn how to build database applications, create Web-based databases, develop macros and Visual Basic for Applications (VBA) tools for Access applications, integrate Access with SharePoint and other business systems, and much more.
Using a practical, hands-on approach, this book will take you through all the facets of developing Access-based solutions, such as data modeling, complex form development, and user interface customizations. You'll then deploy your solution to the web and integrate it with other external data sources. This book is full of handy tricks to help you get the most out of what Access has to offer, including its comprehensive set of features and tools for collecting, using, and acting on business data, whether your data is in Access or stored on another platform. You'll also see how to smoothly integrate your applications with SQL Server databases and other Office programs, such as Outlook.
Pro Access 2010 Development is a fundamental resource for developing business applications that take advantage of the features of Access 2010.
You'll learn how to build database applications, create Web-based databases, develop macros and VBA tools for Access applications, integrate Access with Share.
Point, and much more.
