Page 48 - TP_Prime_V2.2_Class8
P. 48
b. The columns in a table represent _______________.
c. _______________ is used to define the type of data that can be entered in that field.
d. _______________ is used to enter the name of the field to be displayed as a column
heading in the table.
e. _______________ buttons are used to navigate through the records.
2. Short answer type questions.
Prime (Ver. 2.2)-VIII 3. Long answer type questions.
a. What is the process of adding and deleting the records from the database?
b. Write the names of any four data types of Access.
a. What are the advantages of the Database Management System?
b. Explain the types of views in a database.
c. What are the naming conventions for writing a field name in a database?
46
21 st
4. Competency-based/Application-based questions. Century #Information Literacy
Skills
a. Ranjeet is working on a school database. He wants to view all the records in sequential
order, either in ascending or descending order. Suggest a feature of Access that can help
him do this.
b. Neha is inputting data for a customer management database. What data types
should she use for fields like customer name, phone number, and registration
date?
Activity Time Century #Critical Thinking
21 st
Skills
Find six terms related to Access 2016 in the following grid:
P A B E A U T B D E Z L
R S N L S O M E M N D O
I M O O Z N L A D F A R
M T Q U E R Y L M L T Q
A L M S F E T O M Q A B
R Z Y U L P M T A Q B F
Y X L N M O S A L A A M
K S U V P R T B M R S Z
E L L O P T S L N F E A
Y M N F O R M E L Z Y B

