Microsoft Access is a complete relational database management system that offers powerful tools for creating tables, queries, forms, and reports. Access includes another important tool: Visual Basic for Applications - an easy to learn yet full featured programming language that will take your database design beyond the normal. With VBA you can write code that lets forms and reports respond to events triggered by user or database interactions. With VBA you can programmatically access the data in tables stored either in Access or in ODBC (open database connectivity)-compliant database servers...

Microsoft Access is a complete relational database management system that offers powerful tools for creating tables, queries, forms and reports. This concise guide to building databases begins with a short but practical overview of good database design -beginning with how to model the numerous tables that are required to manage the real world facts about objects, places, or events. Following the design review, the book then steps you through the process of creating tables (including working with data types, validation rules, input masks and formatting), queries (creating criteria expressions,...

Microsoft Access is a complete relational database management system that offers powerful tools for creating tables, queries, forms and reports. Queries constitute an important group of objects in any database, including a Microsoft Access database. This book surveys the types of queries you can create in Access, including Select, Action, and SQL queries. With Select queries the text surveys how to manage the tables and fields that make up a query, how to create criteria, write expressions, use functions, and create totals and Crosstab queries. The book also discusses PivotTable and...

Microsoft Access is a complete relational database management system that offers powerful tools for creating tables, queries, forms, and reports. Forms and reports are the most important objects in an Access database for managing data entry, presentation and summarization. This book covers these important objects in detail, providing the reader with essential information to enable the creation of a wide variety of useful forms and reports. The reader will learn how to create forms for data entry, editing, and review - for data residing in single tables and across multiple tables. A complete...

If you have a need to use Microsoft Word to create documents that go beyond simple letters and reports this book is an essential tool. This task-focused guide shows you how to use Word to create complex documents-these are documents that may contain separate chapters or sections, tables, equations, figures, foot and end notes, headers and footers, landscaped pages, cross-references, tables of contents and indices. Each of these components is fully covered with a focus on the steps necessary to competently master their use. This book is the result of the author's many years of experience using...