Access Chapter 1 – Creating and Using a Database true/false



Download 1.57 Mb.
Page1/4
Date22.02.2021
Size1.57 Mb.
  1   2   3   4

Access Chapter 1 – Creating and Using a Database

TRUE/FALSE

1. In Access, the columns in a table are called records.

ANS: F PTS: 1 REF: AC 4

2. A unique identifier also is called a primary key.

ANS: T PTS: 1 REF: AC 4

3. Replication is the storing of a piece of data in more than one place.

ANS: F PTS: 1 REF: AC 5

4. Database Design Language (DBDL) is a programming language.

ANS: F PTS: 1 REF: AC 8

5. In Access, table names can be up to 128 characters in length.

ANS: F PTS: 1 REF: AC 8

6. In a one-to-many relationship, each row in the first table may be associated with many rows in the second table.

ANS: T PTS: 1 REF: AC 9

7. The maximum number of characters allowed in a field whose data type is Text is 1024.

ANS: F PTS: 1 REF: AC 9

8. Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Text.

ANS: T PTS: 1 REF: AC 9

9. The Monetary data type is used for fields that contain only monetary data.

ANS: F PTS: 1 REF: AC 9

10. The URL Address data type can store text that can be used as a hyperlink address.

ANS: F PTS: 1 REF: AC 10

11. File names can be a maximum of 255 characters including the file extension.

ANS: T PTS: 1 REF: AC 13

12. A folder is a specific location on a storage medium.

ANS: T PTS: 1 REF: AC 15

13. To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.

ANS: F PTS: 1 REF: AC 28

14. In Datasheet view, a table is represented as a collection of rows and columns called a datasheet.

ANS: T PTS: 1 REF: AC 30

15. One way to undo changes to a field is to click the Undo button on the Table Tools tab.



ANS: F PTS: 1 REF: AC 34



Figure 1-1

16. As shown in the accompanying figure, you can move to the end of a table to a position for entering a new record by clicking the Insert Record Navigation button.

ANS: F PTS: 1 REF: AC 38

17. As shown in the accompanying figure, you can use the Last record button to move to the last record in the table.

ANS: T PTS: 1 REF: AC 38

18. As shown in the accompanying figure, you can move to the first record in a table by clicking the First record Navigation button.

ANS: T PTS: 1 REF: AC 38

19. To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation.

ANS: F PTS: 1 REF: AC 41

20. Landscape orientation means the printout is across the length (height) of the page.

ANS: T PTS: 1 REF: AC 41

21. Grouping means creating separate collections of records sharing some common characteristic.

ANS: T PTS: 1 REF: AC 52

22. Form view displays a single record at a time.

ANS: T PTS: 1 REF: AC 57

23. A DataForm combines both a datasheet and a form.

ANS: F PTS: 1 REF: AC 57

24. Standard properties are associated with all Microsoft Office documents and include author, title, and subject.

ANS: T PTS: 1 REF: AC 60

25. The Tools submenu on the Office menu provides commands to compact and repair a database.

ANS: F PTS: 1 REF: AC 60



Share with your friends:
  1   2   3   4




The database is protected by copyright ©essaydocs.org 2020
send message

    Main page