AccessTutorial 2 – Flashcards

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.

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

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

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

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

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

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?

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

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?

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

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

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

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

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

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

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

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

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.

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

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

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

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

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?

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

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

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

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

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

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

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

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.

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?

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?

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?

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?

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?

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

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

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?

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

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?

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

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