Computers II Office Access Quizizz

An Access table has vertical columns that are called "fields", that hold different types of information; and their horizontal rows are called "__________", that are assigned a unique ID number that cannot be changed.

• lines

• graphs

• records

• bars

The Datasheet Formatting dialog box launcher is located in the Home tab, then in lower right-hand corner of the ________ ________ Group, which gives options how your datasheet is viewed.

• Sort & Filter

• Text Formatting

• Records

• Find

Running a ________, which is asking your database a question, can retrieve data from a single table or multiple tables.

• form

• graph

• query

• list

A simple query, which refers to one table of all your databases, is created by going to the __________ Tab, and select the Query Design Command.

• Create

• View

• File

• Home

More than one table in a query will be connected by a line called a ___________, which has arrows pointing left or right to show the query which table to look a first.

• Chain

• Coupler

• Link

• Join

A multi-level sort will always sort from what direction?

• Left to Down

• Right to Middle

• In and Out

• Left to Right

When Adding Tables to a Query and viewing in the Design Tab, Tables connected by directional Joins are shown in the ___________ ____________ Pane.

• Table Squares

• Objects Relationship

• Arrow Boxes

• Filter Rectangles

In Design View, the __________ Grid shows rows to fill with information for your query, such as Field, Table, Sort, Show, Criteria, and Or.

• Create

• View

• File

• Design

While in Design View and using the Design Grid, to apply Equal results in the Criteria row, the Syntax (code for a word search) must be set apart by _____________ (" x "). Adding an astrix (*) to the Syntax will add a similar but not identical to the search.

• Hyphens

• Apostrophes

• Colons

• Quotations

The ____________ __________ holds an list of Tables, Queries, Forms, Reports, Macros and Modules, which when chosen, open a tab at the top of your page below the Ribbon.

• Object Relationship Pane

• Navigation Pane

• Window Pane

• Chronic Pane