1) What is the main purpose of a database? a) To store and manage large amounts of data b) To create documents c) To send emails d) To analyse images 2) What is a table used for in a database? a) To store data in rows and columns b) To search for data c) To print information d) To link databases 3) What is a record? a) All the information about one item b) A single field c) A table name d) A data type 4) What is a field? a) A category of data b) A complete record c) A database object d) A validation rule 5) Why is a primary key used? a) To uniquely identify each record b) To sort data alphabetically c) To link queries d) To format tables 6) Which field would be best as a primary key? a) A unique ID number b) A surname c) A postcode d) A phone number 7) Which data type is most suitable for a phone number? a) Text b) Number c) Currency d) Yes/No 8) Why should a phone number not be stored as a number? a) It may start with 0 or include spaces b) It cannot be validated c) It takes up more space d) It cannot be printed 9) Which data type should be used for a postcode? a) Text b) Number c) Currency d) Date/Time 10) Which data type would be best for a price? a) Currency b) Text c) Number d) Date/Time 11) Why are forms used in databases? a) To make data entry easier b) To store data permanently c) To search records d) To calculate totals 12) Which database object is used to search for specific information? a) Query b) Table c) Form d) Report 13) What does a query allow the user to do? a) Retrieve selected records only b) Add new fields c) Change data types d) Format tables 14) Which object is best used for printing database information? a) Report b) Table c) Query d) Form 15) Why are reports used instead of tables for printing? a) They present data clearly and professionally b) They store data c) They allow editing d) They create relationships 16) Which view allows you to change the structure of a table? a) Design View b) Form View c) Datasheet View d) Print Preview 17) Which view allows you to enter and view data in a form? a) Form View b) Design View c) Layout View d) Print Preview 18) What is a relational database? a) A database with linked tables b) A database with one table c) A printed database d) A database without keys 19) Why are relational databases used? a) To reduce duplication of data b) To increase storage size c) To speed up printing d) To simplify layouts 20) What is used to link two tables together? a) A relationship b) A form c) A report d) A validation rule 21) Which fields are usually linked in a relationship? a) Primary key to foreign key b) Two text fields c) Two calculated fields d) Two reports 22) Why are relationships important in databases? a) They improve accuracy and consistency b) They improve spelling c) They increase font size d) They reduce file size 23) Why would you print a selected record? a) To print one record only b) To print all records c) To edit the record d) To delete data 24) Which print option should be chosen to print only one form record? a) Selected record b) All records c) Pages d) Print preview 25) What is the purpose of a form header? a) To display titles or logos b) To enter data c) To store records d) To validate fields 26) What is the purpose of a form footer? a) To add names, dates or totals b) To store data c) To search records d) To add fields 27) Why is a page footer added to a form or report? a) To include name and SCN on every page printed out. b) To enter data c) To create relationships d) To validate fields

N5 Admin & IT Access Databases

bởi
In
Nhúng

Bảng xếp hạng

Phong cách trực quan

Tùy chọn

Chuyển đổi mẫu

Bạn có muốn khôi phục tự động lưu: không?