Access 365 Project Book: Hands-On Database Creation

by Julitta Korol

Overview

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.

Product Details

ISBN-13:	9781683920946
Publisher:	Mercury Learning and Information
Publication date:	11/16/2023
Pages:	446
Product dimensions:	7.00(w) x 9.00(h) x (d)

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).

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 the Database
Appendix:
Microsoft Access File Formats