CS 302 2025/2026 Exam Comprehensive
Questions and Verified Answers |
Accurate Solutions | Get it 100%
Correct!! | Already Graded A+
The ____ key is the linking field on the "many" side of the relationship. -
🧠ANSWER ✔✔foreign
Database templates create tables and queries, but not forms and reports. -
🧠ANSWER ✔✔false
Which of the following templates lets you create a database from scratch? -
🧠ANSWER ✔✔blank desktop database
besides reducing file size, what other benefits does compacting an Access
database provide? - 🧠ANSWER ✔✔repairing the database
to rename a field in Table Datasheet view, you change the text in the
_____ - 🧠ANSWER ✔✔column heading
Which data type stores only one of two values? - 🧠ANSWER ✔✔yes/no
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
,a relational database can best be described as a collection of related ____
designed to minimize redundant data. - 🧠ANSWER ✔✔tables
to navigate a record in a table, switch to Table Design View - 🧠ANSWER
✔✔false
in Form Design view, you can make changes while displaying the data -
🧠ANSWER ✔✔false
to add a field list to the upper pane in Query Design view, drag a table from
the Navigation Pane - 🧠ANSWER ✔✔true
what are you doing when you enter data into a subdatasheet? - 🧠ANSWER
✔✔you are entering records in the related table
to back up a database, you use the ______ command - 🧠ANSWER
✔✔back up database
to add, delete, or change fields in a query, you use the Query Design view.
- 🧠ANSWER ✔✔true
tables, queries, and forms are examples of Access - 🧠ANSWER ✔✔objects
sorting a table data sheet temporarily displays only those records that
match given criteria - 🧠ANSWER ✔✔false
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, when using the Report Wizard, you can click the back button to review
previous dialog boxes. - 🧠ANSWER ✔✔true
to link the data from one table to another in Access relational database,
a(n) _______ must be common to each table - 🧠ANSWER ✔✔field
what is the most efficient way to navigate to the last record in a table
containing 100 records? - 🧠ANSWER ✔✔use the Last Record button on the
navigation bar
suppose you rename a field in Table Design view. what must you do before
you can view the data in the table? - 🧠ANSWER ✔✔save the table
to add a field list to the upper pane in Query Design view, drag a table from
the Navigation Pane. - 🧠ANSWER ✔✔true
in an employee table, what is the appropriate data type for a field that
shows the hiring date? - 🧠ANSWER ✔✔date/time
to apply the last filter you selected to a data sheet, you click the _________
button - 🧠ANSWER ✔✔toggle filter
using "CA" as the criterion in a Short Text field is the same thing as using
"ca" or Ca" - 🧠ANSWER ✔✔true
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
Questions and Verified Answers |
Accurate Solutions | Get it 100%
Correct!! | Already Graded A+
The ____ key is the linking field on the "many" side of the relationship. -
🧠ANSWER ✔✔foreign
Database templates create tables and queries, but not forms and reports. -
🧠ANSWER ✔✔false
Which of the following templates lets you create a database from scratch? -
🧠ANSWER ✔✔blank desktop database
besides reducing file size, what other benefits does compacting an Access
database provide? - 🧠ANSWER ✔✔repairing the database
to rename a field in Table Datasheet view, you change the text in the
_____ - 🧠ANSWER ✔✔column heading
Which data type stores only one of two values? - 🧠ANSWER ✔✔yes/no
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
,a relational database can best be described as a collection of related ____
designed to minimize redundant data. - 🧠ANSWER ✔✔tables
to navigate a record in a table, switch to Table Design View - 🧠ANSWER
✔✔false
in Form Design view, you can make changes while displaying the data -
🧠ANSWER ✔✔false
to add a field list to the upper pane in Query Design view, drag a table from
the Navigation Pane - 🧠ANSWER ✔✔true
what are you doing when you enter data into a subdatasheet? - 🧠ANSWER
✔✔you are entering records in the related table
to back up a database, you use the ______ command - 🧠ANSWER
✔✔back up database
to add, delete, or change fields in a query, you use the Query Design view.
- 🧠ANSWER ✔✔true
tables, queries, and forms are examples of Access - 🧠ANSWER ✔✔objects
sorting a table data sheet temporarily displays only those records that
match given criteria - 🧠ANSWER ✔✔false
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, when using the Report Wizard, you can click the back button to review
previous dialog boxes. - 🧠ANSWER ✔✔true
to link the data from one table to another in Access relational database,
a(n) _______ must be common to each table - 🧠ANSWER ✔✔field
what is the most efficient way to navigate to the last record in a table
containing 100 records? - 🧠ANSWER ✔✔use the Last Record button on the
navigation bar
suppose you rename a field in Table Design view. what must you do before
you can view the data in the table? - 🧠ANSWER ✔✔save the table
to add a field list to the upper pane in Query Design view, drag a table from
the Navigation Pane. - 🧠ANSWER ✔✔true
in an employee table, what is the appropriate data type for a field that
shows the hiring date? - 🧠ANSWER ✔✔date/time
to apply the last filter you selected to a data sheet, you click the _________
button - 🧠ANSWER ✔✔toggle filter
using "CA" as the criterion in a Short Text field is the same thing as using
"ca" or Ca" - 🧠ANSWER ✔✔true
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
