CBSE SOLUTIONS-2025-26
CLASS-8
CHAPTER-2 TABLES IN MS ACCESS
A. Tick the correct answer:
1. Find the odd term out:
a. Date/Time b. Field Size c. Required d. Allow Zero Length
Answer: Date/Time
2. Which of the following field properties is used to put conditions on the data that can be entered in a table?
a. Field Size b. Format c. Validation rule d. Required
Answer: Validation rule
3. Which of the following data types lets you store an integer that is incremented automatically as you add records?
a. Currency b. Yes/No c. AutoNumber d. Long Text
Answer: AutoNumber
4. The rows in a table are known as:
a. Fields b. Attributes c. Data d. Records
Answer: Records
5. A field that has a unique value for every record and cannot be left blank is called the:
a. Special key b. Primary key c. Unique key d. DBMS key
Answer: Primary key
B. Write T for true and F for false:
1. Number data type is used for numeric data that will be used in calculations.
Answer: T
2. Field properties pane is used to set properties for the fields in the table.
Answer: T
3. Insert Rows option is used to insert a new field.
Answer: F
4. A database can have only one table.
Answer: F
5. Caption property is used to give an alternate name to a field.
Answer: T
C. Fill in the blanks:
1. A table consists of _________________ and _______________________.
Answer: Rows, Columns
2. ____________________ view is used to enter data in a table.
Answer: Datasheet
3. The _____________________ data type is used to store text or a combination of text and numbers.
Answer: Short Text
4. __________________ field property forces to enter a value, if it is set for yes.
Answer: Required
5. The ________________________ data type is used to store lengthy text that is up to 65536 characters.
Answer: Long Text
D. Answer the following questions:
1. What do you mean by the term table? Name some important components of a table.
Answer: A table is a database object, which is used to store information in an organized manner. It consists of rows and columns. A database can have one or more tables.
Components of a table:
1. Field or Attribute
2. Record
3. Primary Key
2. How will you sort the data within a table?
Answer: To sort records, open the table in Datasheet view and follow these steps:
1. Select the field on the basis of which you want to sort the records.
2. Click on the Ascending/Descending option in the Sort and Filter group on the Home tab.
3. How will you insert a new field within a table?
Answer: To insert a new field within a table follow the steps:
1. On the Home tab, in the Views group, click view, and then click datasheet view.
2. On the table fields tab, in the add and delete group, click more fields.
3. Select a field in the more fields list to insert the new column.
4. Explain the two parts of the design view window.
Answer: The two main parts of a design view window in a database application are the Field Grid and the Properties Pane. The Field Grid is the upper part where you define the fields of a table, including their names, data types, and descriptions.
Field Grid: This are is like a table where you enter the structure of your table. Each row in the grid represents a field in your table.
Properties Pane: Once you select a field in the field grid, the properties pane displays a list of properties that you can customize for that specific field.
5. What do you mean by data types?
Answer: In database, data types define the kind of data a column can store, such as numbers, text or dates. They essentially tell the database how to interpret and process the data in that column. Understanding data types is crucial for ensuring data integrity and proper functionality of the database.
SOME OTHER LINKS:
.jpg)
No comments:
Post a Comment