1 / 43

Access Review

Access Review. BIM. A relational database allows you to do which of the following?. Combine data from different tables Create tables saved in multiple files Merge data from other programs Create data related to a specific subject. A.

emi-mann
Download Presentation

Access Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Access Review BIM

  2. A relational database allows you to do which of the following? • Combine data from different tables • Create tables saved in multiple files • Merge data from other programs • Create data related to a specific subject A

  3. Which of the following views is specific to reports? • Design view • Form view • Print Preview • Datasheet view C

  4. Which view allows you to change the structure or format of an object? • Form view • Design view • Print view • Datasheet view B

  5. Which of the following is NOT an Access object? • Reports • Forms • Tables • Graphs D

  6. Which view looks like a spreadsheet? • Design view • Datasheet view • Print Preview • Form view B

  7. The file extension for an Access 2007 database is which of the following? • .htm • .accdb • .mdb • .doc B

  8. The names for categories of information in a datasheet or form are called ____. • records • field names • print preview • tables B

  9. Which of the following buttons allows you to create a new record? A. B. C. D. C

  10. Which of the following symbols indicated that a record is being edited? A. B. C. D. B

  11. Which of the following buttons allows you to move to the last record? A. B. C. D. B

  12. Which of the following toolbar buttons sorts data in descending order? A. B. C. D. C

  13. Which of the following is NOT a way Access can sort various fields? • numerically • chronologically • logically • alphabetically C

  14. Which method would the most efficient way to move to record 110 in a form? • Type “110” in the navigation bar and press Enter • Click Last Record button on the navigation bar • Click Tab 110 times • Click the Next Record button 110 times A

  15. The small blue box to the left of each record in a datasheet is called a _____. • record selector • field name • pencil icon • field contents A

  16. Which of the following is NOT a possible modification to a query in Design view? • eliminate a range of numbers • sort results • match a field entry • create new tables D

  17. Which view must you be in to create a Lookup field? • Print Preview • Design view • Datasheet view • Form view B

  18. The * is used in entering criteria in a query. What is it called? • variable • wildcard • x criteria • random element B

  19. How are new records saved in a datasheet or form? • they are saved automatically when you move to a new record • click the Office button & save • click on the View button • click the Save button A

  20. A form displays which of the following? • a web page • a report • a record • a document C

  21. Which is NOT an example of a data type? • number • yes/no • records • text C

  22. Which data type allows you to choose from a list of values when entering data in a field? • Text field • Yes/No field • Lookup field • Number field C

  23. What two things does a database management system include? Database information Tools used to work with the data

  24. In a relational database, how are tables related? They share a common field.

  25. In which object is all of the data in a database stored? table

  26. How is a record represented in a database? As a row

  27. How is a field represented in a database? As a column

  28. What is the window element on the left side of the database window called? Navigation Pane

  29. TRUE / FALSE:Number formatting options in Access are similar to those used in Excel. TRUE

  30. TRUE / FALSE:When you move your cursor to a new record, the previous record is automatically saved. TRUE

  31. TRUE / FALSE:You can open a query in Print Preview. FALSE

  32. TRUE / FALSE:All data in database is stored in forms. FALSE

  33. TRUE / FALSE:A Query can be based on multiple tables. TRUE

  34. TRUE / FALSE:To change data formatting in a report, you must choose Report View or Print Preview. FALSE

  35. TRUE / FALSE:Datasheet view is not available for Reports. TRUE

  36. TRUE / FALSE:A database is a spreadsheet program. FALSE

  37. TRUE / FALSE:You cannot edit records in a form. FALSE

  38. TRUE / FALSE:When you open an Access database file, the Navigation Pane appears within the application window. TRUE

  39. TRUE / FALSE:The primary purpose for an Access Report is to effectively present data from the database in a printed format. TRUE

  40. TRUE / FALSE:You cannot manually change row heights and column widths in a table. FALSE

  41. TRUE / FALSE:The Navigation Toolbar is found at the bottom of the object window. TRUE

  42. TRUE / FALSE:Access objects cannot be accessed from the Navigation Pane. FALSE

  43. TRUE / FALSE:Sorting results cannot be seen instantly. FALSE

More Related