Access is an important member of Office components, its main function is to manage the database and applications. Because of its prevalence and ease of use and the other members are not, so we often feel that Access is not convenient for the operation. For example, in the Access table, to insert a record in the middle is more difficult, and in Word tables and Excel worksheet to do the same operation is easy; another example, when we repeat the table in Access to enter the same or the contents of certain fields in the law, they naturally think of Excel's copy and the AutoFill feature, but Access can do nothing. Obviously, if we can achieve Access with Office components other members of the exchange of data between, these members will be able to Access Service to meet each other, improve work efficiency.
In Word, open the Access query items
If want to Access table or query, converted into Word to read the file format in order to use Word processing, you can use the following three ways:
1. Using the Clipboard
In Access, open the table or query you want to convert items, drag the mouse pointer over the line selector selected records (in the window at the extreme left, when the mouse was placed on the mouse pointer will turn into the direction of the arrow to the right ), you can select a set of records; drag the mouse pointer over the selected field, the field selector (the top of the window when the mouse was placed on the mouse pointer will turn into the direction of the arrow down), can Select a field; when using the mouse click the top left corner of the field selector and the intersection of row selector, the options are all the records or select all the fields. For one of these three options after the toolbar and then click the "Copy" button to copy the selection to the clipboard, as shown in Figure 1. Then re-open Word, click on the toolbar "Paste" button to copy Access table or query items in the table into Word. If you think being copied in. header dark shading effects visual effects, you can select the line, the implementation of the "Format" menu under "Borders and Shading" command, press the "Shading" tab button, select " No fill color. "
2. Exported to RTF files
In Access, open the table or query you want to convert, the implementation of the "File" menu under "Export" command, the "Save as type" is designated as "Rich Text Format". In Word, the implementation of the "File" menu under "Open" command or directly on the toolbar click "Open" button, then pops up the "Open" dialog box, click the "File Type" drop-down list next to , be designated as the "RTF format," save the RTF file to find the previous double-click to open.
3. Directly into the database
In Word, click the "View" menu under "Toolbars" and then "Database" to a select (or the mouse to put Word window menu bar or toolbar, right-click the shortcut menu selected in the pop-up the "database" one). Then, in Word, open Access table or query items, you can click to increase out of the new "database" toolbar "Insert Database" button, then open the "database" dialog box, press the " Get Data "tab button, the file type specified as" MS Access Database ", select the file in a database table or query, and then click" Insert Data "tab button.
Figure 1 replication form
The Excel worksheet into Access
Using Excel to facilitate the automatic import feature and powerful data processing capabilities of the Access to import the data after some processing, then convert it into a Access file, the actual work is undoubtedly the most used methods. Access to import Excel files into text files with the same operation, as long as the order of execution in Access: "File → Get External Data → Import", the "file types" designated as "Microsoft Excel" can. Of course, the clipboard can be convenient to complete (How to import Access table with the same Word table).
Access files and convert between HTML documents
To Access files into HTML documents (hypermedia document), you can perform in Access "File" menu under "Export" command, and "Save as type" is designated as "HTML document." Can use Microsoft FrontPage or other HTML editing software to open the document for editing changes. And import text files and Excel files in the same way, in Access to import HTML documents, as long as the order of execution: "File → Get External Data → Import", the "file types" designated as the "HTML Document" can be.
Word of the table to import the Access of
In Word, Access can be converted freely over the table to edit, and then re-import the Access handle in good form. Two approaches can be used in Access Word form data:
First, the clipboard, which is the form in Word, select the number of rows or number of columns (of course, can also form on the top left corner click "Select" tool, select all the data tables), click on the toolbar "Copy" button, and then open the Access table or query items, press the toolbar "Paste" button to copy the data over the table.
Second, through a text file as a transition into two steps: the first - step, first of all to convert Word table in plain text files; the second step, import the text file in Access. To do that, select the form in Word, followed by the implementation of "form → form → converted into text," and click "Save As" command, and specify the "Save as type" to "plain text." Access in turn in the implementation: "File → Get External Data → Import" in the "Save As" window, select "File Type" to "Text File", shown in Figure 2.
Figure 2 Save As window
Excel Import Access data
You can use three methods to Access table or query entries into Excel: First, use the clipboard, its operating methods and derived the same way as Word forms. The second is to export data to Excel Access file, specific methods of operation are: the Access table or query selected items, the implementation of the "File" menu under "Export" command, the "Save as type" is designated as "Microsoft Excel97-2000", In Excel, you can directly double click the file to open it. The third is to open directly in Excel, is followed by the implementation: "Data → Get External Data → New Database Query (due to a typical installation does not include this feature, so when the first use of the system will be prompted to install)", in the subsequent open "Select Data Source" dialog box, the "new data source" is designated as "MSAccess Datebase" can.
Access files in different data sharing between
If the new table with the table already exists in the same part of the field or part of the record, apparently, by sharing the original data in the table to improve efficiency. And both shared the table with new table in the same database, you can not in the same database. Specific shared three ways:
1. Use shared clipboard
In the Database window, right-click the table or query need to back up in the shortcut menu, select "Copy" command, where the need to copy right click and select "Paste" command, under the need to select "paste only the structure, structure and data , or the data appended to the existing table. " Of course, you can open the table or query you want to convert, directly select the part of the record or part of the field, copy it to the other entries in the table or query.
2. Direct import Access objects
To do step, followed by the implementation: "File → Get External Data → Import", the "file types" designated as "Microsoft Access", such that you might the current database or another database into the object, shown in Figure 3.
Figure 3 into the window
3. Use the link table
Operation of basic Ibid, followed by the implementation: "File → Get External Data → link table", the "file types" designated as the "Microsoft Access", find the corresponding table will be the link in, and above the direct import of the difference is that the link in. table of data synchronization with the original table changes, the import is not. In fact, using the link table, if the "File Types" are designated as "Microsoft Excel, text file or HTML document," each of these files can be imported Access, and import the table data changes with the original data change.