Database Overview

Working with databases in Office

Data Source View

Choose View - Data Sources or press Ctrl + Shift + F4 keys to call the data source view from a text document or spreadsheet.

On the left you can see the Data source explorer. If you select a table or query there, you will see the contents of this table or query on the right. At the top margin is the Table Data bar.

Data Sources

Address book as data source

View data source contents

Menu bar of a database file

Forms and Reports

Create new form document, edit form controls, Form Wizard

Entering data versus editing form

Report Wizard

Using and Editing Database Reports

Queries

Create new query or table view, edit query structure

Query Wizard

Enter, edit and copy records

Tables

Create new table, edit table structure, index, relations

Table Wizard

Enter, edit and copy records