ITE 152 Module 9 (Chapter 13) Quiz with Complete Answers

ITE 152 Module 9 (Chapter 13) Quiz with Complete Answers Queries in access can be used To view, change and analyze data in different ways and as a source of records for forms and reports. What does a filter do? Hide records from view Databases are useful only if they are... Accurate Dana is creating a table that will show books for sale on bookstores website. Which field in the table would best serve as its primary key? Product ID What is a query? A question you ask a database A field's data type determines what kind of information can be stored there. (T/F) True Which field could serve as the primary key for a list of students in your school? Student ID number In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________. Field Which of the following is NOT a part of a database? Worksheets Xavier is designing a Students table that will continue to track students even after they have completed their programs. Which of the following fields would work best with the Yes/No data type? Graduated A database is an organized collection of information (T/F) True Which of the following is the easiest way to add data to a table? Form In a database a _________ is a unit of information about one individual or item. Field Which data type would be best suited to a field that lists a product's clearance price? Currency What is the purpose of Expression Builder in Access? To create formulas Which of the following is LEAST likely to be a field in a Customers table? Employment date A computerized database can store millions of telephone numbers. (T/F) True In a database, each ________ contains a collection of related data. Table What does SQL stand for? Structured Query Language Kian needs to sort a list of patients by birthdate to show the oldest patients first. What sort order on the birthdate field will give him this result? Smallest to largest 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 filtered Ibraheem works for a music store. Which of the following tables will give him the company contact information he needs to place a custom order for a guitar? Vendors This key uniquely identifies each record. Primary key What are the columns in a Microsoft Access table called? Fields Contact information for all the people taking a class at a school are stored in a ________ called Students. Table 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 Which of the following is a way to sort data? Numerically, alphabetically, and chronologically Databases typically store their data in one big table. (T/F) True All the pet names in a veterinarian's database are stored in a _______ called PetName. Field What are the different views to display a table? Design view and datasheet view