In a table to insert User\’s Voice, Data field should be
You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?
Database access levels are specified so as to define who can access what in a database. It is identified through
Referential integrity means
In a module, the VB Name used to display a warning query icon is _______.
Which of the following field properties displays a model or pattern for entering data?
Which of the following database objects asks a question of information in a database and then displays the result?
After right click the field selector button, which do you choose to delete a field in design view?
In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
You can set a controls border type to make the border invisible.
What is the memo data type field used for?
Using the keyword _______________ will return records in which the field value equals a defined text.
Which of the following statements about criteria in a query is NOT true?
The size of a field with Number data type can not be
Which of the following methods CANNOT be used to delete records from a table?
The page count of a report can be determined by clicking the _______ button.
What is the propose to a sub datasheet?
Relationship can be establish between two tables by
How can you add a table to the relationship window?
It is a sign or symbol that specifies, operator, and values that produce a result
When creating a new table which method can be used to choose fields from standard databases and tables
In MS Access, Field Value may contain
Which of the following queries prompts users for input data by displaying dialog boxes?
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
Data items groped together for storage purposes are called a
Which is not an option for Filter on a text field?
Which of the following methods CANNOT be used to delete records from a table?
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
Which data type is better to use for storing the price of an item?
You created a query with two tables that have relationship of One-To-Many with referential rulesapplied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Which of the following dialog boxes enables users to enforce referential integrity in a One-To-Many relationship?
If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
What does the show check box in query design window indicate
By default, what is the name of a new module in the Modules folder of the Project pane called?
vWhich of the following store command to retrieve data from database?
Will answer questions you did not think to ask of your data.
A part of database that stores complete information about an entity such as employee, sales, orders etc.
How can you display pivot table report summary data in a currency format?
It is a database object to view, change, and analyze data in different ways