Vision -Our vision is to strive to become a safe learning environment that respects discipline and builds a strong character

in coope ration with families and the community .

Mission - is to provide all students with a safe and supporting environment based on integration of technology, and with a curriculum t hat is rich and challenging which respects learning differences. We strive for
our students to be professional global citizens.

Computer Department
Revision Sheets

Academic year 2022- 2023

Date: / / Week: 11 Month: November
Grade: 8 Duration: from ----------- to -----------------
Objectives Revise the lessons included in the final exam

 Learner’s name:

 Grade: 8

 Class:

5 of 1Page
II. Choose the correct answer:
answer.
1. Ascending means sorting from:
a. Smallest to largest
b. Largest to smallest
2. You specify data types when adding……………………...
a. records to a table
b. Data integrity to a database
c. fields to a table
d. data to a database
3. Every record must have a different ……………………...value in a table.
a. data integrity
b. foreign key
c. primary key
d. field
4. You have a table that holds names and phone numbers for 1000 people. How many
records are there?
a. 2
b. 1000
c. 2000
d. 0
5. A store tracks suppliers and inventory in a database. Which of the following would be a
field in the supplier table?
a. inventory cost
b. phone number
c. amount in stock
6. A database contains a customer table.
What would be stored in a record of the customer table?
a. information about the order
b. information about one customer
c. information about all the customers
d. information about every order
7. Why does data inside a database need to be organized?
a. so data integrity can be maintained
b. so the data is nice and tidy
c. so the data can be searched from the internet
d. so the data can be found when needed

5 of 2Page
8. Which of the following is an easy way to enter and browse data in a large database?
a. Forms
b. Tables
c. Spreadsheets
d. Records
9. Which data type would you choose for a field if you wanted to enter data like "small",
"medium" and "large" in the field?
a. currency
b. number
c. date/time
d. text
10. Data can be entered into the datasheet view, but it can be easier to use a ……….. instead?
a. primary key
b. field
c. form
d. record
11. What is the advantage of a reports over queries?
a. queries can be formatted
b. reports can be formatted
c. reports can access more data
12. What is it called when you "ask the database a question"?
a. Query
b. Data integrity
c. Relationship
d. Report
13. A primary key field from one table appears in a second table.
What is the field in the second table called?
a. The tables are in a duplication
b. The tables are subordinated
c. The tables are in a relationship
d. The tables are queried
14. What is it called when you view some records and hide others?
a. Sort
b. Search
c. Filter
d. Report
15. Client Name is an example of a ………………..
a. Field/Attribute Name
b. Record

5 of 3Page
 16. Each item from this list (name, birthdate, social security no., street, city, state, zip) is
classified as..................
a. table
b. record
c. field/Attribute Name
d. Data Type
17. Uniquely identifying a record is…………………………..
a. Foreign Key
b. Primary Key
c. Secondary Key
18. A ……………………is a question you ask about data stored in a database.
a. report
b. filter
c. search
d. query
19. Which of the following is NOT data type?
a. Date/Time
b. Short Text
c. Long Text
d. Formula

III. True or false:

answer.

20. In a database table, data is stored in rows and columns—similar in appearance to a

spreadsheet. ( )
21. Filtering is when you organize data alphabetically or in numerical order. ( )
22. Field is a list of records. ( )
23. A number field uses digits only. ( )
24. The currency field is exactly like number fields, but formatted to display decimal places
and a currency symbol. ( )
25. The best data type to choose for a postcode would be text. ( )
26. The best data type to choose for date of birth would be Date/Time. ( )

5 of 4Page
27. To rename a table or other database object, first save it. ( )
28. A complete list of field properties is available in design view. ( )
29. Input mask field property requires users to enter data in a specific format such as a
telephone number. ( )
30. Primary key is a unique identifier used in creating a table that assures there will be no
duplicate data. ( )
31. A query is a cell in the database. ( )
32. Design view is the grid containing columns and rows where you add, edit, and delete
records in an Access database table. ( )
33. Hospitals uses database. ( )
34. Datasheet view is where you configure the field properties of a Table. ( )
35. Numeric data type stores data in a Yes/No or True/False format. ( )
36. Query datasheet view is where you can see the results of a Query. ( )
37. AutoNumber automatically adds a unique number to the primary key field for each record
in the table. ( )
38. File is a valid a valid database object. ( )
39. Table is a series of rows and columns that organize data effectively. ( )
40. A Primary Key is a code that uniquely identifies a field in a Database. ( )
41. A database is a computerized filing system that is used to organize and maintain a
collection of information for future use. ( )
42. A database and a table is the same thing. ( )
43. Database forms are computerized versions of paper forms, such as a patient record, job
application or a class registration form. ( )
44. Descending is to sort from the smallest to the largest (from A to Z and 0 to 9). ( )
45. Query is a question which is used to search for specific information in the tables. ( )
46. Microsoft Access is a version of a Database Management System. ( )
47. Any list you make for a specific purpose can be considered a simple database, even a
grocery list. ( )

5 of 5Page