To create a linked table, what action must follow after selecting the database?

Study for the CGS Access Test. Leverage flashcards and multiple choice questions, each with hints and explanations. Be prepared for your exam and excel!

When creating a linked table in Access, the essential step that follows the selection of the database is to choose 'Link to the data source'. This action establishes a connection to the external data source, allowing Access to use the data as if it were part of its own database. By linking rather than importing, the data remains in its original location, and any updates made in that source will be reflected in Access. This is particularly beneficial for working with large datasets or when the data is frequently updated, ensuring that users always have access to the latest information without duplication.

The other options do not effectively follow the action of selecting the database for linking purposes. Importing data would involve bringing data into Access and creating a new table, which is not the process for linking. Setting properties for the linked table is typically done after the linking process is established, and clicking 'Finish' directly would not accurately reflect the steps necessary to create the link.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy