Access Simplified Quiz

Access Simplified Quiz

8th - 12th Grade

10 Qs

quiz-placeholder

Similar activities

k12 bai4

k12 bai4

12th Grade

10 Qs

ICT as Social Change

ICT as Social Change

12th Grade

10 Qs

Excel - basic

Excel - basic

9th Grade

15 Qs

Cyber Security Homework 1

Cyber Security Homework 1

7th - 9th Grade

15 Qs

G8_Ch2_Windows Movie Maker

G8_Ch2_Windows Movie Maker

8th Grade

15 Qs

Kuis Dadakan ;)

Kuis Dadakan ;)

10th Grade - University

15 Qs

Паскаль. Основные команды

Паскаль. Основные команды

8th - 11th Grade

10 Qs

Kiểm tra giữa kỳ 1 Tin 8

Kiểm tra giữa kỳ 1 Tin 8

8th Grade

15 Qs

Access Simplified Quiz

Access Simplified Quiz

Assessment

Quiz

Computers

8th - 12th Grade

Practice Problem

Hard

Created by

Kiprotich Lang'at

Used 16+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

10 questions

Show all answers

1.

MULTIPLE SELECT QUESTION

20 sec • 1 pt

Select the four main objects that comprise an Access database.

Charts

Reports

Tables

Forms

Queries

2.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Access is generally used to work with ________ databases.

non-relational

single-row

absolute

relational

3.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

True or False: In order to save changes to a database, you must save the objects individually?

True

False

4.

MULTIPLE SELECT QUESTION

30 sec • 1 pt

Media Image

Let's say our bakery wants to create a list of customer names and email addresses for customers who pre-ordered an item and picked it up during the month of


December. The tables needed for the query are shown in this image. Aside from First Name and Last Name, what fields must be added to the query? Select all that apply.

Pickup Date

Email

Pre Order

City

5.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Which of the following best describes a query?

Data resulting from questions you ask of one or more tables

A list of settings that controls who can edit the database

A formatted summary of data suitable for printing

A user-friendly interface for entering and viewing data

6.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

True or False: Access only allows one sort per query?

True

False

7.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Media Image

Suppose you created the query shown in this image, but later you realize that you really wanted to find the total number of cakes sold instead of cookies. What is the best way to solve this problem?

Switch to Design View and edit the criteria

Delete the query and re-create it

Edit the table relationships

Use the Find feature to search for Cake

Create a free account and access millions of resources

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?