O'Reilly logo

Digital Literacy For Dummies by Faithe Wempen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 13

Storing and Retrieving Data with Microsoft Access

In This Chapter

arrow Discovering the basic concepts of a database

arrow Creating a database

arrow Entering and editing database records

arrow Creating queries

arrow Creating reports

A database is a collection of structured data — that is, data in a consistent format. For example, an address book is a database, as is a catalog of items for sale, because the same facts are stored about each instance.

You can store structured data in Excel, but in many cases, the size and complexity of a database make Excel an impractical tool for it. Microsoft Access is a better choice when you have multiple tables of data and when you need to sort and manipulate that data in several different ways.

In this chapter, you discover some basics about databases, and you find out how to use Microsoft Access to create and store a simple database.

Understanding Database and Access Basics

Access is a popular application for creating and managing small to medium databases. This ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required