Field whose data type is can contain any characters.
a. text
b. lookup
c. alpha
d. normal
field with the data type can store a unique sequential number that access assigns to a record. access will increment the number by 1 as each new record is added.
a. incremental
b. autonumber
c. autosequence
d. sequential
access is a
a. word processing software tool
b. file management system
c. workbook management system
d. database management system
database refers to the arrangement of data into tables and fields.
a. management
b. relations
c. language
d. design
in access, all the tables, reports, forms, and queries that are created are stored in a single file called a .
a. repository
b. container
c. placeholder
d. database
in access, table and field names can be up to characters in length.
a. 32
b. 64
c. 128
d. 255
to back up a database, use the back up database command on the tab in the backstage view.
a. save object as
b. tools
c. save & publish
d. options
to change the name of a field, right-click the column heading for the field, click on the shortcut menu, and then type the desired field name.
a. change field
b. rename field
c. change column
d. rename column
to create a query using the query wizard, click on the ribbon and then click the query wizard button.
a. insert
b. report
c. new object
d. create
to compact and repair a database, click the button in the information gallery in the backstage view.
a. restore
b. compaction
c. fix
d. compact & repair
to define an additional field in datasheet view, click the column heading.
a. blank field
b. new field
c. click to add
d. insert field
to delete a field in a table, right-click the column heading for the field, and then click on the shortcut menu.
a. delete column
b. remove field
c. remove column
d. delete field
to import data to a table, click the tab on the ribbon.
a. file
b. database tools
c. external data
d. import
to rename a database object, right-click the object in the navigation pane and then click on the shortcut menu.
a. rename
b. redefine
c. save name
d. new name
you can place an insertion point by clicking in the field or by pressing
a. f3
b. f5
c. f4
d. f2