• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 12. Maintaining Data Reporting a... > Maintaining Access Databases

Maintaining Access Databases

Many SQL Server 2000 database maintenance tasks have equivalent actions in Access databases. Similar to SQL Server 2000, important Access database maintenance tasks include documenting your databases and backing up your databases. Access also provides tools such as the Table Analyzer Wizard, the Performance Analyzer, and the Compact And Repair command that you can use to optimize your Access database (.mdb) files.

Documenting Access Databases

To document an Access database, on the Tools menu, point to Analyze and then click Documenter. Select the check boxes next to the database objects that you want to document, and then click OK. A series of reports that document the structure of the database’s objects is created. The reports can be printed or saved to file formats such as Excel workbooks, HTML, Rich Text Format, or Access Snapshot Format by clicking Export on the File menu after Access creates the reports.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint