Название: 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
Скачать Access 365 Project Book : Hands-On Database Creation
Access For Dummies Название: Access For Dummies Автор: Laurie Ann Ulrich and Ken Cook Издательство: For Dummies Год: 2022 Формат: True PDF Страниц: 435 Размер: 34,3 Mb...
Access 2010 For Dummies, 1 edition Название: Access 2010 For Dummies Автор: Laurie A. Ulrich, Ken Cook Издательство: For Dummies Год: 2010 Формат: PDF Страниц: 464 Для сайта:...
Access 2016 For Dummies Название: Access 2016 For Dummies Автор: Laurie Ulrich Fuller, Ken Cook Издательство: John Wiley & Sons Год: 2016 Формат: PDF Страниц: 459...
Access 2016 Bible Название: Access 2016 Bible Автор: Michael Alexander, Richard Kusleika Издательство: W?ley Год: 2015 Формат: PDF Размер: 64 Мб Язык: английский ...
Информация
Посетители, находящиеся в группе Гости, не могут оставлять комментарии к данной публикации.
Навигация
Вход на сайт
Реклама
Access 365 Project Book: Hands-On Database Creation 
