Microsoft Access Exam Questions & Answers Solved 100%

You log into T and your name and address are automatically populated in the checkout screen. This is an example of a(n): - Answer Bound control on a form Which of the following is NOT an Access control that you can add to forms? a. Calculated control b. Section control Correct c. Bound control d. Unbound control - Answer Section control If a Security Warning appears when opening an Access database from a trusted source, click _____. - Answer Enable content An example of a calculated field within a query is: Select one: a. All choices are correct b. Total Order: [Quantity] x [Price] c. Process time: [Delivery Date]-[Order Date] d. Process time: [Shipped Date]-[Order Date] - Answer All choices are correct If you filter based on the active field in your Access datasheet, you are filtering by: - Answer Selection True or False? SQL is a database management programming language. - Answer True Which of the following is NOT a way to create a form? Select one: a. Report view b. Layout view c. Form wizard d. Design view - Answer Report view Which of the following cannot have a space in its name? Select one: a. Field b. File c. Record d. Caption - Answer Field The process of organizing tables and fields into their smallest distinct parts is called _____. - Answer Atomization True or False? Database management software allows users to store, manipulate, and retrieve database information. - Answer True What type of relationship would best describe a grocery store's products and vendors? Select one: a. No choices are correct b. One to one c. Many to many d. One to many - Answer Many to many Which of the following is an example of a flat file database? Select one: a. Team roster in Microsoft Word b. Neither team rosters in Word nor Excel c. Both team rosters in Word and Excel d. Team roster in Excel - Answer Both team rosters in Word and Excel True or False?