Access Tutorials 1-4

Your page rank:

Total word count: 1242
Pages: 5

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

True/False: A database or a relational database is a collection of related tables.

True

true/False: The query results are stored in the database in which the query has been created.

False

true/False: A question asked about the data stored in a database is called a primary key

False

True/False: Access report printing options may be changed using the Navigation dialog box.

False

True/False: The number of the currently selected record in a table and the total number of records in the table are displayed in the Current Record box which appears between the two sets of navigation buttons on a datasheet.

True

True/False: Each record in a table is uniquely identified by a foreign key.

False

True/False: The only option available for creating tables in Access is to use the datasheet view.

False

True/False: A table is a predesigned database that includes professionally designed database objects

False

True/False: A query is used to enter, edit, and view records in a database.

False

True/False: A single characteristic or attribute of a person, place, object, event, or idea is a(n) table.

False

True/False: Relationship integrity is a set of rules used by Access to maintain consistency between related tables when data in either table is updated.

False

True/False: Access does not require a table to have a(n) primary key.

True

True/ False: Access does not allow data to be imported from sources other than another Access database.

False

True/False: Access does not require a field description for every field included in a table.

True

True/False: The Data Type Gallery, which allows the entry of groups of fields using the Quick Start selection, is only available in Datasheet view.

True

True/False: Data redundancy should be avoided because it wastes storage space and might cause inconsistencies within the database.

True

True/False: In order to define table relationships, each table being joined must contain a common field.

True

True/False: A key or combination of keys that complete an action more efficiently than using the mouse is called a(n) keyboard shortcut.

True

True/False: The field name displayed in database objects, including forms and reports, is determined by the Caption property.

True

True/False: All fields in a database should be contained in one table.

False

True/False: Hiding a field in Datasheet view removes the field from the current table.

False

True/False: Changes made to a field in a query datasheet updates the same field in the table on which the query is based.

True

True/False: A sort field is unique if more than one record can have the same value for the sort field.

False

True/False: The process of rearranging records in a specified order or sequence is referred to as sorting.

True

True/False: It is not possible to create a query from more than one table.

False

True/False: Expression Builder is found in the Query Setup group on the DESIGN tab.

True

True/False: It is more efficient to use the Query Wizard for common, informational queries than to design your own query.

False

True/False: Access may base queries on one or more tables or queries.

True

True/False: The contents of query datasheet are permanent.

False

True/False: Results of a query are narrowed by using the Or logical operator.

False

True/False: Layout view shows both the form and its data while allowing the form to be modified.

True

True/False: A form created from more than one table uses the primary table for the main form.

True

True/False: Report fields and field value boxes may be repositioned while viewing the report in Layout view.

True

True/False: When using a wildcard character in the Find and Replace dialog box, it is necessary to select the Any Part of Field Match option.

False

True/False: The default arrangement for data in a report created from two or more tables or queries is that data is grouped by field.

False

True/False: A form’s object name appears on the tab for the form in the Access window.

True

True/False: The Tabular and Justified form report layouts display the fields from multiple records at one time.

False

True/False: Field values edited in Form view are also changed in the form’s underlying table.

True

True/False: A form layout is a set of controls grouped together in a form or report that can be manipulated as a single control.

False

True/False: When a form is created based on two or more tables, a relationship must be defined between queries.

False

Provides options for creating various database objects, including tables, forms, and reports. The options appear on the tab grouped by object type.

Create Tab

A question you ask about the data stored in a database.

Query

A formatted printout (or screen display) of the contents of one or more tables (or queries) in a database.

Report

Lists all the objects (tables, reports, and so on) in the database, and it is the main control center for opening and working with database objects

Navigation Pane

Provides information about the program or open file, as well as buttons for working with the file.

Status Bar

Displays the table’s contents in rows and columns, similar to a table that you create in a word document or an excel spreadsheet.

Datasheet

Provides the main Access commands organized by task into tabs and groups.

Ribbon

Exists between two tables when one record in the first table matches zero, one, or many records in the second table, and hen one record in the second table matches at most one record in the first table.

One-to-Many Relationship

The "one" table in a one-to-many relationship.

Primary Table

The "many" table in a one-to-many relationship.

Related Table

Allows you to define or modify a table structure or the properties of the fields in a table

Design View

When defining the fields in a table, you can move from the Table Design grid to the Field Properties pane by pressing the ________.

F6 Key

You can use the _________ to enter an optional description for a field to explain is purpose or usage.

Description Property

A field Description property can be up to _____ characters long.

255

A criterion, or rule, that determines which records are selected.

Condition

Asks Access to compare the value in a field to the condition value and to select all the records for which the condition is true.

Comparison Operator

A collection of related tables

Database

A collection of related records

Table

A collection of related fields

Record

An attribute of data that describes a person, place, object, event, or idea.

Field

What are the four field naming guidelines?

No Spaces Capitalize the first letter of each word Abbr whn appr n nec Break into smallest part

What are the 8 data types?

Short Text Long Text Number Date/Time Currency AutoNumber Yes/No Hyperlink

Allows field values containing letters, digits, spaces, and special characters. Use for names, addresses, descriptions, and fields containing digits that are not used in calculations.

Short text

Allows field values containing letters, digits, spaces, and special characters. Use for long comments and explanations.

Long text

A set of rules that Access enforces to maintain consistency between related tables when you update data in a database.

Referential Integrity

What are the 5 aggregate functions?

Average, Count, Max, Min, Sum

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending