2024 ITE 152 FINAL EXAM
What is a query?
-A question you ask a table
-A question you ask a record
-A question you ask a database
-A question you ask
... [Show More] a field - ANSWER-A question you ask a database
A computerized database can store millions of telephone numbers.
-True
-False - ANSWER-True
Which data type would be best suited to a field that lists customer email addresses?
-Hyperlink
-AutoNumber
-Date/Time
-Number - ANSWER-Hyperlink
Databases typically store their data in one big table.
-True
-False - ANSWER-False
All the pet names in a veterinarian's database are stored in a called PetName.
-record
-table
-worksheet
-field - ANSWER-Field
Malisa is designing a database for a doctor's office where receptionists, office managers, and other office staff will need to manage patient data. Which database object should Malisa create to make it easy for these non-technical users to add patient records?
-Forms
-Queries
-Reports
-Tables - ANSWER-Forms
Queries in access can be used
-Both 'a' and 'b'
-Only 'a'
-as a source of records for forms and reports
-to view, change and analyze data in different ways - ANSWER-Both 'a' and 'b'
What does a filter do?
-Make more records available
-Hide records from view
-Slow down processing
-Add to the quantity of data - ANSWER-Hide records from view
A field's data type determines what kind of information can be stored there.
-True
-False - ANSWER-
Which field could serve as the primary key for a list of students in your school?
-Birth date
-Phone number
-Full name
-Student ID number - ANSWER-
Dana is creating a table that will show books for sale on a bookstore's website. Which field in the table would best serve as its primary key?
-PageCount
-Title
-ProductID
-Author - ANSWER-ProductID
Sawyer is looking at a table of students in his class, but it seems like the list is way too short. What is the most likely problem?
-The table is missing a primary key.
-The table is sorted.
-The table is filtered.
-The table has been deleted. - ANSWER-The table is filtered. [Show Less]