© Copyright Ezee Computer Training 2010 Made by Wen Studio You can create a copy of a Microsoft Access table without copying all the data it contains? Here's how: In the Database window under Objects, click Tables. In the Object list on the right side of the Database window, click the table that has the structure or data you want to copy, and then click Copy on the toolbar. Click Paste on the toolbar. Click Structure Only under Paste Options. The new table inherits all the field properties from the original table. You can then alter field names and properties as appropriate. To ensure optimal performance, you should compact and repair your Microsoft Access files regularly. On the Tools menu, point to Database Utilities, and then click Compact and Repair Database. But don't stop there! Let Access do it for you automatically. How? Open the Access database or Access project that you want Access to compact automatically. On the Tools menu, click Options. Click the General tab. Select the Compact on Close check box. How to set a default format for your controls! Just select the control on the Toolbox and then adjust the format using the Formatting toolbar. Every control you place on that form or report will then be formatted that way. You can also set formatting so any new form will inherit your custom format: Create a new form. Select a control in the Toolbox and then make selections using the Formatting toolbar. Save the form with the name Normal. From now on, all controls on every new form will be formatted as in the Normal form. How to drag a Microsoft Access table into Word. Begin with Word running, but minimized to the taskbar. Highlight the table object in the database window and drag the highlighted table down onto the Word button and hold there until Word is restored (without letting up on the mouse button). Once Word is restored, drag the table up into the Word document. See the little square attached to your mouse pointer? That’s your table. Let go of the mouse button and the table will appear. 519-473-1391 eMail