A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
Query can be use to select data from
A ____ often display summary data such as totals or counts.
-
-
-
-
Which Form tool creates a new form that show both a form and datasheet views?
The Search tool is best used when searching for ______ data.
To delete records or perform calculations on a table, the best tool to use is a __________.
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
Which of the following creates a drop down list of values to choose from?
Which of the following field properties displays a model or pattern for entering data?
A __ name must be unique within a database
In relational database schema each tuple is divided into fields known as?
Queries are based on this, allowing you to use a query as the source for forms and reports
Microsoft Access uses Jet Query Engine which uses
The ________ button on the tool box display data from a related table.
While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
What is the difference between ‘Open’ and ‘Open Exclusively’?
We can remove a relationship defined between two tables by
Which of the following queries can create a table?
Each record is constituted by a number of individual data items which are called
In a query, what symbol is used to surround a parameter\’s user prompt?
What is the memo data type field used for?
When you add fields in ____, a Field List pane displays.
What it is called to present information in a particular order based on numeric or alphabetical value?
Which of the following is use to view or print the data in organized manner?
Why you can rely on MCQ Sets to prepare your computer jobs exams?
Which of the following best describes the grouped report?
When adding an image, which size mode will change the height or width of the image fit the control?
Referential integrity means
To create a new table, in which method you don’t need to specify the field type and size?
What is the memo data type field used for?
The __________ is the software tool to store or access data.
The size of Yes No field is always
How do you update pivot table report data after changes are made to the source data?
Which of the following views enables users to create and modify the sections of a form?
Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
Which of the following is a standard file format language for web documents?
Which of the following is not a data type
It is most common type of query. It retrieves records from one or more tables and then displays the
Some rules are set in databases to check and permit only correct values. What is this feature called?