It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
A. Parameter
B. Select
C. crosstab
D. Append
Wahab Dashti
The___ operator will cause a record to be selected only if two or more conditions are satisfied
A. Or
B. If or
C. Range
D. And
Microsoft Access is a
A. RDBMS
B. OODBMS
C. ORDBMS
D. Network database model
If you need to edit a relationship in MS Access
A. Right-click the relationship line and choose Edit Relationship
B. Double click the relationship line
C. Both of above
D. None of above
What is the difference between ‘Open’ and ‘Open Exclusively’?
A. The open statement opens access database files and Open Exclusively opens database files of other programs like Oracle
B. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
C. Both Open and Open Exclusively are same
D. Open Exclusive command does not exist in MS Access
Data Control List (DCL) provides commands to perform actions like
A. Change the structure of the tables
B. authorizing access and other control over the database
C. insert, update or delete records and data values
D. None of above
Which field type can store photos?
A. Hyperlink
B. OLE (Object Linking and Embedding)
C. Both of these can be used
D. Access tables can’t store photos
It is a query that when run displays its own dialog box prompting you for information, such as
A. Select
B. crosstab
C. Parameter
D. Append
Which of the following is a method to create a new table in MS Access?
A. Create table in Design View
B. Create Table using wizard
C. Create Table by entering data
D. All of above
If you write criteria values vertically (one in a row) it will mean
A. OR conditions
B. AND conditions
C. NOT condition
D. None of above