In a query, what symbol is used to surround a parameter\’s user prompt?
Which of the field has width 8 bytes?
If you need to edit a relationship
Database properties do NOT include ___________.
A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
_______is used to build ‘intuitive’ queries.
In MS Access “Lookup Wizard” is used to
Which of the following is not one of the methods available in the new query dialog box to create queries?
In MS Access, OLE Object Data type can store
Which of the following can be an example of a database?
We can remove a relationship defined between two tables by
A file containing relatively permanent data is
vWhich of the following store command to retrieve data from database?
You can move between fields in a form by using any of these keys except
If you write “Like Su*” in criteria cell of FirstName field it will display
It is an association established between common fields of two tables.
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;
What type of controls are text boxes when data from the recordset is visible?
When entering field name, how many characters you can type in maximum?
This type of database contains multiple tables that are connected to produce combined output from all tables.
Changing the order of this in the query datasheet does not affect the field order in the table.
Which of the following is not a type of Microsoft Access database object?
The arranging of data in a logical sequence is called
Which statement does not hold true?
What are the different views to display a table
Which control types is most often associated with a bound control?
Why you can rely on MCQ Sets to prepare your computer jobs exams?
How do you filter by selection?
Which of the following is the DBMS type
In relational database schema each tuple is divided into fields known as?
Which of the following is not a field type in access
What are the columns in a Microsoft Access table called?
In Access 2007, to make changes in the Trust Center, you need to go to the ____.
DCL provides commands to perform actions like
A Smart Tag can be set using the _____ tab in the property sheet.
In the Field List of a table, the primary key appears _______________.
Which function can not be used for calculated controls in a report?
Which of the following functions CANNOT be used in the Totals row?
This option allows you to build a new table by entering data directly into the datasheet.
A DBMS that runs on many different operating systems is said to be __________.