After right click the field selector button, which do you choose to delete a field in design view?
An Access database object that is used to enter, view or edit records
Relationships between tables can be graphically viewed in the _______________ window.
Following is not a database model
What is the corresponding text for the <#1/1/95# validation rule setting?
The page count of a report can be determined by clicking the _______ button.
In MS Access query, which of the fields is derived field? Query: SELECT product.qty AS Quantity, product.rate AS Rate, product.qty*product.rate AS Amount FROM product;
In the form wizard dialog box, the fields from the selected table are displayed in this list box.
Which of the following components has a property sheet that includes settings for the frame and the option group?
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
Database properties do NOT include ___________.
What is the maximum length a text field can be?
Which is not a view for displaying a report object?
Which of the following SQL query deletes Product table from Store database?
In MS Access, OLE Object Data type can store
______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
What is the maximum length a text field can be?
_______ is the clear leader for personal databases.
A ____ often display summary data such as totals or counts.
-
-
-
-
The _________ operator will cause a record to be selected only if two or more conditions are satisfied
The expression builder is an access tool that controls an expression___ for entering an expression
When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from a-z
The expression builder is an access tool that controls an expression______for entering an expression
Which of the following SQL query deletes Product table from Store database?
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?
What is the process of eliminating redundant fields by separating data into tables called?
Which of the following is a standard file format language for web documents?
In Datasheet View, what appears at the top of each column?
Which of the following properties identifies the type of information stored in a field?
The content and application of the Search tool CANNOT be retained when you __
In the Relationship window, related fields from each table are connected by a(n) _______________.
In access, this view is used to create and modify the structure of a form.
_______is used to build ‘intuitive’ queries.
In a query when you have multiple conditions and each of them must satisfy to return the result, use
A disadvantage to a ____file is that there is no easy way to tell which fields are numbers, text, dates, or currency.
In a query\’s Design View, right-clicking the sloping portion of the join line between two tables and selecting Delete will delete what?
Access file operations can be found by clicking the ____.
Data can be import into Access Database from
A(n) ____ in the Record Selector indicates a new record.