Book
Licensed
Unlicensed
Requires Authentication
Access 365 Project Book
Hands-On Database Creation
-
Julitta Korol
Language:
English
Published/Copyright:
2023
About this book
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.
Author / Editor information
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).
Topics
-
Download PDFPublicly Available
Frontmatter
i -
Download PDFPublicly Available
Contents
v -
Download PDFPublicly Available
Introduction
xiii -
Download PDFPublicly Available
Acknowledgments
xxi - Part I Plan, Design, and Create a Database
-
Download PDFRequires Authentication UnlicensedLicensed
Chapter 1 Planning and Designing a Database
1 -
Download PDFRequires Authentication UnlicensedLicensed
Chapter 2 Creating a Desktop Database
19 - Part II Create and Work with Database Tables
-
Download PDFRequires Authentication UnlicensedLicensed
Chapter 3 Creating Access Tables
55 -
Download PDFRequires Authentication UnlicensedLicensed
Chapter 4 Setting up Primary Keys, Indexes, and Table Relationships
79 -
Download PDFRequires Authentication UnlicensedLicensed
Chapter 5 Populating Access Tables With Data
103 - Part III Create and Work with Queries
-
Download PDFRequires Authentication UnlicensedLicensed
Chapter 6 Creating and Working With Select Queries
151 -
Download PDFRequires Authentication UnlicensedLicensed
Chapter 7 Performing Database Operations With Action Queries
209 - Part IV Create and Work with Forms
-
Download PDFRequires Authentication UnlicensedLicensed
Chapter 8 Designing and Using Forms
231 -
Download PDFRequires Authentication UnlicensedLicensed
Chapter 9 Form Customization
285 - Part V Create and Work with Reports
-
Download PDFRequires Authentication UnlicensedLicensed
Chapter 10 Designing and Using Reports
313 -
Download PDFRequires Authentication UnlicensedLicensed
Chapter 11 Report Customization
343 - Part VI Compact, Split and Secure the Database
-
Download PDFRequires Authentication UnlicensedLicensed
Chapter 12 Compacting, Splitting, and Securing an Access Database
407 -
Download PDFRequires Authentication UnlicensedLicensed
Appendix: Microsoft Access File Formats
435 -
Download PDFRequires Authentication UnlicensedLicensed
Index
439
Publishing information
Pages and Images/Illustrations in book
eBook published on:
November 15, 2023
eBook ISBN:
9781683922469
Paperback published on:
December 11, 2023
Paperback ISBN:
9781683920946
Pages and Images/Illustrations in book
Main content:
450
Keywords for this book
Microsoft Access; desktop databases; data analysis; data science; database design; business; computer science
Safety & product resources
-
Manufacturer information:
Walter de Gruyter GmbH
Genthiner Straße 13
10785 Berlin
productsafety@degruyterbrill.com