Case Based Critical Thinking Questions
The Washington County Public School System has created a database that tracks student performance in all grade levels based on assessments administered every marking period. Administrators and teachers in the school system have access to a secure Intranet for quick access to the school system's policies, forms, curriculum standards, and other information. Zack and Cayla are college interns for the school system, and they have been asked to use the Access database and information gathered from the individual schools to share the assessment data for the first three marking periods of the school year. Answer the following questions using your knowledge of Access tools for sharing and integrating data.
-Each Excel worksheet that was exported contained column names. Those names will appear in the first row of the Import Text Wizard and may be used as the ____ in the Access table.
A)table properties
B)field names
C)field properties
D)data source

Question

Case Based Critical Thinking Questions
The Washington County Public School System has created a database that tracks student performance in all grade levels based on assessments administered every marking period. Administrators and teachers in the school system have access to a secure Intranet for quick access to the school system's policies, forms, curriculum standards, and other information.  Zack and Cayla are college interns for the school system, and they have been asked to use the Access database and information gathered from the individual schools to share the assessment data for the first three marking periods of the school year.  Answer the following questions using your knowledge of Access tools for sharing and integrating data.
-Each Excel worksheet that was exported contained column names.  Those names will appear in the first row of the Import Text Wizard and may be used as the ____ in the Access table.
A)table properties
B)field names
C)field properties
D)data source

Quizplus · Accepted Answer

Field names are the names of the columns in a table in Access. When data is imported from Excel, the column names will appear in the first row of the Import Text Wizard and will be used as the field names in the Access table. Table properties refer to the settings and characteristics of the table as a whole, field properties refer to the settings and characteristics of individual fields within a table, and data source refers to the location or file from which data is being imported.