Access 365 Project Book: Hands-On Database Creation
Author: Julitta Korol (Author)
Publisher finelybook 出版社: Mercury Learning and Information
Publication Date 出版日期: 2019-06-15
Language 语言: English
Print Length 页数: 446 pages
ISBN-10: 1683920945
ISBN-13: 9781683920946
Book Description
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:
- Uses a step-by-step approach, using hands-on activity examples, to build a traditional Access desktop database
- Includes a real-world project, the Employee Training Database (ETD), for learn by doing instruction
- Features comprehensive coverage of Access 365, from basic to advanced
- Includes companion files with all of the hands-on activity examples
About the Author
Since 1993, Julitta Korol 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
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
相关推荐
Edge AI for Industry 5.0 and Healthcare 5.0 Applications- OCP Oracle Certified Professional Java SE 21 Developer (Exam 1Z0-830) Java SE 17 Developer (Exam 1Z0-829) Programmer’s Guide
- Docker Deep Dive: Zero to Docker in a single book! 2025 Edition
- Getting Started with Docker, 2025 Edition
- Ninety-Nine Lessons in Critical Thinking
- 5G New Radio in Bullets
