
Access Database Quiz
Quiz
•
Computers
•
8th Grade
•
Practice Problem
•
Medium
sravani sunkara
Used 6+ times
FREE Resource
Enhance your content in a minute
40 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
What is a query in Access primarily used for?
Storing data permanently
Displaying and filtering specific information from tables
Designing user interfaces
Backing up the database
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a relational database, a primary key in one table and a foreign key in another table are used to:
Encrypt data
Establish a relationship between tables
Normalize a table
Create a backup
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which tab in Access would you use to create or edit relationships between tables?
Home
Relationships
Design
View
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In a relation, the field used to join two tables is typically:
A non-key field
The foreign key only
A matching field such as Roll_No
A calculated field
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Which of the following statements about a foreign key is true?
It is always the primary key in the same table
It must match the primary key in another table
It can be any random value
It cannot be indexed
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
In Design View of a query, what is the purpose of the Show row?
To specify which tables are displayed in the query results
To select fields that should be visible in the output
To set sorting order for the results
To enter criteria for filtering
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Criteria in a query design grid are used to:
Determine the color of the output
Specify the condition to filter records
Add new fields to the table
Create relationships
Create a free account and access millions of resources
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
40 questions
TSDE Final Exam Review
Quiz
•
8th Grade
40 questions
Prof Comm Final Exam Review
Quiz
•
8th Grade
38 questions
Vivir en linea y ciudadanía digital
Quiz
•
5th - 9th Grade
35 questions
MYE Revision 7 & 8
Quiz
•
7th - 8th Grade
38 questions
SCRUM
Quiz
•
8th - 9th Grade
45 questions
Computer Architecture : Basic
Quiz
•
8th - 10th Grade
37 questions
Banana Tales - CodeMonkey
Quiz
•
6th - 8th Grade
35 questions
Computer Parts and Accessories
Quiz
•
7th Grade - Professio...
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
