ERP / MRP Software        
       
 

 

 

 
  Question: How can I view or edit the tables in the database?

Answer: All of the database objects can be viewed using the Microsoft Access® database window. The database window contains a listing of all the database objects including tables, queries, forms, reports, data access pages, macros, and modules. If the database window is not currently visible, it can be unhidden by selecting Admin. > View > Unhide Database Window from the main menu. Conversely, the database window can be hidden by selecting Admin. > View > Hide Database Window from the main menu.

To view a specific table, click Tables in the database window Object list to display all of the tables in the database. You can then click the Open button or double-click the table to open it in datasheet view. The table can be reviewed or edited directly in datasheet view.

          The database window must be visible to perform many routine database management functions such as linking tables and importing objects. Linked tables are simply references to tables that actually reside in another database. The data in a linked table can be viewed, but any table maintenance such as adding fields or changing field sizes must be performed in the back-end database where they reside.

 

 

 

 
Back to FAQ
 
   
Copyright © 2002-2008 Manufacturing Advisors, LLC dba Catalyst Manufacturing.
All rights reserved.

Catalyst Manufacturing® is a registered trademark and Catalyst MFG™ is a trademark of Manufacturing Advisors, LLC. "Accelerate the way you do business" is a service mark of Manufacturing Advisors, LLC.

To navigate this web site, please use the navigation bar or refer to the site map.

Questions or problems regarding this web site should be directed to admin@mfgcatalyst.com.
Last modified: 02/05/08.