AccessTutorial 2

Your page rank:

Total word count: 1846
Pages: 7

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

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

delimited

A database management system is a useful tool only if it meets which of the following criteria?

meets the needs of its users

Relationship integrity is a set of rules used by Access to maintaain consistency between related tables when data in either table is updated.

False

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

True

When choosing field names, it is best to choose names that ____.

describe the content or purpose of the field

A database system determines how to store, display, and process field values based on which of the following?

field properties

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

After printing a report of parent information for camper pick-up monitors, Santana decides some of the field names displayed on the report are hard to read. For example, she prefers the field MotherMobilePhone to be displayed as Mother Cell on the report. Which field property should be changed to modify the field name display on the report?

Caption

Which of the following is the most logical data type to use if a field will contain long comments or explanations?

Long Text

Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions.

Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?

store data for each field in only one table (excluding the common field)

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

Format

A field used to connect one table logically with another table is called a ____ field.

common

Access does not require a field description for every field included in a table.

True

A field in an Access database table that has no value is determined by Access to have a ____ value.

null

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

values

In the Database Design grid, press the Enter key to move from one property to the next property.

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

The ____ property allows the database designer to explain the purpose of a field or how a field is used.

Description

A relationship between Access tables that is a relationship between one record in the first table and zero, one, or many records in the second table, and at least one record in the second table matches at most one record in the first table, is defined as a(n) ____ relationship.

One-to-Many

A primary key that consists of two or more fields is called a(n) redundant key.

false

The ____ data type only allows a field length of 1 character and is used to indicate the presence or absence of a condition.

Yes/No

External data are data that are imported from a source other than the current database without having to open the source file.

True

Which data type allows both positive and negative numbers as field values?

Number

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

Several participants registered for activities late as other participants cancelled. These participants need to be added to the Participants table. What is the most expedient way to add these participants and their paid status to the Participants table?

import the data from the Excel spreadsheet into the Participants table

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

true`

All fields in a database should be contained in one table..

False

Which data type allows the designer to define the Field Size property?

AutoNumber

Which of the following would be a likely reason that an Import process from an Excel spreadsheet to an Access database might fail?

the Access field names and the Excel worksheet column headings do not match

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

True

The data type that allows both sequential and random numbering is the ____ data type.

AutoNumber

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

True

When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an "invalid syntax" error message.

True

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

Considering the table in the figure above, which data type is best suited for the ActivityStartTime and the ActivityEndTime fields?

Date/Time

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

Each parks and recreation employee must keep a copy of parent contact information for all campers with them at all times. Using the figure above, which two tables must have a relationship established to allow Leah to print a report of all campers and the their parents’ contact information?

Participants and Parents

Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database:
· artist
· song and year
· client name
· client address
· client contact information
· vendor
· purchases
· equipment
· equipment inventory and rental

Client contact information should include several fields. Which of the following field choices would allow client contact data to be separated into the smallest useful parts and provide Akae with the most options for contacting a client?

mobile number, home number, primary email address, secondary email address

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

Several participants registered for activities late as other participants cancelled. These participants need to be added to the Participants table. What is the most expedient way to add these participants and their paid status to the Participants table?

import the data from the Excel spreadsheet into the Participants table

Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions.

Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?

store data for each field in only one table (excluding the common field)

What is the default setting for the Field Size property for a field with the Number data type?

Long Integer

A value set in the Field Properties pane that appears in a field automatically is the ____ for the field.

default value

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

After printing a report of parent information for camper pick-up monitors, Santana decides some of the field names displayed on the report are hard to read. For example, she prefers the field MotherMobilePhone to be displayed as Mother Cell on the report. Which field property should be changed to modify the field name display on the report?

Caption

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

Yes/No

Interns Leah and Santana are organizing a summer camp for children ages 5-10 for their local recreation and parks agency. Participant and payment information is stored in an Excel spreadsheet as children are registered for activities. An Access database contains information about children (participants), parents, employees, as well as activity sessions and schedules. The database contains the following tables:
· Participant Information
· Parent Information
· Employees
· Activities

Considering the table in the figure above, which data type is best suited for the ActivityStartTime and the ActivityEndTime fields?

Date/Time

To begin importing data from an Excel spreadsheet, click on the ____ tab on the ribbon.

External Data

The default character length for the Short Text data type is ____ characters.

255

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