430 likes | 590 Views
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.
E N D
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
Which of the following views is specific to reports? • Design view • Form view • Print Preview • Datasheet view C
Which view allows you to change the structure or format of an object? • Form view • Design view • Print view • Datasheet view B
Which of the following is NOT an Access object? • Reports • Forms • Tables • Graphs D
Which view looks like a spreadsheet? • Design view • Datasheet view • Print Preview • Form view B
The file extension for an Access 2007 database is which of the following? • .htm • .accdb • .mdb • .doc B
The names for categories of information in a datasheet or form are called ____. • records • field names • print preview • tables B
Which of the following buttons allows you to create a new record? A. B. C. D. C
Which of the following symbols indicated that a record is being edited? A. B. C. D. B
Which of the following buttons allows you to move to the last record? A. B. C. D. B
Which of the following toolbar buttons sorts data in descending order? A. B. C. D. C
Which of the following is NOT a way Access can sort various fields? • numerically • chronologically • logically • alphabetically C
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
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
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
Which view must you be in to create a Lookup field? • Print Preview • Design view • Datasheet view • Form view B
The * is used in entering criteria in a query. What is it called? • variable • wildcard • x criteria • random element B
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
A form displays which of the following? • a web page • a report • a record • a document C
Which is NOT an example of a data type? • number • yes/no • records • text C
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
What two things does a database management system include? Database information Tools used to work with the data
In a relational database, how are tables related? They share a common field.
In which object is all of the data in a database stored? table
How is a field represented in a database? As a column
What is the window element on the left side of the database window called? Navigation Pane
TRUE / FALSE:Number formatting options in Access are similar to those used in Excel. TRUE
TRUE / FALSE:When you move your cursor to a new record, the previous record is automatically saved. TRUE
TRUE / FALSE:To change data formatting in a report, you must choose Report View or Print Preview. FALSE
TRUE / FALSE:Datasheet view is not available for Reports. TRUE
TRUE / FALSE:When you open an Access database file, the Navigation Pane appears within the application window. TRUE
TRUE / FALSE:The primary purpose for an Access Report is to effectively present data from the database in a printed format. TRUE
TRUE / FALSE:You cannot manually change row heights and column widths in a table. FALSE
TRUE / FALSE:The Navigation Toolbar is found at the bottom of the object window. TRUE
TRUE / FALSE:Access objects cannot be accessed from the Navigation Pane. FALSE
TRUE / FALSE:Sorting results cannot be seen instantly. FALSE