To remove all Sorts in a table you can click the ______ command.
What determines a table’s sort order?
To delete records or perform calculations on a table, the best tool to use is a __________.
Which of the following is a condensed form of standard generalized markup language?
What is the maximum length a text field can be?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
Which of the following is a method to create a new table in MS Access?
To set a password for the database, select ____________ in the Microsoft Access open window.
How can you display pivot table report summary data in a currency format?
This database has only one table.
We can remove a relationship defined between two tables by
Which statement does not hold true?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
The three parts of an IIF function are separated by _____.
What is the use of Referential Integrity in MS Access?
Which of the following field properties displays a model or pattern for entering data?
Which editor was provided for use with access basic?
The ‘filter by selection’ allows you to filter those records
After creating the table which of the following is correct?
______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
Which of the following terms does not describe a database structure used by a dbms to link data from several files?
What does the expression [detail] ! [product] * 1.30 do?
All attachment fields display as a(n) ____ in Datasheet View.
Which of the following store command to retrieve data from database?
You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting recordset would have how many records?
What is the use of Referential Integrity in MS Access?
Which of the following types of joins displays records with the same value in the common field?
Which is not an option for Filter on a text field?
What is the keyboard shortcut to move to the last records in a table?
To create primary key for a table when in design view
A(n) _______ is major object that completes an action or a set of actions.
Which criteria return only those addresses beginning with the letter “K”?
Which field type can store photos?
A(n)_______ is a major object that can run independent of a control.
The command center of access file that appears when you create or open the MS Access database file.
For _________ data to be useful, both the sender and the receiver need to be able to read and use the data.
Which of the following statements about a tab control in a form is incorrect?
Both conditions display on the same row in the design grid when ___operator is in use