Access Flashcards
A field with the _____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
Attachment
To find all clients whose names begin with Gr, enter _______ in the Criteria row of the Client Name field.
Gr*
True or False. Landscape orientation means the printout is across the length (height) of the page.
True
A field whose data type is _______ can store an OLE object, which is an object linked to or embedded in the table.
OLE Object
True or False. The Database Tools tab provides commands to compact and repair a database.
False
True or False. Cross tab queries are useful for summarizing data.
True
To change the caption for a field in a query, click the field in the design grid, click the ______ button on the Design tab, click the Caption box, and enter the new caption.
Caption
True or False. A query that prompts for input whenever it is run is a run-time query.
False
In Access, table and field names can be up to _______ characters in length.
64
True or False. When tables are joined in a query, it is not possible to restrict retrieval by using criteria.
False
To import data to a table, click the ______ tab on the Ribbon.
External Data
To order the records in the answer to a query in a particular way you _______ the records.
sort
True or False. To create a parameter query that will prompt users to enter a city name as input, place [Enter City] as the criterion in the City Field.
True
True or False. To restrict the objects that appear on the Navigation Pane use the Restrict Bar.
False
True or False. When Access first creates a database, it automatically creates a table.
True
A _______ contains information about a given person, product, or event.
record
True or False. In Access, the rows in the table are called records.
True
True or False. To rename a field, right-click the column heading for the field, and then click Rename Field on the shortcut menu.
True
True or False. The only calculated fields you can create in Access are those involving addition.
False
To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click _________, and then click Proofing in the dialog box that displays.
Options
To include calculated fields in queries, enter a name for the calculated field, a _______, and then the expression in one of the columns in the Field row.
colon (:)
To change the design of a query, right-click the query in the Navigation Pane and then click _____ on the shortcut menu.
Design View
True or False. Grouping means creating groups of records that share some common characteristic.
True
True or False. To enter a criterion for a particular field without displaying the field in the results of the query, include the field in the design grid, enter the criterion, and remove the check mark from its Show check box.
True
True or False. Redundancy is the storing of a piece of data in more than one place.
True
To compact and repair a database, click the _______ button in the Information gallery in the Backstage view.
Compact & Repair
True or False. Report view shows a report on the screen and allows the user to make changes to the report.
False
True or False. To find all clients whose amount paid is greater than $1,000.00 or whose business analyst is analyst 11, enter each criterion on the same line.
False
True or False. If you specify more than one sort key, the sort key, on the left will be the minor sort key and the one on the right will be the major sort key.
False
To show the symbol for the Euro instead of the dollar sign, change the _________ property for the field whose data type is Currency.
Format
In the accompanying figure, you can enter BC76 in the ________ row of the Client Number field to find all clients whose client number is BC76.
Criteria
To indicate grouping in Access, select _______ as the entry in the Total row for the field to be used for grouping.
Group By
Less than (), and NOT (not equal to) are examples of __________.
comparison operators
True or False. In Access, table names cannot contain digits.
False
True or False. A property sheet is a window containing the various properties of the object.
True
In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a _________.
databases
True or False. An inner join is the default join in Access.
True
True or False. You cannot create a form for a query.
False.
To print the results of a query that is open, click File on the _____ tab in Backstage view, and then click Quick Print.
True or False. A soft copy is information that exists on a physical medium such as paper.
False
To rename a database object, right-click the object in the NavigationPane and the click ______ on the shortcut menu.
Rename
To change the print operation from portrait to landscape, click the ______ button on the Print Preview tab.
Landscape
To define an additional field in Datasheet view, click the _________ column heading.
Click to Add
True or False. The expression for a calculated field can be typed directly into the Field row.
True
To create a new query in Design view, click Create on the Ribbon to display the Create tab and then click the _________ button to create a new query.
Query Design
In the accompanying figure, the key symbol that appears in the row selector for the Business Analyst Number is the ________ for the table.
primary key
True or False. 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.
False
True or False. The maximum number of characters allowed in a field whose data type is 255 characters.
True
To undo the most recent change to a table structure, click the ______ button on the Quick Access Toolbar.
Undo
