Level 1
What is the file extension of MS Access?
.accdb
What does a table store?
Data
Data type for money?
Currency
Data type for auto ID?
AutoNumber
Data type for dropdown list?
Lookup & Relationship / Lookup Wizard
Example of primary key?
StudentID
Well designed interface to enter data is?
Form
Query that updates data?
Update Query
Unique identifier in table?
Primary key
View used to design table?
Design View
Example of DBMS?
MS Access / My SQL
Database is a collection of?
Tables
Query means asking a?
Question
Tab contain option for creating query?
Create Tab
Printed Receipts are an example of which database object?
Reports
Which object makes data entry easier?
Form
SQL Stands for?
Structured Query Language
What option is selected to create form in create tab?
Form Wizard
Links Tables?
Foreign Key
Write types of relationships in MS Access in order.
One to One
One to Many
Many to Many