Queries in Access can be used as
A. view, change and analyze data in different ways
B. a source of records for forms and reports
C. Only A
D. Both A and B
Select an option to see the answer and solution.
If you need to edit a relationship
A. Right click the relationship line and choose Edit Relationship
B. Double click the relationship line
C. Both of above
D. None of above
Select an option to see the answer and solution.
Which of the following is not an action query?
A. add
B. delete
C. make-table
D. update
Select an option to see the answer and solution.
An enterprise solution with data storage, a client interface and a security system is a(n) __________ system.
A. 2-tier
B. 3-tier
C. 4-tier
D. n-tier
Select an option to see the answer and solution.
What is the use of Referential Integrity in MS Access?
A. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
B. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
C. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
D. None of above
Select an option to see the answer and solution.
In Access to reduce the height of the selected control
A. SHIFT+RIGHT ARROW
B. SHIFT+DOWN ARROW
C. DOWN ARROW or CTRL+DOWN ARROW
D. None of these
Select an option to see the answer and solution.
The content and application of the Search tool CANNOT be retained when you ______.
A. format an object
B. resize a column
C. use Datasheet View
D. close an object
Select an option to see the answer and solution.
It is most common type of query. It retrieves records from one or more tables and then displays the
A. Parameter
B. Select
C. crosstab
D. All of above
Select an option to see the answer and solution.
When using Access Database, use this feature to have Access select only certain records in the database to prepare form letters.
A. Report
B. Table
C. Query
D. Tools
Select an option to see the answer and solution.
Which of the following database object hold data?
A. Forms
B. Reports
C. Queries
D. Tables
Select an option to see the answer and solution.
This database has only one table.
A. relational
B. large
C. flat-file
D. DBMS
Select an option to see the answer and solution.
Switch from the Visual Basic Editor back to form or report Design view in Access press
A. ALT+F11
B. SHIFT+F7
C. A and B both are true
D. None is true
Select an option to see the answer and solution.
A _______ is a major database object used to display information in a printable page format.
A. form
B. query
C. report
D. table
Select an option to see the answer and solution.
Which of the following options is NOT a part of an option group?
A. Option button label
B. Option group frame
C. Option group label
D. Option group button
Select an option to see the answer and solution.
The arranging of data in a logical sequence is called
A. Sorting
B. Classifying
C. Reproducing
D. Summarizing
Select an option to see the answer and solution.
the way a particular application views the data from the database that the applicaton uses is a
A. Module
B. Relational model
C. Schema
D. Sub-schema
Select an option to see the answer and solution.
In Access press . . . . . . . . to Cut the selected control and copy it to the Clipboard
A. CTRL+C
B. CTRL+X
C. CTRL+V
D. None of these
Select an option to see the answer and solution.
Which of the following is not a database object?
A. Tables
B. Queries
C. Relationships
D. Reports
Select an option to see the answer and solution.
In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)
A. CTRL+F
B. CTRL+H
C. SHIFT+F4
D. None of these
Select an option to see the answer and solution.
a computer language for informing the dbms regarding the data structure used is
A. Pascal
B. Ddl
C. Prolog
D. Fortran
Select an option to see the answer and solution.