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 ...
Get Computing Fundamentals: Introduction to Computers now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.