Accounting
Anthropology
Archaeology
Art History
Banking
Biology & Life Science
Business
Business Communication
Business Development
Business Ethics
Business Law
Chemistry
Communication
Computer Science
Counseling
Criminal Law
Curriculum & Instruction
Design
Earth Science
Economic
Education
Engineering
Finance
History & Theory
Humanities
Human Resource
International Business
Investments & Securities
Journalism
Law
Management
Marketing
Medicine
Medicine & Health Science
Nursing
Philosophy
Physic
Psychology
Real Estate
Science
Social Science
Sociology
Special Education
Speech
Visual Arts
Design
Q:
Complete the design of the payment table in rental.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the customer table in rental.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.
Q:
Plymouth Car Rental started with two compact cars and has expanded its fleet of vehicles with several sedans, and trucks. When a customer books a rental, his/her age has to be at least 18 for compact cars and sedans, which are rented by the day and must be returned the following morning by 11 AM. Trucks are rented for a maximum of six hours. The owner requires a deposit on the reservation to be paid within seven days of booking. Vehicle records consist of the makes and types (Honda sedan), color, seating capacity, required deposit, rental rate, and rental limit (in hours). Customer data consists of customer's names, addresses, phone numbers, and birth dates. Bookings identify the customer, vehicle, as well as the time rented and returned. There can be several payments up until the reservation date. Payments must reflect the payment status for each booking, including deposit, when the deposit was made, then each of the payments made, and when the entire payment was completed.For questions 82-86, please refer to the preceding paragraph.Complete the design of the booking table in rental.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.
Q:
Establish the relationships between the tables in quick_tax.mdb Microsoft Access database. Make sure to indicate the correct cardinality.
Q:
Complete the design of the employee table in quick_tax.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the job table in quick_tax.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.
Q:
Complete the design of the client table in quick_tax.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.
Q:
In Microsoft Access, a concatenated primary key is created in design view by _ all the component fields and clicking on __ button.
Q:
In Microsoft Access datasheet view of Employee table, the + sign in front of every employee record may be clicked on to show __.
Q:
In Microsoft Access Relationships window, the link between Employee and Job tables will show __ next to SSN in Employee table and __ next to SSN in Job table.
Q:
In Microsoft Access Edit Relationships window for Employee and Job tables, in order for the change in SSN in Employee table to be reflected in Job table, requires turning on __ check box.
Q:
In Microsoft Access Edit Relationships window, making sure that the values in the foreign key match the values in the primary key, requires turning on _ check box.
Q:
In Microsoft Access, the relationship between two tables is established by dragging the __ from the __ table onto the __ in the __ table.
Q:
In Microsoft Access, an invalid entry error text message for a particular field, can be specified in __ field property.
Q:
In Microsoft Access, Validation rule restricting area code field entries to either 603 or 802, would be specified as __.
Q:
In Microsoft Access, Validation rule restricting pay rate field entries to be between 10 and 15 dollars per hour, would be specified as __.
Q:
In Microsoft Access, validation rule restricting order quantity field entries to positive numbers, would be specified as __.
Q:
In Microsoft Access, Input Mask for easier data entry into the client table would most likely be provided for __ field.
Q:
In Microsoft Access, functions that can be used to automate tasks are called __.
Q:
Creating a table structure in Microsoft Access is done in __ view.
Q:
Microsoft Access database files have a(n) __ extension.
Q:
Microsoft Access user forms, designed for more convenient data entry, would be accessed from the main Access window using __ object.
Q:
__ field in the client table would most likely be the largest field in terms of size.
Q:
In Microsoft Access, from the standpoint of a user entering data into the client table, the most efficient way of implementing State field would be using __.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.In Microsoft Access, the most appropriate data type and size for Telephone field would be __.
Q:
In Microsoft Access, a social-security number field stored in __ data type would need at least __ characters.
Q:
In Microsoft Access, hourly pay rate would be best represented as __ data type with __ decimals.
Q:
In Microsoft Access, a long distance phone number field stored in __ data type would need at least __ characters.
Q:
In Microsoft Access, forcing the removal of a record in the parent table to result in removal of all related records in the child table, is provided by which of the following?a) Enforce Referential Integrityb) Cascade Update Related Fieldsc) Cascade Delete Related Fieldsd) Change Join Type
Q:
In Microsoft Access, forcing a change on the primary key to also occur in the foreign key in a relationship, is provided by which of the following?
a) Enforce Referential Integrity
b) Cascade Update Related Fields
c) Cascade Delete Related Fields
d) Change Joint Type
Q:
In Microsoft Access, assurance that the values of primary and foreign key in a relationship will match, is provided by which of the following?
a) Enforce Referential Integrity
b) Cascade Update Related Fields
c) Cascade Delete Related Fields
d) Change Join Type
Q:
In Microsoft Access, inserting links between Client and Job tables, as well as Employee and Job table, establishes which other relationship?
a) One-to-one Client-Employee relationship
b) One-to-many Client-Employee relationship
c) Many-to-many Client-Employee relationship
d) No additional relationship is established
Q:
In Microsoft Access, after adding all three tables to the Relationships window, the link between Client and Employee tables is established by doing which of the following?
a) Dragging SSN field from Employee table onto Name field in Client table
b) Dragging SSN field from Employee table onto SSN field in Job table and dragging Email field from Client table onto Email field in Job table
c) Dragging SSN field from Employee table onto Email field in Client table
d) Nothing, there is no relationship between Client and Employee tables
Q:
In Microsoft Access, after adding all three tables to the Relationships window, the link between Employee and Job tables is established by doing which of the following?
a) Dragging SSN field from Employee table onto JobID field in Job table
b) Dragging JobID from Job table onto SSN field in Employee table
c) Dragging Email field from Client table onto Email field in Job table
d) Dragging SSN field from Employee table onto SSN field in Job table
Q:
In Microsoft Access, after adding all three tables to the Relationships window, the link between Client and Job tables is established by doing which of the following?
a) Dragging Email field from Client table onto JobID field in Job table
b) Dragging Email field from Client table onto Email field in Job table
c) Dragging JobID field from Job table onto Email field in Client table
d) Dragging SSN field from Employee table onto SSN field in Job table
Q:
In the relationship between Employee and Job tables, which of the following fields in Job table is the foreign key?
a) JobID
b) Email
c) SSN
d) Date
Q:
In the relationship between Client and Job tables, which of the following fields in Job table is the foreign key?a) JobIDb) Emailc) SSNd) Date
Q:
In Microsoft Access, data is entered into a table using which of the following?a) Design viewb) Datasheet viewc) Report viewd) Query grid
Q:
In Microsoft Access design view of the client table, the primary key would be specified by doing which of the following?
a) Clicking on email row and pressing magic wand button
b) Clicking on email row and pressing yellow key button
c) Clicking on phone row and pressing yellow key button
d) Clicking on email row and pressing lightning index button
Q:
In Microsoft Access, Expression Builder uses which of the following to help build correct expressions?
a) Functions
b) Constants
c) Operators
d) All of the above
Q:
In Microsoft Access, validation rule for State field with Text(2) data type in the client table, would most likely be which of the following?
a) "states"
b) "NH"
c) "NH" Or "VT"
d) "NH" And "VT"
Q:
In Microsoft Access, which one of the following is used to save sets of instructions for retrieving database data?
a) Queries
b) Forms
c) Macros
d) Modules
Q:
In Microsoft Access, which of the following is used to create interactive screens that allow end user's to work with database data.
a) Queries
b) Forms
c) Macros
d) Modules
Q:
In Microsoft Access, stored procedures written in Visual Basic that can be used to automate tasks are created using which of the following?
a) Queries
b) Forms
c) Macros
d) Modules
Q:
In Microsoft Access, the functions that can be used to automate tasks are created using which of the following?
a) Queries
b) Forms
c) Macros
d) Modules
Q:
In Microsoft Access creating a table structure is accomplished using which of the following?
a) Form view
b) Query grid
c) Datasheet view
d) Design view
Q:
In the Microsoft Access main database window, which of the following is used for creating questions and getting answers out of the database?
a) Tables
b) Queries
c) Forms
d) Reports
Q:
Which of the following best describes the process of creating a database in Microsoft Access?
a) Specifying database file, designing tables, and entering data
b) Specifying database file, entering data, and designing tables
c) Designing tables, entering data, and specifying database file
d) Entering data, specifying database file, and designing tables
Q:
In Microsoft Access, in order to create a new empty database, which of the following option would be used?
a) New blank database
b) New from template
c) New from existing file
d) Open a file
Q:
The most appropriate candidate for the primary field in the client table would be which of the following?
a) Email
b) Zip Code
c) Telephone
d) Name
Q:
In Microsoft Access, the most appropriate data type and size for State field would be which of the following?
a) Text(2)
b) Text(20)
c) Text(30)
d) Memo
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients.In Microsoft Access, the most appropriate data type and size for Email field would be which of the following?a) Text(2)b) Text(20)c) Text(30)d) Memo
Q:
In Microsoft Access, the most appropriate data type to store a link to supplier's Web site would be which of the following?a) Textb) OLE Objectc) Hyperlinkd) Lookup Wizard
Q:
In Microsoft Access, the most appropriate data type for a field indicating whether the order has been shipped or not would be which of the following?
a) Text
b) Yes/No
c) OLE Object
d) Lookup Wizard
Q:
In Microsoft Access, setting up a state or city field in the customer table for a database user to choose from would be best accomplished using which of the following data types?
a) Text
b) Yes/No
c) OLE Object
d) Lookup Wizard
Q:
In Microsoft Access, each consecutive order number could be automatically assigned with each new order using which of the following data types?
a) Number
b) Currency
c) AutoNumber
d) Date/Time
Q:
In Microsoft Access, the most appropriate data type to store product pictures is which of the following?
a) Text
b) Memo
c) OLE Object
d) Hyperlink
Q:
In Microsoft Access, the most appropriate data type to store product descriptions is which of the following?
a) Text
b) Memo
c) OLE Object
d) Hyperlink
Q:
In Microsoft Access, in order to remove the table from the database, any relationships with other tables have to be deleted first.
Q:
In Microsoft Access Edit Relationships window for two related tables, there is an option for changing the cardinality of the relationship.
Q:
In Microsoft Access Edit Relationships window for Client and Job tables, the Relationship Type status at the bottom of the window would read Many-To-Many.
Q:
In Microsoft Access Edit Relationships window, if Cascade Delete Related Fields is checked, deleting an employee from primary table would result in removal of all jobs performed by that employee in Job table.
Q:
In Microsoft Access Edit Relationships window, if Cascade Update Related Fields is checked, a change in Email address in Client table, would result in changes for all corresponding Email values in Job table.
Q:
In Microsoft Access Relationships window, there is a direct link between Client and Employee tables.
Q:
In Microsoft Access, the relationship between two tables is established by dragging the primary key from the parent table onto the foreign key in the child table.
Q:
For years, QuickTax, Inc. has helped small businesses manage their taxes. The management wants a database to keep track of clients, employees, and jobs. Managers need to keep track of client names, addresses, contact persons, phone numbers, and email addresses. They also need to track the employee's social security numbers, names, and birth dates. Also, the company needs to be able to keep track of the data on each job an employee performs for each of their clients. In Microsoft Access, the link between Employee and Job tables is established by dragging SSN field from the Employee table onto JobID field of the Job table.
Q:
In Microsoft Access, "Email Address" entered into the Caption property of Email field would appear as a label for Email field in datasheet view.
Q:
Symbols such as =, >, <, >= and <= are all examples of arithmetic operators.
Q:
Symbols such as +, -, / and * are all examples of relational operators.
Q:
In Microsoft Access, the validation rule "NH" Or "VT" for State field in the client table contains one constant and two operators.
Q:
In Microsoft Access, the table status bar displays the number of a currently selected record, as well as the total number of records.
Q:
In Microsoft Access, Validation Rule field property is used to restrict entries for that particular field to a set of specific values.
Q:
In Microsoft Access, each Field Name in table design view will correspond to a record in table's datasheet view.
Q:
In Microsoft Access, if State field was defined using Text(2) data type, the most appropriate Default Value for the client table would be NH.
Q:
In Microsoft Access table design view, the field size of Text data type is one of several Field Properties.
Q:
In Microsoft Access, the best way to start creating a new table is by entering data in datasheet view.
Q:
In Microsoft Access, main database window contains a list of object tabs, starting with Tables used to design, populate and manage database tables.
Q:
In Microsoft Access, creating a blank database file for the above case involves starting Access and selecting File -> Open and choosing quick_tax.mdb file.
Q:
In Microsoft Access, the data type for Zip Code field would be Number.
Q:
Email field would be set as the primary field for the client table.