Access for Beginners

by M.L. Humphrey

Overview

Microsoft Access is the perfect tool for when you need to combine different sets of information and generate summary reports from that information. It can also be an excellent choice for when you need to deal with large text entries that don't display well in Microsoft Excel.

This book is written for those who are used to using Microsoft Excel but need that little bit more that Excel can't offer. It will walk you through the basics of working in Microsoft Access with a focus on creating data tables and basic queries.

If you've always wanted to learn Access and weren't quite sure how to get started, this is the book for you.

This book was written using Access 2013, but should work for Access 2007 onward.

Product Details

ISBN-13:	9781950902903
Publisher:	M.L. Humphrey
Publication date:	02/05/2020
Series:	Access Essentials , #1
Pages:	126
Product dimensions:	7.50(w) x 9.25(h) x 0.27(d)

About the Author

M.L. Humphrey is a former stockbroker with a degree in Economics from Stanford and an MBA from Wharton who has spent close to twenty years as a regulator and consultant in the financial services industry.

Table of Contents

Introduction, Basic Terminology, How an Access Database Works, Four Main Components of an Access Database, Access versus Excel and the Dangers of Working in a Database Environment, Absolute Basics, Basics of Navigating Access, Tables: Preparing An External Data Source, Tables: Uploading an Excel File, Tables: Uploading a .CSV File, Tables: Exporting An Existing Table to Excel, Tables: Uploading Data to an Existing Table, Tables: Creating One from Scratch, Field Data Types, Table Views, Amending Records In Tables, Navigating a Table or Query in Access, Queries: Basic Detail Query, Queries: Basic Summary Query, Query Views and the Design View, Relationships, Queries: Queries Using More Than One Table or Query, Summary Results, Sorting, and Filtering in a Table or Query, Queries: Using Simple Criteria to Narrow Down Results, Printing, Forms, and Reports: A Brief Discussion, Where To Get Additional Information, Conclusion, Index