| Open Access 2003 Databases |
| |
| You could convert Access databases from previous versions. |
| |
| 1) Open Access2003DB.mdb. |
| |
| 2) Select the CONVERT option menu from the main icon. |
| |
  |
| Illustration 1: Select the Access icon and the CONVERT menu. |
| |
| 3) Set the new file name and location. |
| |
 |
| Illustration 2: Set the file name and location. Click here to view larger image. |
| |
| 4) Press the SAVE button. |
| |
| 5) A result message will be displayed. |
| |
 |
| Illustration 3: File conversion result message. Click here to view larger image. |
| |
| Database Documenter |
| |
| You could document your Access databases. |
| |
| 6) Select the Database Tools from the Options Tape. Select the Database Documenter command. |
| |
 |
| Illustration 4: Database documenter command. Click here to view larger image. |
| |
| 7) Select the objects to be documented. |
| |
 |
| Illustration 5: Available objects to document. |
| |
| 8) Press the Options button. |
| |
 |
| Illustration 6: Configure advanced options. Click here to view larger image. |
| |
| 9) Press the OK button to run the report. |
| |
 |
| Illustration 7: database objects report. Click here to view larger image. |
| |
| 10) Press the Word button to export the report to Word application. |
| |
 |
| Illustration 8: Word export option. |
| |
| 11) Press the Word button to export the report to Word application. |
| |
| SQL Server Upload |
| |
| You could upload your Access databases to SQL Server. |
| |
| 12) Select the Database Tools from the Options Tape. Select the SQL Server command. |
| |
 |
| Illustration 9: Migrate to SQL Server. Click here to view larger image. |
| |
| 13) Select the Create new database from the Upsizing Wizard. Press the NEXT button. |
| |
 |
| Illustration 10: Migrate to SQL Server. |
| |
| 14) Configure SQL server options and database name. Press the NEXT button. |
| |
 |
| Illustration 11: Migrate to SQL Server. |
| |
| The new SQL Sever database will be created and data will be moved. |
| |
| Analyze performance |
| |
| You could analyze your Access databases performance. |
| |
| 15) Select the Database Tools from the Options Tape. Select the Analyze Performance command. |
| |
 |
| Illustration 12: Analyze performance command. Click here to view larger image. |
| |
| 16) Select the objects to be analyzed. Press the OK button. |
| |
 |
| Illustration 13: Select the target object. Click here to view larger image. |
| |
| 17) You will receive a Performance Analyzer message. |
| |
 |
| Illustration 14: Suggestion result. |
| |
| Analyze table |
| |
| You could analyze your Access databases tables |
| |
| 18) Select the Database Tools from the Options Tape. Select the Analyze table command. |
| |
 |
| Illustration 15: Analyze table command. Click here to view larger image. |
| |
| 19) The Table Analyzer Wizard will appear. Press the NEXT button. |
| |
 |
| Illustration 16: Analyze table command. |
| |
| 20) The Table Analyzer Wizard will show how it will solve the problem. |
| |
 |
| Illustration 17: How the problem will be solved. Press the NEXT button. |
| |
| 21) Select the table to analyze. |
| |
 |
| Illustration 18: Select the Files table. Press the NEXT button. |
| |
| 22) You could let Access to decide how to solve the issues or take your own actions. |
| |
 |
| Illustration 19: Select the automatic option and press NEXT button. |
| |
| 23) As you can see below, the wizard has detected redundancy information in the directory field. That is, the same directory is repeated along several fields. The wizard proposes a new table, their fields and keys. You will accept the proposed changes. Press the NEXT button. |
| |
 |
| Illustration 20: New table proposed by the wizard. |
| |
| 24) As you can see below, the wizard has detected redundancy information in the directory field. That is, the same directory is repeated along several fields. The wizard proposes a new table, their fields and keys. You will accept the proposed changes. Press the RENAME TABLE button. |
| |
| 25) Rename tables as follows: Table1 as Content and Table2 as Directories. Then press the NEXT button. |
| |
 |
| Illustration 21: Rename the tables that compose the schema. |
| |
| 26) Renamed tables would be as shown in below figure. |
| |
 |
| Illustration 22: Renamed tables. |
| |
| 27) Create the primary key by clicking the Primary key button. Press the NEXT button. |
| |
 |
| Illustration 23: Primary Key acceptance. |
| |
| 28) Correct typographical errors on Directories table content. Press the NEXT button. |
| |
 |
| Illustration 24: Field content correction. |
| |
| 29) Once finished this step, you could set the query creation. This option allows creating a query that looks like the original table. Set this option to No. Press the FINISH button. |
| |
 |
| Illustration 25: Query Creation screen. |
| |
| 30) As you can see, the table Directories has a lookup to the files table. For each record in Directories table, you will see the files that are stored in that directory. |
| |
 |
| Illustration 26: Table Directories content with a lookup over the Files table in the FileDirectory field. Click here to view larger image. |