If you are new to relational databases, please refer to the list of suggested reading. Learning the basics will save you a great deal of time in the long run, and your database applications will run faster and be much more robust.
When extensive changes have been made to an Access database, or you are converting an existing application to Scriptoria, the following guidelines are strongly recommended.
Perform a repair database operation. This can eliminate some rather cryptic errors that can occur when analyzing the database. (Tools | Database Utilities | Repair Database)
Perform an analysis of the database (use the Access “Tools | Analyze | Performance” menu item). Analyze all tables, queries, and forms. Oracle Performance can be greatly improved by creating indexes and relationships suggested by the Performance Analyzer.
ODBC linked tables are not updateable unless they are assigned a unique index or primary key.
Use the Case Sensitivity Assistant (Tools | Migration Tools I Case Sensitivity Assistant) to identify and resolve upper and lower case matching issues (with criteria in Access queries) that may result from the case insensitive (Access) versus case sensitive (Oracle) architecture of Access and Oracle.
Use the High Overhead Queries report to identify queries that may exhibit post-migration performance degradation.