Microsoft Office 2011 for Mac: Visual QuickStart Guide

15. Database Techniques

In This Chapter

Creating a Database 266

Using a Form for Data Entry 267

Database Operations 268

Working with External Databases 271

Office 2011 doesn’t include a database application. However, unless you work with extremely large data sets or need a complex or relational database, Excel can probably provide all the database power you’ll need.

In Excel, you enter data in rows. Each row is a record (one complete set of information). Each column is a field that contains one type of information for the record, such as a last name, Social Security number, or salary, for example. It isn’t necessary to define a data array as a database. In Excel’s eyes, any rectangular array of data can be treated as a database.

Rather ...