Chapter-2 Access 2016: Design View,Queries,Forms and Report

May 16, 2023 chinu

Access 2016: Design View,Queries,Form and Reports

Q.1 Multiple Choice Qestions

1.This tab has the options to create queries, forms and reports in Access.
i. Home
ii. File
iii. Create

2. Which of the following is not used in Query Designing?
i. Or
ii. Hide
iii. Criteria

3. The Design View window is made up of_____________ parts.
i. Two
ii. Three
iii. Four

4. ……….give us data in a printer-friendly format.
i. Forms
ii. Queries
iii. Reports

5. Click Run in the Results group on the _______ tab.

i.Home
ii.Design
iii. Create

Q.2 Write a True or False

1.Reports are used to capture data.
2. The Query Wizard option in avaliable in the Home tab.
3.Querie can be used as source for forms and reports.
4.Forms are used to display formatted summarized data.
5.You cannot create a table using Design view.

Q.3 Fill in the blanks.

1. _______________can provide an easy-to-use method for entering and editing data for those who are not familiar with Access.

2.___________ allow you to select data from a table or tables as per your requirement.

3.____________give us data in a printer-friendly format.

4. Entering data in ___________ column of Field Definition Grid is optional

5. There are two methods of creating a query in Access _____________ and ____________

Q.4 Answer the following

a. Name the two parts of a Table Design screen.
Ans :-
b. What are the two ways of setting a field as Primary key?
Ans :-
c. Name the four parts of the Field Definition Grid.
Ans :-
d. Explain the two ways of creating a query.
Ans :-
e. What is a Report? What is the importance of Reports in a database?
Ans :-