Getting started -- Designing Databases -- Creating Tables -- Defining Relationships -- Handling Data -- Making Queries -- Coding Queries -- Producing Forms -- Enhancing Forms -- Supplying Reports -- Sharing Access.
Summary:
Access in easy steps has an easy-to-follow style that will appeal to anyone who wants to get more from the Microsoft Access app. Whether you're using Access in the Office 365 suite or standalone Office product, you can use this guide to learn the key features and get more out of Access. Access in easy steps begins by explaining good database design, then describes how to create related tables in which to store data, and how to import and export data. This book then demonstrates how to extract specific data via a built-in wizard, and by using the Structured Query Language (SQL). You are shown how to produce user-friendly Forms to interact with databases, and how to produce Reports that you can share to impress your friends. Each chapter builds your knowledge of Microsoft Access. Access in easy steps contains separate chapters on the major features of the Access app. There are complete examples that demonstrate each aspect of Access, together with screenshots that illustrate the actual output. This book neatly demonstrates the important functions of Microsoft Access in a clear and concise manner, so you can get going quickly with this popular database application. Illustrated using Access 2019 - Contents: · Getting started · Designing Databases · Creating Tables · Defining Relationships · Handling Data · Making Queries · Coding Queries · Producing Forms · Enhancing Forms · Supplying Reports · Sharing Access.
This resource is supported by the Institute of Museum and Library Services under the provisions of the Library Services and Technology Act as administered by State Library of Iowa.