Learn how to:
· Optimize database design for efficiency
· Create Tables to store data
· Use handy templates and get a head start
· Make queries to extract specific data
· Produce user-friendly Forms for data entry
· Explore basic SQL for advanced queries
· Construct informative Reports quickly
· Import and export data to Excel and Word
· Securely share your well-designed database and reports that’ll impress your colleagues!
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
Mike McGrath gained his extensive knowledge of computer languages while working as a developer contracting to companies around the world. Mike is an established In Easy Steps author with several guides to his credit.