|
|
|||
|
||||
OverviewThis 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 that contains all 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 the correctly at the outset, later this database can be migrated to another system with fewer issues and fewer objects that need to be redone. 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 (Text, 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. Full Product DetailsAuthor: Julitta KorolPublisher: Mercury Learning & Information Imprint: Mercury Learning & Information ISBN: 9781683920946ISBN 10: 1683920945 Pages: 500 Publication Date: 28 July 2018 Audience: College/higher education , Tertiary & Higher Education Format: Paperback Publisher's Status: Active Availability: To order Stock availability from the supplier is unknown. We will order it for you and ship this item to you once it is received by us. Table of ContentsReviewsAuthor InformationJulitta Korol has published over two dozen computer books on using and programming Microsoft Excel and Microsoft Access. In recent years she has been supporting and developing database processes and Web applications for a major New York City municipal agency. Ms. Korol has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA). Tab Content 6Author Website:Countries AvailableAll regions |