When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms. a. b.tag c.caption d.alternate |
c.caption |
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo. |
False |
To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu. a.Insert Column b.Add Field c.Add Column d.Insert Field |
d.Insert Field |
Layout view shows a report on the screen and allows the user to make changes to the report. |
True |
To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu. a. b.Delete c.Trash d.Erase |
b.Delete |
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu. a.Open b.Design View c.Query Window d.SQL |
b.Design View |
To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu. a.Delete Column b.Delete Field c.Remove Column d.Remove Field |
b.Delete Field |
The Currency data type is used for fields that contain only monetary data. |
True |
The Character data type is used for a field that can store a variable amount of text or combinations of text and numbers where the total number of characters may exceed 255. |
True |
A unique identifier is also called a primary key. |
True |
The maximum number of characters allowed in a field whose data type is Short Text is 255 characters. |
True |
A 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.Sequential b.AutoNumber c.Incremental d.ValueIncrement |
b.AutoNumber |
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255. a.Variable b.Memo c.Character d.Long Text |
d.Long Text |
To change the name of a field, press and hold or right-click the column heading for the field, and then tap or click Rename Field on the shortcut menu. ____________________ |
True |
To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click Insert Column on the shortcut menu. ____________________ |
False |
A field whose data type is ____ can store text that can be used as a hyperlink address. a.URL b.Hyperlink c.Web d.Placeholder |
b.Hyperlink |
To preview and then print the contents of a table, use Table Preview. |
False |
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table. a.Bitmap b.OLE object c.Image d.Illustration |
b.OLE object |
To print a wide database table, a table whose contents do not fit on the screen, you will need portrait orientation. |
False |
A field whose data type is ____ can contain any characters. a.Short Text b.Character c.Alpha d.Normal |
a.Short Text |
In Access, table and field names can be up to ____ characters in length. a.256 b.128 c.64 d.32 |
c.64 |
___ words are words that have a special meaning to Access and cannot be used for the names of fields. a.Significant b.Tagged c.Restricted d.Reserved |
d.Reserved |
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view. a.Restore b.Fix c.Compact & Repair d.Compaction |
c.Compact & Repair |
To delete a field, press and hold or right-click the column heading for the field, and then tap or click Remove Field on the shortcut menu. ____________________ |
False |
To open the Navigation Pane, tap or click the ____ Button. a.Open Pane b.Shutter Bar Open/Close c.Open Navigation Pane d.Navigation Bar Show/Hide |
b.Shutter Bar Open/Close |
In a(n) ____ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject. a.relational b.tabular c.record d.attribute |
a.relational |
In Access, the columns in a table are called records. |
False |
The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________ |
False |
Each customer has one book rep, but each book rep can have many customers. This is an example of a one-to-many relationship. |
True |
Redundancy means storing the same fact in more than one place. |
True |
A(n) ____ contains information about a given person, product, or event. a.record b.attribute c.field d.column |
a.record |
To undo the most recent change to a table structure, tap or click the ____ button on the Quick Access Toolbar. a.Reverse b.Back c.Undo d.Cancel |
c.Undo |
To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu. a.New Name b.Redefine c.Save Name d.Rename |
d.Rename |
In Access, field names cannot contain digits. |
False |
To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name. a.Rename Column b.Change Column c.Rename Field d.Change Field |
c.Rename Field |
To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays. a.Grammar b.Customize c.Options d.Manage |
c.Options |
In Datasheet view, a table is represented as a collection of rows and columns called a list. |
False |
To delete a record, tap or click the record selector for the record, and then press the ____ key(s). a.CTRL+DELETE b.DELETE c.CTRL+Y d.CTRL+K |
b.DELETE |
To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency. a.Format b.Description c.Field Size d.Caption |
a.Format |
To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view. a.Back Up Current b.Save As Back Up c.Close and Back Up d.Back Up Database |
d.Back Up Database |
Changing the column width in a datasheet changes the structure of a table. |
False |
You can place an insertion point by tapping or clicking in the field or by pressing ____. a.F2 b.F3 c.F4 d.F5 |
a.F2 |
To add a record to a table, tap or click the ____ record button. a.Add New b.Last c.New (blank) d.Insert (New) |
c.New (blank) |
One way to undo changes to a field is to click the Undo button on the status bar. |
False |
To import data to a table, tap or click the ____ tab on the ribbon. a.FILE b.IMPORT c.DATABASE TOOLS d.EXTERNAL DATA |
d.EXTERNAL DATA |
The Navigation Pane contains a list of all the objects in the database. |
True |
Standard properties are associated with all Microsoft Office documents and include author, title, and subject. |
True |
A field that has the Calculated data type can store a unique sequential number that Access assigns to a record. ____________________ |
False |
Landscape orientation means the printout is across the length (height) of the page. |
True |
Access is a ____. a.database management system b.file management system c.workbook management system d.word processing software tool |
a.database management system |
To save the changes to the layout of a table, tap or click the Save button on the ____. a. b.status bar c.TABLE TOOLS tab d.Navigation Pane |
a.Quick Access Toolbar |
To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu. a.Datasheet View b.Open c.Run d.Results View |
b.Open |
A(n) ____ contains information about a given person, product, or event. a.field b.record c.column d.attribute |
b.record |
When Access first creates a database, it automatically creates a table. |
True |
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet. a.Attachment b.Extend c.Document d.File |
a.Attachment |
Redundancy means storing the same fact in more than one place. |
True |
The term list database describes a database that consists of a collection of tables, each of which contains information on a specific subject. ____________________ |
False |
To define an additional field in Datasheet view, tap or click the ____ column heading. a.Add Field b.Insert Field c.New Field d.Click to Add |
d.Click to Add |
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo. |
False |
Form view displays a single record at a time. |
True |