Not anymore: Excel 2013’s table tools include features that make it easy to link charts and cells, perform searches, and create dynamically updated reports, just like—yes—a relational database.

Excel possesses formidable database powers. Creating a relational database starts with a Master table that links it to subordinates, called (awkwardly) Slave, Child, or Detail tables. Before we ...

DGET is a straightforward lookup function designed to retrieve a single value from a column in a table or database. It's ...

When creating a relationship between tables, the tables must be related. Now we are going to name both tables. Select the table you want to give a name to and click the Table Design tab.

You’re ready to create a table. Creating a table. I’ve created a database called SERVERS, that will be listed in the SCHEMAS pane. Expand that listing, right-click the Tables entry, and select ...

How to create Tables with Table Designer in Access You can view an Access database as a collection of related tables. A table in Access is a subject-based list of rows and columns.