ADVANCED ACCESS
1) Write the uses of:
a) Query – It helps us retrieve data from one or more tables quickly based on the given criteria.
b) Forms – It provides user-friendly screens to enter, view and update data in the tables.
c) Reports – It helps us summarize the records in a format that can be printed.
2) Explain action queries.
Ans – Queries that can be used to add, change or delete data in the tables.
3) Write the operator for the following data type.
4) Write the steps to create query with single condition.
Ans – They are:
Click on the Create tab.
Click on the Query Design option in the Queries group. The Show Table dialog box appears.
In the Show Table dialog box, choose the table and click on the Add button. After adding the table,
click on the Close button to close the Show Table dialog box.Upper section contains the table and
lower section has the design grid.
Add the fields in the Design Grid by choosing the field name from the Field drop-down list.
Type the search condition in the Criteria row of the field on the basis of which the records should be
filtered.
Click on the Save option in the Quick Access Toolbar to save the query. The query object gets added
to the navigation pane.
Click on Run option in the Result group on the Design tab to execute the query.
5) Write some shortcut ways to add fields to the Design Grid.
Ans – They are:
Click the * symbol in the table window to add all the fields to the query.
Drag and drop the field from the table window to the Field row in the Design Grid.
Double-click the field to automatically add it to the next empty column in the Field row in the Design
Grid.
6) Explain the two ways to create a query with Multiple Conditions with example.
Ans – They are:
Specifying condition for more than one field in the Criteria row: Criteria specified this way are
combined using the AND operator. It will display those records that meet all the conditions.
Eg: To retrieve details of books where price is more than Rs 500 and Genre is Humour.
Specifying condition in the Criteria row, or row and the rows beneath it: Croteria specified this way
are combined using the OR operator. It displays records that meet one or more of the specified
conditions.
Eg: To retrieve details of books where price is less than Rs 500 or Genre is Humour or Book Name is
‘The Alchemist’
7) Explain Form.
Ans – It provides an interface that allows users to enter, change and view the data in the database table.
They are made up of elements such as textbooks and tables. These are called controls.
8) Explain the three views in which Forms can be worked on.
Ans – They are:
Form View: To enter, edit and view data.
Layout View: To view the data as well as to make design changes in the form such as changing the
size of various controls.
Design View: To change the structure of the form. In this, we cannot view the underlying data but
can perform some tasks that cannot be performed in Layout view such as adding images.
9) Write the steps to create a Form.
Ans – They are:
Click on the table in the Navigation Pane on which the form should be based.
Click on the Form option in the Forms group on the Create tab. A form is created and it opens in the
Layout View. We can switch to the Form view to enter or display data in the table.
Click on the Save option in the Quick Access Toolbar.
10) Write the two ways to format a Form.
Ans – They are:
Using the Design Tab – In this, we can add a logo and title. We can also change the theme for the
form to make it look more presentable. This option is present in the Theme group.
Using the Format Tab – We can format the font (size, color, alignment), add a background image or
change the color of shapes using the options on the Format tab.
11) Explain Report.
Ans – They are used to present data from tables or queries in a format that can be printed. We cannot make
changes to the data in a report.
Eg: Printouts of report cards, invoices.
12) Explain the four views in which Reports can be worked on.
Ans – They are:
Report View: To view records from the table or the query.
Print Preview: To preview the report as it will appear after printing.
Design View: To display only the structure of the report. We cannot see the underlying data, but can
perform some tasks that cannot be performed in Layout view such as adding Header and Folder.
Layout View: To view the data and make changes in the report such as changing the size of various
controls.
13) How to switch between the different views of a report.
Ans – We need to click the down arrow under the View option in the Views group on the Home tab to switch
between the different views of a report.
14) Write the steps to create a Report.
Ans – They are:
Click on the table or the query on which the report is to be based.
Click on the report option in the Reports group on the Create tab.
Click on the Save option in the Quick Access Toolbar to save the report.
15) Write the two ways to format a Report. (same answer as Q10)
Ans – They are:
Using the Design Tab – In this, we can add a logo and title. We can also change the theme for the
form to make it look more presentable. This option is present in the Theme group.
Using the Format Tab – We can format the font (size, color, alignment), add a background image or
change the color of shapes using the options on the Format tab.
16) Write the steps to Print Reports.
Ans – They are:
Click the down arrow under View option in the Views group on the Home tab.
Click on the Print Preview option. The report is displayed in the manner in which it will appear on a
page when printed.
Set Page Size, Margins and Orientation for the report using options present on the Ribbon.
Click on the Print option to print the report.
17) Name the co-founder of Oracle Corporation. What is the work of this company?
Ans – Larry Ellison.
This company sells database software and technology.
18) Write the function of the Parameter query. How to initiate this query?
Ans – It enables the user to give the criteria value when the query is run.
For this process, type the prompt message that will pop up each time we run a query. We need to ensure
that the prompt message is enclosed in the square brackets [] in the criteria row.
19) How to delete unwanted fields in the Report?
Ans – The generated Report may contain fields that we may not want. To remove these unwanted, click the
cell containing the field and press the Delete key.
