Following is not a database model in Microsoft Access
A. network database model
B. relational database model
C. Object Oriented database model
D. None
Microsoft Access MCQS
Microsoft Access MCQS Microsoft Access 2007, Microsoft Access 2009 MCQS, Microsoft Access 2013 MCQS Microsoft Access 2016 MCQS, Microsoft Access 2017 MCQS. All MS Access MCQS, MS Access Design, MS Access Page layout MCQS, MS Access Best MCQS, MS Access Online MCQS MS Access Pages, MS Access toolbar mcqs, MS Access Queries MCQS, MS Access RDBMS MCQS, MS Access Database. best of Microsoft Access mcqs for FPSC exams preparation BPSC exams preparation PPSC exams preparation SPSC exams preparation KPPSC exams preparation NTS tests preparation OTS tests preparation CTS tests preparation PTS tests preparation BTS tests preparation CTSP tests preparation
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
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
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
In table design view what are the first column of buttons used for
A. Indicate Primary Key
B. Indicate Current Row
C. Both of above
D. None of above
Which field type will you select when creating a new table if you require to enter long text in that field?
A. Text
B. Memo
C. Currency
D. Hyperlink
To duplicate a controls formatting you can use___
A. Manager
B. Wizard
C. Painter
D. Control
After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
A. You need to delete the whole table there is no method to remove a particular field only.
B. Delete all the fields from third downwards and reenter the required fields again.
C. Select the third column in datasheet view then Delete
D. Select the third row in table design view then Delete
To create relationship between two tables
A. drag any field from the parent table and drop on the child table
B. drag the foreign key of a table into the primary key of another table
C. drag the primary key of a table into the foreign key of another table
D. Any of above can be done to create a relationship