Access communicates data easily with other members of the Office

Source: Internet
Author: User
Tags insert access database microsoft frontpage
access| data access is an important member of Office components, whose primary function is the management and application of databases. Because of its popularity and ease of use are less than other members, so people often feel that access is not easy to operate. For example, in an Access table, it's more difficult to insert a record in the middle, and it's easy to do the same thing in a Word table and Excel worksheets; For example, when we repeatedly enter the same or regular field contents in an Access table, The copy and autofill features of Excel are naturally associated, but access is powerless. Clearly, if we can achieve access to data exchange with other members of the Office component, we can make these members available for access, thereby achieving the goal of complementarity and increased productivity.

Open an Access table query item in Word

If you want to convert a table or query in access to a file format that you can read in Word, and use word for processing, you can use the following three ways:

1. Using the Clipboard

In Access, open the table or query item that you want to convert, and drag the mouse pointer over the row selector for the selected record (at the left end of the window, when the mouse pointer is over it becomes an arrow to the right, you can select a set of records; Drag the mouse pointer over the field selector for the selected field (at the top of the window, When the mouse pointer is positioned over it, you can select a group of fields, and when you click at the intersection of the field selector and the row selector in the upper-left corner, you can select All records or select all fields. When you have chosen one of these three scenarios, click the Copy button on the toolbar to copy the selection to the Clipboard, as shown in Figure 1. Then you can copy the table or query item in access to a table in Word by clicking the Paste button on the toolbar. If you think the dark shading table that was copied is affecting the visual effects, you can select the line, perform the Borders and Shading command under the Format menu, press the Shading tab button, and select No fill.

2. Export as RTF file

In Access, open the table or query that you want to convert, execute the Export command under the File menu, and specify save type as Rich Text Format. In Word, execute the Open command under the File menu or press the Open button on the toolbar directly. In the Open dialog box that pops up, click the Drop-down list next to file type to designate it as rich Text format and find the previously saved RTF file double-click to open it.

3. Insert Database directly

In Word, click Toolbars on the View menu, and then select the database item (or right-click on the menu bar or toolbar of the Word window, and select Database in the shortcut menu that pops up). To open an Access table or query item in Word, you can click the Insert Database button on the newly added Database toolbar, and in the Database dialog box that opens later, press the Get Data tab button to specify the file type as "MS Access database". Select a table or query in a database file, and then click the Insert Data Tab button.

Figure 1 Copying a table

Import an Excel worksheet into Access

Using Excel's convenient automatic input function and powerful data processing capabilities to handle the data imported by access, and then convert it into an Access file, is undoubtedly the most used method in actual work. Importing an Excel file in Access is the same as importing a text file, as long as you execute it in Access: "file → get External data → import" and specify "file type" as "Microsoft Excel". Of course, you can do this by using a quick and easy clipboard (the same way you would import a Word table into an Access table).

The Access file and HTML document are converted to each other

To convert an Access file to an HTML document (a hypermedia document), you can perform the Export command under the File menu in Access and specify save type as HTML document. You can use Microsoft FrontPage or other Web page editing software to open the document for editing changes. As with importing text files and Excel file methods, to import HTML documents in Access, you can specify "file type" as "HTML Document" by executing: "file → get External data → import".

Import a table from Word into Access
In Word, you can easily edit the tables that access transforms, and then re-import the processed tables into Access. There are two ways to use the data from a Word table in Access:

One is through the Clipboard by selecting several rows or columns of the table in Word (of course, you can also click the Select tool in the upper-left corner of the table, select all the data in the table, click the Copy button on the toolbar, and then open the table or query item in Access, and then press paste on the toolbar button to copy the table data over.

Second, through the text file as a transition, divided into two steps: first-step, the table in Word to convert to a plain text file; The second step is to import a text file into Access. To do this, select the table in Word, follow the form → convert → form to text, and then click Save As to specify "saving type" as "plain text." In Access, follow: "file → get External data → import", and in the Save As window, select file type as text file, as shown in Figure 2.

Figure 2 Save As window


Import Access data in Excel

There are three ways to import a table or query item in Access into Excel by using the Clipboard in the same way you would export it to a Word table. The second is to export Access data to Excel files by selecting a table or query item in Access, executing the Export command under the File menu, specifying save type as Microsoft excel97-2000, You can open it by double-clicking the file directly in Excel. The third is to open directly in Excel by performing the following sequence: "Data → get External data → create a new database query (because this feature is not included in a typical installation, you will be prompted to install when you first use), and in the Select Data Source dialog box that opens later, specify new data source as MSAccess datebase "can be.

Data sharing between different access files

If you create a new table that is the same as some fields or parts of a table that already exists, it is obvious that you can increase your productivity by sharing data from an existing table. The shared table can be either in the same database as the new table or not in the same database. There are three ways to share the details:

1. Sharing with the Clipboard

In the Database window, right-click the table or query you want to back up, select Copy on the shortcut menu, select Paste when you need to copy, select Paste only structure, structure and data, or append data to existing table as needed. Of course, you can also open a table or query that you want to convert, select a portion of the record or some of the fields directly, and copy it to another table or query item.

2. Import an Access object directly

The specific steps are: "file → get External data → import", and specify "file type" as "Microsoft Access" so that you can import objects from the current database or other databases, as shown in Figure 3.

Figure 3 Import window

3. Using linked tables

Operation of the basic ibid, followed by: "file → get external data → link table, specify" file type "as" Microsoft Access ", find the appropriate table and link it in, and the difference is that the data in the linked table is synchronized with the original table data, but the import does not. In fact, when you use linked tables, if you specify file types as Microsoft Excel, text file, or HTML document, you can also import the files into Access separately, and the data in the imported table changes as the original data changes.



Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.