logo image

AccessTutorial 2

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

Need essay sample on "AccessTutorial 2"? We will write a custom essay sample specifically for you for only $ 13.90/page

Can’t wait to take that assignment burden offyour shoulders?

Let us know what it is and we will show you how it can be done!
×
Sorry, but copying text is forbidden on this website. If you need this or any other sample, please register

Already on Businessays? Login here

No, thanks. I prefer suffering on my own
Sorry, but copying text is forbidden on this website. If you need this or any other sample register now and get a free access to all papers, carefully proofread and edited by our experts.
Sign in / Sign up
No, thanks. I prefer suffering on my own
Not quite the topic you need?
We would be happy to write it
Join and witness the magic
Service Open At All Times
|
Complete Buyer Protection
|
Plagiarism-Free Writing

Emily from Businessays

Hi there, would you like to get such a paper? How about receiving a customized one? Check it out https://goo.gl/chNgQy

We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy