SECTION 1
Lesson 1.2: Database Management

   

 

 

In this lesson you will compact the sample database and then create a backup.

1.                   

Open Microsoft Access 2003.

 

 

2.                   

Click Help à Sample Databases à Northwind Sample Database.

 

 

 

3.                   

Click OK to close the splash screen and then close the Main Switchboard.

 

 

4.                   

Click Tools à Database Utilities à Compact and Repair Database.

Wait a moment for the compaction to complete.

 

 

 

5.                   

Once compaction has completed, the database will quickly close and reopen.

Click File à Back Up Database.

 

 

 

6.                   

When the Save Backup As dialogue box appears, click the My Documents button in the My Places toolbar. Double-click the My Database folder and give the backup the name Northwind_Backup:

 

 

Click Save.

 

 

7.                   

The database will once again close and reopen.

Click File à Database Properties.

 

 

8.                   

Click the Summary tab at the top of the Northwind Properties dialogue box and type This is a fully functional database used to experiment with different database objects. in the Comments: box.

 

 

Click OK.

 

 

9.                   

Close Microsoft Access 2003.