Access 365 Project Book

Hands-On Database Creation

Paperback
November 2023
9781683920946
More details
  • Publisher
    Mercury Learning and Information
  • Published
    16th November 2023
  • ISBN 9781683920946
  • Language English
  • Pages 446 pp.
  • Size 7" x 9"
$59.99
E-Book

E-books are now distributed via RedShelf or VitalSource

You will choose the vendor in the cart as part of the check out process. These vendors offer a more seamless way to access the ebook, and add some great new features including text-to-voice. You own your ebook for life, it is simply hosted on the vendors website, working much like Kindle and Nook. Click here to see more detailed information on this process.

November 2023
9781683920953
More details
  • Publisher
    Mercury Learning and Information
  • Published
    20th November 2023
  • ISBN 9781683920953
  • Language English
  • Pages 446 pp.
  • Size 7" x 9"
$59.99
Lib E-Book

Library E-Books

We are signed up with aggregators who resell networkable e-book editions of our titles to academic libraries. These editions, priced at par with simultaneous hardcover editions of our titles, are not available direct from Stylus.

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.

November 2023
9781683922469
More details
  • Publisher
    Mercury Learning and Information
  • Published
    20th November 2023
  • ISBN 9781683922469
  • Language English
  • Pages 446 pp.
  • Size 7" x 9"
$155.00

This book is a practical introduction to building and managing Access desktop databases. Instead of simply explaining the inner workings of Microsoft Access, you can complete with ease all the required tasks related to the creation, use, and management of an Access database. This book offers a hands-on approach to creating a traditional Access desktop database, emphasizing the importance of splitting the database for optimized multi-user access. The primary project, the Employee Training Database (ETD), serves as the central theme, ensuring readers gain practical experience. This isn't just a reference book; it's a journey from the foundational concepts of database design to the intricate details of database management.

FEATURES:

  • Uses a step-by-step approach, using hands-on activity examples, to build a traditional Access desktop database
  • Includes a real-world project, the Employee Training Database (ETD), for learn by doing instruction
  • Features comprehensive coverage of Access 365, from basic to advanced
  • Includes companion files with all of the hands-on activity examples

1: Planning and Designing a Database
2: Creating a Desktop Database
3: Creating Access Tables
4: Setting Up Primary Keys, Indexes, and Table Relationships
5: Populating Access Tables With Data
6: Creating and Working With Select Queries
7: Performing Database Operations With Action Queries
8: Designing and Using Forms
9: Form Customization
10: Designing and Using Reports
11: Report Customization
12: Compacting, Splitting, and Securing the Database
Appendix:
Microsoft Access File Formats

Julitta Korol

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

Microsoft Access; desktop databases; data analysis; data science; database design; business; computer science