Q&A Hero

Q: In Microsoft Access, the statement used to retrieve all of the client's names, sorted A to Z, with city, state, and zip code would be __.

Q: In Microsoft Access, the statement used to retrieve all of the client's contacts and emails would be ___.

Q: In Microsoft Access query design view, the __ row is used to select the columns to be included in the query.

Q: In Microsoft Access, the statement used to retrieve all of the data from the employee table would be ____.

Q: In Microsoft Access, the statement used to display employees' social security numbers and names that don"t have any jobs assigned to them, would be which of the following?a) Select Employee.SSN, Employee.Name From Job Where Employee.SSN Not In (Select Distinct Job.SSN From Job)b) Select Employee.SSN, Employee.Name From Job Where Employee.SSN Not In (Select Distinct Employee.SSN From Employee)c) Select Employee.SSN, Employee.Name From Employee Where Employee.SSN Not In (Select Distinct Job.SSN From Job)d) Select Employee.SSN, Employee.Name From Employee Where Employee.SSN In (Select Distinct Job.SSN From Job)

Q: __ operation combines data from two tables.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.For questions 60-81, please refer to the preceding paragraph.

Q: In Microsoft Access, the statement used to display employee and client names together with all of the job dates, sorted from earliest to latest, would be which of the following? a) Select Employee.Name, Client.Name, Job.Date From Employee Inner Join (Client Inner Join Job On Client.Email = Job.ID) On Employee.SSN = Job.ID Order by Job.Date b) Select Employee.Name, Client.Name, Job.Date From Employee Inner Join Client Inner Join Job On (Client.Email = Job.Email And Employee.SSN = Job.SSN) Order by Job.Date c) Select Employee.Name, Client.Name, Job.Date From Employee Inner Join Client On (Client.Email = Job.Email And Employee.SSN = Job.SSN) Order by Job.Date d) Select Employee.Name, Client.Name, Job.Date From Employee Inner Join (Client Inner Join Job On Client.Email = Job.Email) On Employee.SSN = Job.SSN Order by Job.Date

Q: In Microsoft Access, the statement used to display employee names together with job dates and times, for all jobs starting on either 3/12/06 or at 8 A.M., would be which of the following? a) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee.SSN = Job.SSN Where Job.Date = #3/12/06# And Job.TimeStart = #8:00 AM# b) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee.SSN = Job.ID Where Job.Date = #3/12/06# Or Job.TimeEnd = #8:00 AM# c) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee.SSN = Job.SSN Where Job.Date = #3/12/06# Or Job.TimeStart = #8:00 AM# d) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee, Job On Employee.SSN = Job.SSN Where Job.Date = #3/12/06# Or Job.TimeStart = #8:00 AM#

Q: In Microsoft Access, the statement used to display employee names together with job dates and times, for all jobs starting at 8 A.M., would be which of the following? a) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee.SSN = Job.SSN Where Job.TimeStart = #8:00 AM# b) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee.SSN = Job.SSN Where Job.TimeEnd = #8:00 AM# c) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job Where Job.TimeStart = #8:00 AM# d) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee, Job On Employee.SSN = Job.SSN Where Job.TimeStart = #8:00 AM#

Q: In Microsoft Access, the statement used to display employee names together with all of their job dates and times would be which one of the following? a) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee, Job Where Employee.SSN = Job.SSN b) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee.SSN = Job.SSN c) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee.SSN Inner Join On Job.SSN d) Select Employee.Name, Job.Date, Job.TimeStart, Job.TimeEnd From Employee Inner Join Job On Employee = Job

Q: In Microsoft Access, the statement used to calculate the number of clients from each NH zip code, labeled "Zip Clients", would be which of the following? a) Select ZipCode, Count(Email) From Client Group By ZipCode Where State != "NH" b) Select ZipCode, Count(Email) As "Zip Clients' From Client Group By ZipCode c) Select ZipCode, Count(Email) As "Zip Clients' From Client Group By ZipCode Where State = "NH" d) Select ZipCode, Count(Email) As "Zip Clients' From Client Group By ZipCode Where State Is "NH"

Q: In Microsoft Access, the statement used to retrieve all the jobs with JobID greater than 5 and less than 8, displaying only JobIDs and associated dates, would be which of the following? a) Select JobID, Date From Job Where JobID between 5 and 8 b) Select JobID, Date From Job Where JobID >5 And <8 c) Select JobID, Date From Job Where JobID >=5 and <=8 d) Select JobID, Date From Job Where JobID 5 and 8

Q: In Microsoft Access, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails end in "net", and who live in 03264 zip code? a) Select Contact, Email, ZipCode From Client Where Email Not Like "net" And ZipCode != "03264" b) Select Contact, Email, ZipCode From Client Where Email Like "*net" Or ZipCode = "03264" c) Select Contact, Email, ZipCode From Client Where Email Like "net" Or ZipCode = "03264" d) Select Contact, Email, ZipCode From Client Where Email Like "*net" And ZipCode = "03264"

Q: In Microsoft Access, which of the following statements would result in contacts, emails, and zip codes for the clients whose emails either end in "net", or who live in 03264 zip code? a) Select Contact, Email, ZipCode From Client Where Email Not Like "net" And ZipCode != "03264" b) Select Contact, Email, ZipCode From Client Where Email Like "*net" Or ZipCode = "03264" c) Select Contact, Email, ZipCode From Client Where Email Like "net" Or ZipCode = "03264" d) Select Contact, Email, ZipCode From Client Where Email Like "*net" And ZipCode = "03264"

Q: In Microsoft Access, which of the following statements would result in contacts and emails only for the clients in 603 area code? a) Select Contact, Email From Client Where Phone Not Like "603*" b) Select Contact, Email From Client Where Phone Like "603" c) Select Contact, Email From Client Where Phone Like "603*" d) Select Contact, Email From Client Where Phone Like "*603*"

Q: In Microsoft Access, which of the following statements would result in contacts and emails only for the clients in the state of New Hampshire? a) Select Contact, Email From Client Where State equals "NH" b) Select Contact, Email From Client Where State != "NH" c) Select Contact, Email From Client Where State = "NH" d) Select Contact, Email From Client Where State is "NH"

Q: In Microsoft Access query design view, the condition restricting jobs to those with JobID of 5 or more, would go into which of the following rows? a) Field b) Sort c) Show d) Criteria

Q: Sorting on multiple columns in Microsoft Access query design grid involves which of the following? a) Placing the fields in order in which they should be sorted b) Choosing the type of sort (Ascending, Descending) c) Checking the boxes on fields that should be shown d) All of the above

Q: Which of the following would be selected in order to display Select Client * From Client code in Microsoft Access? a) Query design view b) Query datasheet view c) Query SQL view d) Form design view

Q: In Microsoft Access main database window, which of the following objects allows you to create and execute SQL statements? a) Tables b) Queries c) Forms d) Reports

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.For questions 33-56, please refer to the preceding paragraph.In Microsoft Access, the statement used to retrieve all the data from the job table, would be which of the following?a) Select Job From *b) Select * From Jobc) From Job Select *d) From * Select Job

Q: Instead of using where clause to perform a join, Microsoft Access uses Inner Join keywords.

Q: To perform a join, a Where clause specifies that the value of the primary key in a parent table equals the value of the foreign key in a child table.

Q: By checking the Show box in Microsoft Access query design view, we can use a particular field without displaying it.

Q: In Microsoft Access, the statement used to display all the employees, sorted first by their names, and then by birth dates would be: Select * From Employees Order by BirthDate, Name.

Q: In Microsoft Access query design view, the bottom pane rows used to order client's contacts (A to Z) and their emails would use Field row for Contact and Email fields, and Ascending under Contact field in Sort row.

Q: In Microsoft Access query design view, the top pane shows all the tables available for a query.

Q: Establish the relationships between the tables in exposures.mdb Microsoft Access database. Make sure to indicate the correct cardinality.

Q: Complete the design of the order table in exposures.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Complete the design of the LineItem table in exposures.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Complete the design of the product table in exposures.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Exposures is a specialty retailer of fine gifts, picture frames, albums, scrapbooks, as well as occasional gift ideas. Visit their Web site at www.exposureonline.com, and using the registration, billing, catalog, and shopping cart screens below, go through each of the five ER design steps.For questions 91"95, please refer to the preceding paragraph and web pages.Complete the design of the customer table in exposures.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Establish the relationships between the tables in flower.mdb Microsoft Access database. Make sure to indicate the correct cardinality.

Q: Complete the design of the supplier table in flower.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Complete the design of the order table in flower.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Jerry, the owner of Exotic Flower's Inc., built a small greenhouse to store several types of exotic flowers that he purchases from wholesale suppliers around the world. Each exotic flower Jerry buys and resells falls into one of several flower groups that differ with respect to their storage needs, duration, time in bloom, price, etc. Each of the orders placed by customers specifies the type of exotic flower, the supplier it came from, the date of order, expected delivery date, flower condition on delivery, as well as the quantity ordered. Customer's data contain all the standard information needed to collect payment and deliver the flowers.For questions 87-90, please refer to the preceding paragraph.Complete the design of the flower table in flower.mdb Microsoft Access database. Make sure to indicate which of the fields is the primary key.

Q: Establish the relationships between the tables in rental.mdb Microsoft Access database. Make sure to indicate the correct cardinality.

Q: Complete the design of the vehicle 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 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