Database Reference
In-Depth Information
TIP
You can open only one database at a time in a single instance of Access. If you
open a second database without first closing the one you are working in, Access
prompts you to save recent changes and then closes the first database before open-
ing the second. To open two databases at the same time, start a second instance of
Access from the Start screen (Windows 8) or the Start menu (Windows 7), and then
open the second database from the Backstage view. You can also double-click the
database file in File Explorer (Windows 8) or Windows Explorer (Windows 7).
9
In the
Navigation
pane, in the
Tables
group, double-click
Suppliers
, verify that the
table exported correctly, and then close the
Exported
database.
Now suppose we need to provide the information in the Suppliers table to someone
who doesn't have Access installed on her computer. Let's export the same table as an
Excel workbook.
10
In the
GardenCompany10
database, open the
Suppliers
table in
Datasheet
view.
Then on the
External Data
tab, in the
Export
group, click the
Excel
button to start
the
Export - Excel Spreadsheet
wizard.
11
On the wizard's first page, click the
Browse
button. Then verify that the
Chapter10
practice file folder is selected in the
File Save
dialog box, and click
Save
.
10
By default, the spreadsheet has the same name as the table it's based on and will be saved
in the Excel Workbook (*.xlsx) format.