Название: Access 365 Project Book : Hands-On Database Creation
Автор: Julitta Korol
Издательство: Mercury Learning and Information
Год: 2024
Страниц: 469
Язык: английский
Формат: pdf (true)
Размер: 33.9 MB

This is a project book that guides you through the process of building a traditional Access desktop database that uses one Access database as the front-end (queries, reports, and forms) and another Access database to contain the tables and data. By separating the data from the rest of the database, the Access database can be easily shared by multiple users over a network. When you build a database correctly at the outset, later this database can be migrated to another system with fewer issues and fewer objects that need to be redone.

Microsoft Access has been the top database management solution for individuals and businesses for over two decades. Many of today’s database systems started as small Access databases or were ported from Microsoft Excel spreadsheets. With Microsoft’s commitment to continuing the development of the product, Access keeps getting better with each new update. Across all types and sizes of organizations, people continue to utilize Access to collect, track, and analyze data from multiple sources and build useful forms and reports. Non-devel-opers are creating various Access databases because with Access they can quickly move forward and get their job done without requiring much support from the IT (Information Technology) department.

Access 365 Project Book: Hands-On Database Creation is a hands-on database project that guides you through the process of building a traditional Access desktop database that is later split into two files: a back-end database that contains tables with data, and a front-end database that contains forms, reports, queries, macros, and code modules. By separating the data from the rest of the database, the Access database can be easily shared by multiple users over a network. When you build a so-called “split database,” you can provide a faster experience to your database users, and later the database can be migrated to another database system with fewer issues and fewer objects that need to be redone.

In this book, instead of working through some random examples, you will walk through a series of steps that will teach you the essential skills you need to acquire to develop a desktop database from beginning to end. The focus of this book is the creation of the Employee Training Database (ETD) database. If you are looking for a “tell it all” Access reference, this is not a book for you. This book is not meant to provide a complete guide to all Access features because no project requires the use of all the capabilities of a particular software. There are numerous books on the market that will give you an in-depth look into Microsoft Access, but they do not walk you through a complete project of building an Access database from beginning to end.

Features:
-Understand the concepts of normalization
-Build tables and links to other data sources and understand table relationships
-Connect and work with data stored in other formats (d104, Word, Excel, Outlook, and PowerPoint)
-Retrieve data with DAO, ADO, and DLookup statements
-Learn how to process text files for import and export
-Create expressions, queries, and SQL statements
-Build bound and unbound forms and reports and write code to preview and print
-Incorporate macros in your database
-Work with attachments and image files
-Learn how to display and query your Access data in the Internet browser
-Secure your database for multi-user access
-Compact your database to prevent corruption resulting in data loss