This book is a practical introduction to building and managing Access desktop databases. Instead of merely explaining Microsoft Access, it helps you complete tasks related to creating, using, and managing a database. The hands-on approach focuses on creating a traditional Access desktop database and emphasizes splitting the database for optimized multi-user access. The primary project, the Employee Training Database (ETD), offers practical, real-world experience.
The book guides you through database creation and management. It starts with planning and designing a database, followed by creating and setting up Access tables. It then covers primary keys, indexes, and table relationships, and populating tables with data. The middle sections include working with queries and designing and customizing forms.
The latter part focuses on designing and using reports and customizing them. It concludes with compacting, splitting, and securing the database for optimized performance and security. These concepts enable efficient database management and enhance multi-user collaboration. This book transitions you from a novice to a proficient user, equipped with practical skills and comprehensive knowledge. Companion files with hands-on examples enrich your learning.
Mercury Learning and Information & Julitta Korol
Access 365 Project Book [EPUB ebook]
Hands-On Database Creation
Access 365 Project Book [EPUB ebook]
Hands-On Database Creation
Купите эту электронную книгу и получите еще одну БЕСПЛАТНО!
язык английский ● Формат EPUB ● страницы 469 ● ISBN 9781836647225 ● Размер файла 23.0 MB ● издатель Packt Publishing ● опубликованный 2024 ● Загружаемые 24 месяцы ● валюта EUR ● Код товара 9556434 ● Защита от копирования без