Questions and Answers for ITE 152 Modules 9-12 Latest Verified 2024

Questions and Answers for ITE 152 Modules 9-12 Latest Verified 2024 Queries in access can be used - CORRECT ANSWER-to view, change and analyze data in different ways and as a source of records for forms and reports What does a filter do? - CORRECT ANSWER-Hide records from view Databases are useful only if they are - CORRECT ANSWER-accurate Dana is creating a table that will show books for sale on a bookstores website. Which field in the table would best serve as its primary key? - CORRECT ANSWER-ProductID What is a query? - CORRECT ANSWER-A question you ask a database true - CORRECT ANSWER-A field's data type determines what kind of information can be stored there. Which field could serve as the primary key for a list of students in your school? - CORRECT ANSWER-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 _____________. - CORRECT ANSWER-field Which of the following is NOT a part of a database? - CORRECT ANSWER-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? - CORRECT ANSWER-graduated true - CORRECT ANSWER-A database is an organized collection of information. Which of the following is the easiest way add data to a table. - CORRECT ANSWERform In a database, a _____________ is a unit of information about one individual or item. - CORRECT ANSWER-field Which data type would be best suited to a field that lists a product's clearance price? - CORRECT ANSWER-currency What is the purpose of Expression Builder in Access? - CORRECT ANSWER-to create formulas Which of the following is LEAST likely to be a field in a Customers table? - CORRECT ANSWER-employmentdate true - CORRECT ANSWER-A computerized database can store millions of telephone numbers. In a database, each _________________ contains a collection of related data. - CORRECT ANSWER-table What does SQL stand for? - CORRECT ANSWER-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? - CORRECT ANSWER-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? - CORRECT ANSWER-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? - CORRECT ANSWER-vendors This key uniquely identifies each record. - CORRE