Access is Microsoft's new Windows database which provides an object-oriented method for writing macros and creating database applications. For serious large-scale databases, users need to be familiar with Access' full programming language - Access BASIC. Access has facilities for importing dBASE, Paradox and other database files. Focusing on the insights and skills needed to get the most from Access, this book follows the "INSIDER" series format. Of particular importance are the chapters on database design, the critical early planning in order to build a database that will perform efficiently. Also given extensive treatment is the issue of porting records from existing databases without losing or scrambling data.
Reihe
Sprache
Verlagsort
Verlagsgruppe
Zielgruppe
Illustrationen
Maße
Höhe: 234 mm
Breite: 187 mm
Gewicht
ISBN-13
978-0-471-30430-2 (9780471304302)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
DESIGNING AND CREATING DATABASES. Good Database Design. Migrating from Other Programs. Maintaining Access Databases. FORMS AND DATASHEET SHORTCUTS. Data Entry Shortcuts. Formatting Data with Custom Formats. Making Better-Looking Forms. Streamlining Data Entry with Forms. Making Dynamic Forms. POWERFUL QUERY TECHNIQUES. Selecting and Relating Records with Queries. Summarizing Data with Total and Crosstab Queries. DESIGNING EFFECTIVE REPORTS. Report Tips. Printing Reports and Forms. Printing Subtotals, Totals, and Other Calculations. Sample Report Formats. CUSTOMIZING ACCESS. Customing Access. Access Macro Tips. An Introduction to Access Basic. Appendix. Index.
