Question

exam 3 (7 - 10) f24
this worksheet is linked to an access database. update the worksheet data.
autosave
registration - saved
search (alt + q)
table name:
summarize with pivottable
header row
first column
table1
remove duplicates
insert
export
refresh
open in browser
total row
last column
resize table
convert to range
slicer
unlink
banded rows
banded column
properties
tools
external table data
table style options
coursenumber
classcode
days
starttime
endtime
room
lastname
acc - 201
1012
mwf
1/0/1900
1/0/1900
sbs311
eagle
acc - 201
1013
mwf
1/0/1900
1/0/1900
sbs200
eagle
acc - 201
1014
tth
1/0/1900
1/0/1900
sbs252
eagle
acc 201
1015
mwf
1/0/1900
1/0/1900
dons311
eagle
acc - 202
1016
th
1/0/1900
1/0/1900
don252
eagle
acc 202
1017
mwf
1/0/1900
1/0/1900
sbs209
marple
cis - 201
1018
mwf
1/0/1900
1/0/1900
sbs211
marple
cis - 201
1019
mwf
1/0/1900
1/0/1900
don209
marple
cis - 120
1022
mwf
1/0/1900
1/0/1900
sbs311
marple
cis 212
1023
mwf
1/0/1900
1/0/1900
sbs200
marole

Explanation:

To update the worksheet data linked to an Access database in Excel (for this registration - related table):

Step 1: Locate the "Data" tab

In the Excel ribbon, find and click on the "Data" tab. This tab contains the tools needed to work with external data sources like Access databases.

Step 2: Use the "Refresh" option

In the "External Table Data" group (under the "Data" tab), you will see a "Refresh" button (it has an icon that looks like a circular arrow around a document). Click on this "Refresh" button. This action will send a request to the linked Access database and update the Excel table with the most recent data from the database.

If there are any connection issues (e.g., the database file has been moved, renamed, or the connection settings are incorrect), you may need to use the "Properties" option (also in the "External Table Data" group) to check and update the connection details to the Access database before refreshing.

Answer:

To update the worksheet data, click on the "Data" tab in Excel, then in the "External Table Data" group, click the "Refresh" button (with the circular - arrow - document icon) to update the data from the linked Access database. If there are connection issues, use "Properties" to fix the connection to the Access database first, then refresh.