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
Compre este e-book e ganhe mais 1 GRÁTIS!
Língua Inglês ● Formato EPUB ● Páginas 469 ● ISBN 9781836647225 ● Tamanho do arquivo 23.0 MB ● Editora Packt Publishing ● Publicado 2024 ● Carregável 24 meses ● Moeda EUR ● ID 9556434 ● Proteção contra cópia sem