In a database table, the category of information is called ____________
Which of the following field properties enforces the use of parentheses when keying an area code?
What is the keyboard shortcut to move to the last records in a table?
How to make a date field DOB store the dates like “2002/10/17” ?
Which of the following functions CANNOT be used in the Totals row?
The database language that allows you to access or maintain data in a database
In a module, the VB Name used to display a warning query icon is _______.
The complete information about an entity in a database is called
To create a new table, in which method you don’t need to specify the field type and size?
The file extension for an access 2003 database is
The ________ button on the tool box display data from a related table.
Which of the following is not an action query?
Which of the following statements about calculated fields is NOT true?
According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
Which action will optimize your database performance?
In the Relationship window, related fields from each table are connected by a(n) _______________.
According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?
Referential integrity cannot be set for _______________ relationships.
In the relationships window, what does the appearance of symbols, such as 1 and the infinity symbol, at the endpoints of a relationship line mean?
In access, the best types of queries to use for data analysis are:
What happens when a user selects a record in a form and presses [Delete]?
_____ is an association that is created in a query between a field in one table or query and a field of the same data type in another table or query.
Which data type is better to use for storing the price of an item?
In the second subform wizard dialog box you specify the table to use as the data source and the
Which query do you use to answer the question “Which employees earn more than $5000 a month”?
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?
The__ button on the tool box display data from a related table
Which data type is better to use for storing the price of an item?
In a query, which row do you need to place wildcards to affect a parameter?
What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?
In MS Access “Lookup Wizard” is used to
Which of the following creates a drop down list of values to choose from a list?
It is a query that when run displays its own dialog box prompting you for information, such as
In MS Access, OLE Object Data type can store
Which control does access use to link data access page components to Access data?
The _________ operator will cause a record to be selected only if two or more conditions are satisfied
Using the keyword _______________ will return records in which the field value equals a defined text.
In access, this view is used to create and modify the structure of a form.