Page 98 - TP_iPlus_V2.1_Class7
P. 98
B. Fill in the blanks using the words given below.
Hints: Record, Design, Datasheet, Yes/No, Database1
1. The default view of the table is ................................ view.
2. The ................................ data type is used for the fields with Boolean values.
3. A set of values for the fields is called a ................................ .
4. The default file name of Access file is ................................ .
5. The records are not visible in ................................ view.
C. Write ‘T’ for true and ‘F’ for false.
1. Embed datatype is used to embed an object created in another application, such as
Word, Excel or PowerPoint. ................................
2. Templates are built-in database formats designed for specific tasks. ................................
3. There can be multiple primary keys in a table. ................................
4. RDBMS minimizes the duplication of data. ................................
5. Table is also knowns as Relation. ................................
Section B (Subjective)
A. Short answer type questions:
1. Which database object is specially designed to display or print the data in a formatted way?
2. What is the name given to the first field in Access?
3. How can you switch between the two views of Access?
B. Long answer type questions:
1. Write the steps of sorting the records in a table.
2. Write the steps of creating a table using design view.
3. Write steps to add a record in a table.
C. Competency-based/Application-based questions:
1. Sonal is creating a table to store the student details. What criteria should she
should keep in mind while choosing the Primary key?
2. Maria needs to extract specific information from a table based on certain conditions, such as
finding students who scored above 90 in their exams. Which database object should she use to
accomplish this.
Higher Order Thinking Skills (HOTS) #Digital Literacy
1. Neha wants to manage student records for her school using a modern approach than traditional
methods. She is looking for software that allows her to add, edit, search and delete data. What software
would you recommend.
2. Categorise the valid field names and invalid field names in Microsoft Access from the following set of
field names:
(i) Student_Name (ii) grade.7 (iii) phone# (iv) First name (v) Last “Name”
96
iPlus (Ver. 2.1)-VII

