O'Reilly logo

Computing Fundamentals: Introduction to Computers 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 11

Managing Databases with Access

Learning objectives

  • Understand how a database differs from a spreadsheet
  • Demonstrate how to create databases and tables
  • Create queries
  • Create and explain the benefits of forms and reports

Understanding Access Databases

Creating Databases and Tables

Creating Queries

Creating Forms and Reports

A database is a collection of structured data—that is, data in a consistent format. For example, your address book is a database, as is a catalog of items for sale, because the same facts are stored about each instance. In Chapter 10, “Creating Spreadsheets with Microsoft Excel,” you learned how to store structured data in an Excel table, but in many cases the complexity and size of the database make Excel an ...

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