Access Project Book

Paperback
March 2020
9781683920946
More details
  • Publisher
    Mercury Learning & Information
  • ISBN 9781683920946
  • Language English
  • Pages 450 pp.
  • Size 7" x 9"
$49.95
E-Book
March 2020
9781683920953
More details
  • Publisher
    Mercury Learning & Information
  • ISBN 9781683920953
  • Language English
  • Pages 450 pp.
  • Size 7" x 9"
$29.95
Lib E-Book

Library E-Books

We have signed up with three aggregators who resell networkable e-book editions of our titles to academic libraries. These aggregators offer a variety of plans to libraries, such as simultaneous access by multiple library patrons, and access to portions of titles at a fraction of list price under what is commonly referred to as a “patron-driven demand” model.

These editions, priced at par with simultaneous hardcover editions of our titles, are not available direct from Stylus, but only from the following aggregators:

  • Ebook Library, a service of Ebooks Corporation Ltd. of Australia
  • ebrary, based in Palo Alto, a subsidiary of ProQuest
  • EBSCO / netLibrary, Alabama

as well as through the following wholesalers: The Yankee Book Peddler subsidiary of Baker & Taylor, Inc.

March 2020
9781683922469
More details
  • Publisher
    Mercury Learning & Information
  • ISBN 9781683922469
  • Language English
  • Pages 450 pp.
  • Size 7" x 9"
$124.95

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.

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

Julitta Korol

Since 1993, Julitta Korol (Long Island, NY) has published over two dozen computer books on using and programming Microsoft Excel and Microsoft Access. Ms. Korol has completed professional certifications by Microsoft Corporation and the Computing Technology Industry Association (CompTIA).