Apprentice
What is a record in a table?
A) A column
B) A set of related information in one row
C) A sound file
D) A file name
B) A set of related information in one row
What is Microsoft Access used for?
A) Making presentations
B) Editing videos
C) Creating databases
D) Drawing pictures
C) Creating databases
What is a table in Access?
A) A chart
B) A collection of data arranged in rows and columns
C) A list of photos
D) A button on the screen
B) A collection of data arranged in rows and columns
What button do you click to create a new table in Access?
A) Save
B) Table Design
C) Print
D) Undo
B) Table Design
What do we call a question we ask the database to find information?
A) Picture
B) Report
C) Query
D) Chart
C) Query
What is a field in a table?
A) A group of tables
B) One row of data
C) A single piece of information like “Name” or “Age”
D) A part of a keyboard
C) A single piece of information like “Name” or “Age”
What is a primary key used for?
A) To make the font bold
B) To identify each record uniquely
C) To delete a table
D) To change the background color
B) To identify each record uniquely
What is the name of the view where you design a table?
A) Table View
B) Layout View
C) Design View
D) Print View
C) Design View
Can you have two records with the same primary key?
A) Yes
B) No
C) Only in queries
D) Only in reports
B) No
What do we call the process of connecting two tables in Access?
A) Linking
B) Combining
C) Relating
D) Relationship
D) Relationship
Which of these is a data type in Access?
A) Rectangle
B) Number
C) Slide
D) Letter
B) Number
How do you show records where "Marks" is greater than 50 in a query?
A) <50
B) 50
C) >50
D) =50
C) >50
What is a query in Microsoft Access used for?
A) Drawing tables
B) Sorting alphabetically
C) Entering data
D) Searching/filtering data
D) Searching/filtering data
What is one difference between Design View and Table View?
A) Design View shows photos
B) Table View is only for queries
C) Design View is used to enter data
D) Design View is used to define field structure
D) Design View is used to define field structure
What happens if you try to enter a duplicate primary key?
A) It deletes your table
B) Access allows it
C) Access shows an error
D) It creates a new record
C) Access shows an error
How do you set a primary key in Design View?
A) Click Save, then Close
B) Select field and click “Primary Key”
C) Use the Sort button
D) Enter a query first
B) Select field and click “Primary Key”
Why are relationships useful in databases?
A) To save images
B) To reduce data duplication and keep data linked
C) To store passwords
D) To lock the table
B) To reduce data duplication and keep data linked
Why should we create relationships between tables?
A) To enter text data
B) To remove tables
C) To connect data and reduce duplication
D) To speed up the computer
C) To connect data and reduce duplication
If "Students" has StudentID as a primary key, and you want to connect it to "Subjects", what do you do?
A) Add StudentID to Subjects and create a relationship
B) Use SubjectID as primary key
C) Create a report
D) Change all IDs to the same value
A) Add StudentID to Subjects and create a relationship
How can you create a one-to-many relationship?
A) Copy and paste tables
B) Add both primary keys in one table
C) Connect primary key to foreign key
D) Use the Table View
C) Connect primary key to foreign key
What does a foreign key do in a table?
A) It creates a new table
B) It identifies records in the same table
C) It links to a primary key in another table
D) It sorts the records alphabetically
C) It links to a primary key in another table
What does a one-to-many relationship mean?
A) One database has many queries
B) One table is copied many times
C) One record in a table is related to many records in another
D) Many tables have the same name
One record in a table is related to many records in another
In a query, what does the “criteria” row help you do?
A) Enter a new table
B) Set conditions to filter data
C) Print the results
D) Save the file
Set conditions to filter data
Which of the following is the correct order to create a table in Design View?
A) Add data → Set primary key → Choose table name
B) Add fields → Set data types → Set primary key
C) Print table → Run query → Save
D) Enter queries → Add rows → Save
B) Add fields → Set data types → Set primary key
Why is it helpful to use queries instead of searching manually in a table?
A) Queries delete extra records
B) Queries make the table more colorful
C) Queries help find specific data quickly
D) Queries rename the table
C) Queries help find specific data quickly