Delhi Public School Ghaziabad

Vasundhara
Subject – ICT
Grade – VIII
REVISITING WORKSHEET-2
Logon to Access, Working with Queries Forms and Reports
1. Multiple Choice Questions. Justify your answer with an example or
definition or syntax.
1. What is a database?
a) Organized collection of information that cannot be accessed, updated, and managed
b) Collection of data or information without organizing
c) Organized collection of data or information that can be accessed, updated, and
managed
d) Organized collection of data that cannot be updated
2. Which type of data can be stored in the database?
a) Image oriented data video
b) Text, files containing data d) All of the above
c) Data in the form of audio or
3. In which of the following formats data is stored in the database management system
a) Image c) Table
b) Text d) Graph
4. Which of the following is not a function of the database?
a) Managing stored data c) Security for stored data
b) Manipulating data d) Analysing code
5. Which of the following is a function of the DBMS?
a) Storing data c) Data Integrity
b) Providing multi-users access d) All of the above
control
6. What does an RDBMS consist of?
a) Collection of Records c) Collection of Tables
b) Collection of Keys d) Collection of Fields
7. A computerised record keeping system that provides the users with efficient and
reliable methods of data retrieval.

a) File system c) DBMS

b) Powerpoint Presentation d) All of the above
8. A database object that displays the selected data in a printable format
a) Query c) Report
b) Table d) Form
 9. What is the maximum number of characters that can be used to define a field name?
a) 62 c) 32
b) 64 d) 8
10. Which datatype has the largest storage capacity?
a) Short Text c) Memo
b) Long Text d) Text
11. What is an object in Access?
a. A type of query
b. A program used to create databases
c. A container for related data
d. A type of spreadsheet software
12. What is a field in Access?
a. A type of report
b. A single piece of information in a record
c. A type of query
d. A container for related records
13. Why would you want to create a report?
a. Reports allow you to export a table as an Excel file
b. Reports allow you to present tables and query results in an easy-to-read
format.
c. Reports make it easy to add records to a table.
d. Reports are used to add data collection fields to forms.
14. What is a relationship in Access?
a. A connection between two tables based on common fields
b. A macro that automates database tasks
c. An object used to display data in a user-friendly way
d. A report generated from a query result
15. What is sorting in Access used for?
a. To filter records based on certain criteria
b. To delete records from the database
c. To backup the database
d. To arrange records in a specific order
16. What is a filter in Access used for?
a. To select a subset of records based on certain criteria
b. To rename fields in a table
c. To create a backup of the database
d. To arrange records in a specific order
17. What is the purpose of a wildcard character in a query?
a. To calculate a field based on the values of other fields
b. To represent any character in a search string
c. To sort records in ascending or descending order
d. To search for records containing a specific value
18. Suppose you run a query, and a dialog box appears asking you to enter a date. You are
most likely working with a ________ query.
a. date & time
b. parameter
c. totals
d. dialog
19. State whether true/false
 a. In order to save changes to a database, you must save the objects individually.
b. Access only allows one sort per query.
c. A database can be shared with different group of users.
d. In a database, the details of a record once entered cannot be modifed.
20. Which of the following best describes a query?
a. A list of settings that controls who can edit the database
b. Data resulting from questions you ask of one or more tables
c. A formatted summary of data suitable for printing
d. A user-friendly interface for entering and viewing data
21. What is a record in Access?
a. A type of query c. A type of report
b. A container for related d. A collection of related
tables fields
22. Information is the processed and meaningful form of
a. Record c. Field
b. Data d. Relation
23. Which of the following field name is valid
a. Students’Name c. Passes!
b. Bio-data d. Photography

2. State whether the following are True/ False.

1. When you enter information into a form the data goes exactly where you want.
2. Forms and tables use different data.
3. An Access template helps in creating a complete database application, which is ready
to use.
4. Toggle filter button is located in the Sort and Filter group.
5. It is not essential to specify a datatype for a field name.
6. A report is created exactly in the same way as forms are created.
7. A relationship works by matching a field with the same name in two tables.
8. Once a relationship is set, it cannot be deleted.
9. The sort property is used to filter the data either in an ascending order or descending
order.
3. Fill in the blanks (All questions carry 1 mark each)

1. Access is generally used to work with ________ databases.

2. _____________ are used for entering, modifying and viewing records
3. A ________________ is a database object that helps you to retrieve and view
information from one or more database tables.

4. You must set multiple criteria in a query using _____________________ property.

5. ________________ allows you to add and update data in a table, one record at a time.
6. A type of database object that provides user friendly interface to facilitate the data
entry process _________________.
7. _______________ are pre-built database that focus on a specific task.
8. A _________________ key is a sort of a check on the table that every record in the
table is unique.
9. The ______________ generate a sequential number, whenever a new record is added
to table.
10. Row of a table is called as _____________ and column of a table is called as
________.
11. _______________ collects the summarised data from one or more tables/ queries and
organise it in a printable format.
12. Aditi is creating a table to store Student’s details. Which property should she use for
the fields to ensure that they are not left blank during data entry?
13. ____________ query prompts you for input before it runs.
14. ____________ allows you to add and update data in a table, one record at a time.
4. Subjective Questions
1. Name any two of the popular database management systems in use. (1)
2. Which view allows more control over the table structure? (1)
3. What is a validation rule and validation text in MS-access? (1)
4. Write any two differences between a file and a database? (2)
5. What do you understand by Criteria? Explain with an example. (2)
6. Shruti created a table of Employees in her organisation with 50 records. She must
show details of employees having salary greater than Rs.50000 to her boss. Suggest
the object of database which she can use and the criteria she must apply to show these
records. (2)
7. In how many ways can you work on a table in MS Access? Name them. Also explain
how you can switch to different views.
(3)
8. Arrange the steps in order to create a database (3)
a) A new database will be created along with an empty table named Table1
b) Open MS Access from the start button
c) Choose a location to save the database. Click on the Create button
d) Click on the Blank Database option.
e) The Blank database window opens with a default name Database1.
9. A Bank Account table with following fields must be created in the Database namely
Bank. (3)
Field Name Description
Customer_Id The unique identifier for a customer
Account_Number The unique identifier for a customer
Account_Type The type of account(Current, Savings, etc.)
Date_Opened The date on which the account was opened
Balance The current balance of the account

Answer the following questions

a) Which field can be set as the primary key?
b) What will be the size of the Date_Opened field?
c) What will be the datatype of the field Balance?
10. Let's say our bakery wants to create a list of customer names and email
addresses for customers who pre-ordered an item and picked it up during the
month of December. The tables needed for the query are shown in this image. Apart
from First Name and Last Name, what fields must be added to the query? Select all
that apply. (3)
[Link] two differences between flat file database and Relational Database.

ANSWERS:
Multiple Choice Questions (With Justification)
1. c) Organized collection of data or information that can be accessed, updated,
and managed
Justification: A database is an organized collection of related data that allows easy
access, modification, and management.

2. d) All of the above

Justification: Databases can store text, images, audio, video, and files.

3. c) Table
Justification: In a DBMS, data is stored in tables consisting of rows (records) and
columns (fields).

4. d) Analysing code
Justification: A database manages data, not programming code.

5. d) All of the above

Justification: DBMS stores data, allows multiple users, and maintains data integrity.

6. c) Collection of Tables
Justification: An RDBMS stores data in related tables.

7. c) DBMS
Justification: DBMS provides efficient storage and retrieval of data.

8. c) Report
Justification: A report presents selected data in a printable format.

9. b) 64
Justification: In MS Access, a field name can have up to 64 characters.
 10. b) Long Text
Justification: Long Text (Memo) stores large amounts of text (up to 65,536
characters).

11. c) A container for related data

Justification: Objects like tables, queries, forms, and reports store related data.

12. b) A single piece of information in a record

Justification: A field represents one type of data (e.g., Name, Age).

13. b) Reports allow you to present tables and query results in an easy-to-read
format.
Justification: Reports organize data neatly for printing or presentation.

14. a) A connection between two tables based on common fields

Justification: Relationships link tables using primary and foreign keys.

15. d) To arrange records in a specific order

Justification: Sorting arranges data in ascending or descending order.

16. a) To select a subset of records based on certain criteria

Justification: Filtering shows only records that meet certain conditions.

17. b) To represent any character in a search string

Justification: Wildcards like * represent unknown characters in queries.

18. b) parameter
Justification: A parameter query prompts the user to enter input before running.

19. True/False
a) True
b) False
c) True
d) False

20. b) Data resulting from questions you ask of one or more tables
Justification: A query retrieves specific data based on conditions.

21. d) A collection of related fields

Justification: A record is a row containing related fields.

22. b) Data
Justification: Information is processed and meaningful data.

23. d) Photography
Justification: Field names should not contain special characters like ! or ’.

2. True/False
1. True
2. False
3. True
 4. True
5. False
6. False
7. True
8. False
9. False

3. Fill in the Blanks

1. Relational
2. Forms
3. Query
4. AND/OR
5. Datasheet view
6. Form
7. Templates
8. Primary
9. AutoNumber
10. Record, Field
11. Report
12. Required property
13. Parameter
14. Datasheet view

4. Subjective Answers
1. MySQL, Oracle
2. Design View
3. Validation Rule: Restricts the type of data entered.
Validation Text: Message shown when wrong data is entered.

4. File vs Database (Any Two Differences)

File Database

Stores data separately Stores data in organized tables

No relationship Supports relationships

5. Criteria:
Criteria are conditions used to filter records.
Example: Salary > 50000

6.
Object: Query
Criteria: Salary > 50000

7.
Two ways: Datasheet View and Design View.
Switch using the View button on the Home tab.

8. Correct Order:
b→d→e→c→a
9. Bank Table
a) Customer_Id (Primary Key)
b) 8 bytes (Date/Time datatype)
c) Currency

10. Additional Fields Needed:

Email Address
Pre-Order Date
Pickup Date

11. Flat File vs Relational Database

Flat File Relational

Single table Multiple related tables

No relationships Uses relationships