ITE QUESTIONS WITH COMPLETE SOLUTIONS GRADED A+

A computerized database can store millions of telephone numbers. True False - Answer-True A database is an organized collection of information. True False - Answer-True A field's data type determines what kind of information can be stored there. True False - Answer-True All the pet names in a veterinarian's database are stored in a _______ called PetName. worksheet table record field - Answer-field Contact information for all the people taking a class at a school are stored in a ________ called Students. fieldtable record worksheet - Answer-Table 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? Author PageCount Title ProductID - Answer-ProductID Databases are useful only if they are ___________. Accurate Big Expensive Detailed - Answer-Accurate Databases typically store their data in one big table. True False - Answer-False 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 EmployeesInventory Customers - Answer-Vendors In a database, a _____________ is a unit of information about one individual or item. Table Record File Field - Answer-Field In a database, each _________________ contains a collection of related data. Table None of the above Record Field - Answer-Table In a record, each separate piece of data, such as a last name, a first name, or an address, is called a _____________. Record Field File Table - Answer-Field 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? Z to AA to Z Largest to smallest Smallest to largest - Answer-smallest to largest 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? Tables Reports Queries Forms - Answer-Forms Queries in access can be used as a source of records for forms and reports to view, change and analyze data in different ways Both 'a' and 'b' Only 'a' - Answer-Both a and b 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 has been deleted. The table is sorted. The table is filtered. - Answer-The table is filtered This key uniquely identifies each ry key unique key field name key record - Answer-Primary Key What are the columns in a Microsoft Access table called? Rows Fields Columns Records - Answer-Fields What are the different views to display a table? All of the above Design View Datasheet View - Answer-All of the Above What does a filter do? Slow down processing Make more records available Hide records from view Add to the quantity of data - Answer-Hide records from view What does SQL stand for? Status query language System query lingoStated question language Structured query language - Answer-Structured query language What is a query? A question you ask a database A question you ask a table A question you ask a record A question you ask a field - Answer-A question you ask a database