Solved Exercise
Class-7th
Chapter-4
A. Multiple choice questions.
1. Data and _______ are important components of a computer system.
a. digit b. number c. symbol d. information
Answer: information
2. Data is normally stored in a database or a file and managed by the ____.
a. DBMS b. DSMB c. DSBM d. MBDC
Answer: DBMS
3. A single piece of information is known as a _______.
a. field b. record c. table d. data
Answer: Record
4. _____ displays the name of database.
a. title bar b. scroll bar c. status bar d. access ribbon
Answer: Title bar
5. Access work area enables the use of database object such as _________.
a. table b. forms c. reports d. all of these
Answer: all of these
6. _____ are the collection of programs written to access the database.
a. Queries b. pages c. Modules d. Macros
Answer: Queries
7. To close Microsoft Access from its title bar, you can click its_____ button.
a. open b. close c. create d. save
Answer: Close
B. Write T for true and F for false:
1. Information is the processed data on which decisions and actions are based.
Answer: T
2. The complete set of fields is called a table.
Answer: F
3. A database is made up of fields, records and tables.
Answer: T
4. The right side of the title bar displays the Quick Access Toolbar.
Answer: F
5. Forms are used to add, view and edit data of the tables.
Answer: F
6. To close Microsoft Access, you can click on File and then click on Exit.
Answer: T
C. Fill in the blanks:
1. _____ is normally stored in a database or a file and managed by the DBMS.
Answer: Data
2. Rows are known as record and ________ as field.
Answer: Column
3. In ________ certain standards can be applied in data representation.
Answer: DBMS
4. MS Access 2010 is used by both programmers and ______ to create their own
database.
Answer: non-programmer
5. Select the database that you want to open and then click _________.
Answer: Open
6. The status bar appears at the _____ of Access window.
Answer: Bottom
D. Answer the following questions in short:
1. What is Database?
Answer: An organized collection of information and records.
2. What is DBMS?
Answer: A set of computer program that controls the creation, maintenance, and the use of the database in the computer by the user.
3. Give the difference between Tables and Reports.
Answer: Table is a collection of related information in the form of rows and columns.
Reports: These present data form a table or query in a printed format.
4. What is MS Access 2010?
Answer: Microsoft office access 2010 is a pseudo-relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine.
5. Write the steps to open MS Access 2010.
Answer:
1. Click on the start button.
2. Click on All programs.
3. Select Microsoft office 2010.
4. Click on Microsoft Access 2010.
5. Access opens up.
E. Answer the following questions in detail:
1. What is the structure of database? Give an example.
Answer: The structure of a database is made up of fields, records and tables.
Field: Single piece of information is known as a field.
Record: The complete set of fields is called a record.
Table: It is a collection of related information in the form of rows and columns.
2. What are the advantages of DBMS?
Answer: Advantages of DBMS:
1. Reduces data redundancy
2. Enforces Standards
3. Data sharing
4. Data security
5. Multiple user interfaces.
6. Backup and Recovery
3. Write the steps to create a new database using MS Access.
Answer: To create a new database, we follow the following steps:
1. Open MS Access 2010
2. Click on new blank database.
3. Click on All programs.
4. Click on MS office
5. Click on MS Access 2010.
4. Write the parts of MS Access Database Interface Window.
Answer: Different parts of MS Access database interface window:
1. Title bar
2. Access Ribbon
3. The status bar
4. Scroll bar
5. Navigation pane
6. Access work area.
5. How do you create a new table in an existing database?
Answer:
1. Click on the MS office, then click on open.
2. Select database, then click on open.
3. Click on the table.
4. Select table design.
5. Enter fields name and its data type.
6. Save the table.
6. Explain the various objects of MS Access Database.
Answer: Different components of MS Access database:
1. Table: They store information in the form of rows and columns.
2. Queries: They allows you to extract data.
3. Forms: Forms are the input screens designed to simplify the data entry process.
4. Reports: These present data form a table or query in a printed format.
5. Pages: Pages are used to add, view and edit data of the tables.
F. Define the following terms:
1. Field 2. Record 3. Table 4. Queries 5. Macros
6. Modules 7. Forms
Answer:
1. Field: A single piece of information
2. Record: A complete set of fields
3. Table: Table is a collection of related information in the form of rows and columns.
4. Queries: They allows you to extract data.
5. Macros: They help you to perform routine tasks
6. Modules: Modules are the collection of programs written to access the database.
7. Forms: Forms are the input screens designed to simplify the data entry process.
Some other links:
No comments:
Post a Comment