Computer Science
Class-8
Chapter-6 Microsoft Access
A. Tick the correct option.
1. Which one of the these is an application software which is used to create a database?
a. DNMS b. DDDS c. DBMS d. None of these
Answer: DBMS
2. MS Access is _________ software.
a. DBMS b. RDBMS c. CDBMS d. None of these
Answer: RDBMS
3. Which one of these is designed to display data in an easy to read format for printing?
a. Report b. Form c. Query d. None of these
Answer: Report
4. Which of the following keys is used to move from one column to another?
a. Shift b. Tab c. Enter d. None of these
Answer: TAB
5. Which one of these does not allow null values?
a. Primary key b. View c. Table template d. None of these
Answer: Primary key
B. Write T for true or F for false statements:
1. A telephone directory is also an example of a simple database.
Answer: T
2. RDBMS stores the data into collection of tables, which might be related by common fields.
Answer: T
3. The entries in a record are stored in columns known as records.
Answer: F
4. In MS Access, you can easily and quickly design report based on your data.
Answer: T
5. Auto Number is used for creating a field that lets you to select a value from another table or a list of values.
Answer: F
6. A hyperlink is also a data type in MS Access.
Answer: T
C. Fill in the blanks:
1. ___________ is a collection of data related to each other.
Answer: Databse
2. A table organised data into ____________ and _______________.
Answer: Row, Column
3. RDBMS data is structured in database table, _______ and _________.
Answer: Fields, Records
4. The _____________ is the area on the left of the window and displays database objects.
Answer: Navigation pane
5. A database file created in MS Access has a DOS extension of ___________.
Answer: .mdb
6. A __________ is a field which identifies each record in a table.
Answer: Column
D. Answer the following questions.
1. What is DBMS? Name any two DBMS software.
Answer: DBMS (Database Management System) is a software that allows users to define, create and maintain a database and provides controlled access to the data.
Two DBMS softwares:
1. Automated Teller Machines(ATM)
2. Computerised library system.
2. Name the database objects.
Answer: Database objects are: Table, Query, Form, Report
Table: It is a part of the database where you can store data.
Query: A query is a record or group of records which is used to access information.
Form: A form makes easy to enter data in tables.
Report: Reports are designed to recall data and display in it an eary to read format.
3. What is RDBMS?
Answer: RDBMS stores the data into collection of tables which might be related by common fields. RDBMS data is structured into database tables, fields and records. RDBMS table consists of database table rows. Each database table row consists of one or more database table fields.
4. What is MS Access?
Answer: Microsoft Access is one of the most popular and powerful RDBMS which comes as an integral part of the MS Office suite of application. It is widely used by small and medium sized business houses to organize and manipulate data in an efficient manner.
5. What are two ways of creating database?
Answer: There are two ways of creating database:
* By using a blank database * By using template
Creating a Blank database:
1. Click on Blank database
2. Type a name in file name box.
3. Click on create button.
Creating database using a template:
1. Click on sample templates.
2. Select the database desired by you.
3. Click on Create button.
6. Define the terms; field and records.
Answer: Field: The entries stored in a record are stored in its columns known as fields.
Records: MS access allows you to store related entries in its row and this row is called a record.
7. What is the use of primary key?
Answer: A primary key is a field which uniqeuly identifies each record in a table. It also allows establishing a relationship between tables to link them together. A primary key does not allow null values.
8. Write the steps to sort data in the table.
Answer: Stpes to sort data in the table:
1. Open the table in datasheet view.
2. Click on the arrow on the right of the column header you want to sort out.
3. Click on Sort A to Z to sort data in alphabetic ascending order.
No comments:
Post a Comment