Computer Science
Class-VIII
Chapter-5 Microsoft Access
Section-I
A. Answer these questions orally:
1. What is database?
Answer: Logically related data is called Database.
2. What do you understand by RDBMS?
Answer: The software that helps to perform database related functions is called Relational Database Management System (RDBMS).
3. How will you close a database and exit from Access?
Answer: To exit Access choose File-Exit or click the Close button on the Access window.
B. Tick the correct option:
1. The primary navigation tool in Access is the:
a. Database b. Score board c. Record table d. None of these
Answer: Database Window
2. A _____ in Access is a way of getting at the information stored in a database.
a. macro b. query c. module d. none of these
Answer: Query
Section-2
A. Fill in the blanks:
1. ____ is a database program.
Answer: Access
2. The primary navigation tool in Access is the Database_______.
Answer: Window
3. Access stores________ in tables consisting of rows and columns.
Answer: Information
4. Most queries return a datasheet called a __________.
Answer: Recordset
5. ______ button is used for closing database.
Answer: Close
B. State true or false:
1. Access is a database program.
Answer: T
2. Access is a Relational Database Management System(RDBMS).
Answer: T
3. Tables consist of rows and column.
Answer: T
4. A query in Access is a way of getting information stored in a database.
Answer: T
5. Most queries return a datasheet called a Recordset.
Answer: T
C. Answer the following questions.
1. Write short note on MS-Access.
Answer: Access is a database program. Technically, Access is what's known as a Relational Database Management System, or RDBMS for short.
2. Write the steps to navigate the database window.
Answer: You can now use the record buttons and record number text box to navigate among the record.
Step 1. Use the first record and last record buttons to move to the first record or last record, respectively.
Step 2. Use the next record and previous record buttons to move to the next record and previous record, respectively.
3. Write the steps to enter data directly into an Access table.
Answer:
Step 1. Switch to the database window.
Step 2. Click the table tab to display it.
Step 3. Select the table into which you want to enter the data, and then click the open button.
Step 4. Click on the cell in which you want to enter or change data.
Step 5. Close the table by clicking it close button.
4. How do you enter data using a form?
Answer: To enter the information using a form, switch to the database window and click the forms tab to display it. Select the form you want to use, and then click the open button.
No comments:
Post a Comment