Objects of Ms Access

1)     What are the different objects of MS-Access?
Ans: The different objects of MS-Access are:
i) Table
ii) Form
iii) Query
iv) Report

2)     Define table. Write different ways to create a table.
Ans: Table is an object of Ms-Access that stores large volume of data in the form of rows and columns.
The different ways to create table are:
i) Design view
ii) Using wizard

iii) Entering data

3)     Write down the importance of table.

Ans: The importances of table are:

·       Different properties of a field can be set in a table.

·       It provides options for primary key which helps to make data consistent.

4)     What is form? Mention the methods to create a form
Ans: Form is an object of Ms-Access which provides graphical interface to enter data into the tables or multiple linked tables.
Methods to create a form are:
i) By using auto forms features.
ii) By using the form wizard features.
iii) By using your own in design view.

5)     Write down the importance of form.

Ans: The importance of form are:

·       It provides an interactive platform for input of data into the database.

·       It helps to display data in more presentable form than a datasheet.

6)     What are the different controls used in form?
Ans: The different controls used in form are text box, combo box, list box, check box, label, command bottom, tab control, etc.

7)     Define query. Mention different types of query.
Ans: Query is an object of Ms-Access which extracts and arranges information from a table in a manner that is specified.
The different types of query are:
i) Select query
ii) Action query
In action query, we have update query, append query, delete query and make-table query.

8)     What are the advantages of query?
Ans: The advantages of query are:
i) We can filer, perform calculations and summarize data.
ii) Large volume of records can be updated or deleted at a same time.
iii) It retrieves and display records including some fields or all the fields of a table or multiple linked tables.

9)     What are the purposes of query in MS-Access?
Ans: The purpose of query in MS-Access are:
i) To view records including some fields or all the fields of a table or multiple linked tables.
ii) To perform mathematical calculation of a data.
iii) To sort the records on the basis of one or more key fields.
iv) To perform mass update, delete or append new records to a table.

10)  What is select query? For what it can be used?
Ans: A select query is the most common category and is used for extracting specific information from one or more tables in a database.
We use select query to group records and perform calculations on field values in the groups such as sum, count, average, minimum and maximum.

11) What is update query?
Ans: Update query is a type of action query which make global changes to a group of records in one or more tables.

12) Write the append query?
Ans: The use of append query is to add a group of records at the end from one or more tables.

13) Write down the importance of query?

Ans: The importances of query are:

·       It allows user to make calculations and change data in automated fashion.

·       It provides option to delete all the unwanted data matching certain criteria.

14) Differentiate between select query and action query.

Ans:

Select query	Action query
i) It is a query which extracts specific information from one or more tables.	i) It is a query which makes changes to many records in just one operation.
ii) It cannot make changes in tales.	ii) It can do changes in tables by update, append.

15) What is report? List any two methods to create report.
Ans: Report is an object of Ms-Access which displays the output in an effective way to present the data in a printed format.
The methods are:
i) Using design view
ii) Using report wizard

16) What is the importance of report?
Ans: The importance of report are:
i) It displays the information the way we want to view it.
ii) It presents the information retrieved through queries or tables.
iii) It presents the information in designed layouts by adding necessary titles, setting font colour or font size, etc.

17) Why is report created?
Ans: Report is created to print documents according to user’s specifications of the summarized information through query or table.

18) What is the data source for report?
Ans: The data sources for report are table and query.

19) Differentiate between form and report.
Ans:

Forms	Report
i) Forms are used to enter, view, and edit information.	i) Reports are used only to view information.
ii) Forms are usually displayed on the screen.	ii) Reports can be previewed on the screen, but they are usually printed.
iii) Forms generally provide a detailed took at records and usually for the people who actually work with the database.	iii) Reports are often used to group and summarize data, and are often for the people who don’t work with the database but who use its information for other business task.