IT Planet Class 8 Computer Chapter 3 Solution – More Features In MS-Access
IT Planet Class 8 Solution: IT Planet Class 8 Computer Chapter 3 More Features In MS-Access all Question Answer Solution by Expert Computer Teacher. Here Students can here all Questions Accurate Answers of Chapter More Features In MS-Access Solution.
Q1) Tick ( √ ) the correct answer :-
a) The selected data appears …………………………….. on your screen.
Ans: ii) Highlighted
b) The shortcut key for ‘Find’ option is
Ans: iii) Ctrl + F
c) You can modify the design of the table in
Ans: ii) Design View
d) Arranging records in a particular order is called
Ans: ii) Sorting
e) It is designed to enter and edit data in a table.
Ans: c) Form
Q2) Fill in the blanks :-
a) Find feature allows you to quickly search through tables, queries and forms for a piece of data.
b) Sorting means arranging the records in a particular order, ascending or descending.
c) Filtering data can help you review and analyse information in your database.
d) Design View and Datasheet View are two views in which you can view your table.
e) Relationships are created and managed in a Relationship window.
Q3) Answer the following questions :-
a) Solution:
In MS- Access the sue of Find feature allows the user to search tables, queries, forms in a database easily and fastly without wasting much time. If you wants to search for the records in any of the specified field, then you ay have to select that field, which happens only if the fields are been properly labelled/indexed. If you wants to search for the fields in all the records, then you may have to select the datasheet or form.
b) Solution:
i) Sorting means arranging the records in a particular order, ascending or descending. You need to select the fields (i.e is depending upon the record which you want to arrange) , if you want to sort the records. You can even change the sequence o f
the records within the table. If incase you wish to sort more than one columns then first
you must the highlight the column by selecting it and then drag the mouse over the field
labels.
ii) Filtering data can help you review and analyse information in your database. This
feature is used only to filter only the records which contains data of interest.
c) Solution:
Design View and Datasheet View are two views in which you can view your table.
Datasheet view allows you to enter data into the table whereas Design View allows you to modify the table. Following are the steps to switch to Design view from Data sheet view :-
i) Make a click on the Home tab.
ii) Click on the view button
iii) From that select the option as Design View. After which the Access will show the design and field properties of the tables.
d) Solution:
The connection of multiple tables those are related to each other. In the
relationships window, you can create and manage relationships between the tables. There is a requirement of the common field between the two tables while creating relationships between them. For the joining or connecting the relationships between the both tables, there should be the existence of fields within the both tables that you want to create relationships. Field in the tables could be the main source for joining of tables. In the database relationship window, by dragging the fields from one table to the other one the relationships between the table is created. The steps for creating relationships between the tables are as follows :-
i) Click on the Database Tools tab.
ii) Click on Relationships button to display the relationships window.
The relationship window will be shown only if there is existence of any relation between the tables in your database, a box for each table gets displayed in the window.
The tables that are there in your database is showed in the Show Table box.
iii) If incase there is a situation, where the Show Tables dialog box shows on the screen, then you have to click on Show Table button after which it will show.
iv) Now make click on the tables that you want to add relationships to.
v) Click on the Add button to add them into the window.
vi) Now just make a repetition of the step no 4 and 5 for the tables that you want to add.
vii) Once you are done with adding the tables in relationship window, then click on the Close button to remove/ close the Show Tables dialog box. The box for each table will be displayed in the relationships window.
The primary key for each tables will appear. Primary key is used to identify the tables records uniquely. The fields that are matching are been identified and then relationship between the table is created.
viii) Now keep you mouse cursor on the field that you want to create relationship with
other table.
ix) Now the drag the mouse over the other table until a small box appears over the
matching field. Edit Relationship dialog box will appear
The names of the tables that you want to create relationships between and the field names will appear on the Table/Query and Related table/Query. Relationship type will show the type of relationship added.
x) Now click on the create button to make a relationship.
To show that the relationship between the tables s created a line will be connected
to the field of the two tables.
e) Solution:
Form allows you to add and update data in a table, one record at a time. With the
making use of data form, it helps the user to enter the database list very fastly. There is
availability of all table fields in your data form. By filling/completing the fillation of fields in the form, it is easier for one to enter a record.
Q4) Application Based Questions :-
Solution:
If Richa has created three tables. But she can make a relationship between two tables
that is Table no 1 and Table no 2. There is the common field in two tables as Emp_no.