Chapter 1

Introducing Access

IN THIS CHAPTER

check Understanding how databases work

check Looking at tables, queries, forms, and other database objects

check Creating a database

check Designing the tables, queries, forms, and the other parts of a database

The word database is prone to making most people feel kind of queasy. Can you blame them? Database terminology — record, field, and filter is the worst of the worst. It even puts other computer terminology to shame. Databases intimidate most people. Even brave souls with a considerable amount of experience in Word and Excel shy away from Access, the Office 365 database program. However, Access can be invaluable for storing and organizing customer lists, inventories, addresses, payment histories, donor lists, and volunteer lists.

This chapter introduces databases and the concepts behind databases. It shows you how to create a database and database tables for storing information. The second half of this chapter explains how to design databases. Sorry, but you have to know about database design before you can start fooling with databases. You can’t jump ...

Get Office 365 All-in-One For Dummies, 2nd Edition 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.