This book is a practical introduction to building and managing Access desktop databases. Instead of simply explaining the inner workings of Microsoft Access, you can complete with ease all the required tasks related to the creation, use, and management of an Access database. This book offers a hands-on approach to creating a traditional Access desktop database, emphasizing the importance of splitting the database for optimized multi-user access. The primary project, the Employee Training Database (ETD), serves as the central theme, ensuring readers gain practical experience. This isn’t just a reference book; it’s a journey from the foundational concepts of database design to the intricate details of database management.
FEATURES
TABLE OF CONTENTS
1: Planning and Designing a Database. 2: Creating a Desktop Database. 3: Creating Access Tables. 4: Setting Up Primary Keys, Indexes, and Table Relationships. 5: Populating Access Tables With Data. 6: Creating and Working With Select Queries. 7: Performing Database Operations With Action Queries. 8: Designing and Using Forms.
9: Form Customization. 10: Designing and Using Reports. 11: Report Customization. 12: Compacting, Splitting, and Securing an Access Database. Appendix: Microsoft Access File Formats. Index.
ABOUT THE AUTHOR
Since 1993, Julitta Korol (Long Island, NY) has published two dozen computer books on using and programming Microsoft Excel and Microsoft Access. She has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).
