The command center of access file that appears when you create or open the MS Access database file.
A. Database Window
B. Query Window
C. Design View Window
D. Switchboard
Wahab Dashti
When creating a new table which method can be used to choose fields from standard databases and tables
A. Create a table in Design View
B. Create Table using wizard
C. Create Table by Entering data
D. None of above
A database language concerned with the definition of the whole database structure and schema is ________
A. DCL (Data Control language)
B. DML (Data Manipulation language)
C. DDL (Data Definition Language )
D. All of above
What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A. A relationship is created
B. Edit relationship dialog box appears
C. Error occurs
D. Nothing happens
Following is not a database model in Microsoft Access
A. network database model
B. relational database model
C. Object Oriented database model
D. None
What does the show check box in query design window indicate
A. It indicates whether the field is to be used or not
B. It indicates whether the field is to be displayed in query result or not
C. It indicates whether the field names to be displayed in query result or not
D. None of above
This option allows you to build a new table by entering data directly into the datasheet.
A. datasheet view
B. design view
C. link table
D. None of the above
Which of the following is not a type of relationship that can be applied in Access database
A. One to One
B. One to Many
C. Many to Many
D. All of the above can be applied
To create queries in Microsoft Access
A. You can drag and drop fields on query builders
B. you can type the SQL command in SQL view
C. You can use the query wizard or design view
D. All of above
To sort records in a table
A. Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
B. Open table, click Sort button on database toolbar, choose a field based on which to sort, click OK
C. Click the field heading to sort it ascending or descending
D. All of above