How can I retrieve the object properties values from the database?

Information Systems Questions - Queries?

  • 1) Although a field has unique values in the table in which it is the primary key, it does not have to have unique values in the table in which it is the foreign key. a. True b. False 2) Defining a(n) primary key in a second table creates a relationship between that table and the table where the primary key was first defined. a. True b. False 3) Access saves changes to the active database when a record is changed or added and when you close the database. a. True b. False 4) The specific content of a field a. field
 b. table c. 
field value d. relational database 5) Connects the records in separate tables a. field
 b. table
 c. field value d. relational database 6) A single characteristic or attribute of a person, place, object, event, or idea a. field
 b. table
 c. field value d. relational databasE 7) A collection of fields that describe a person, place, object, event, or idea a. field
 b. table
 c. field value d. relational database 8) A ____ is a question you ask about data stored in a database. a. report b. form c. query d. macro 9) A database is a convenient way to ____ related data. a. Enter b. 
retrieve c. maintain
 d. All of the above 10) The ____ operator will select records only if all conditions are satisfied. a. Or b. If...Or c. range d. And 11) Calculations can be performed in a query by defining a(n) a. logical operator b. comparison operator c. expression d. condition 12) A field can be described as a(n) a. object b. record c. attribute d. tablE 13) One example of a predefined function in Access is the Count function, which determines ____. a. how many times a query is run b. 
the number of fields present in the query
 c. how many fields are displayed in the datasheet window d. the number of records selected 14) You should not use a primary field in one table as a field in a different table. a. True b. False 15) When you create relationships between tables, if you choose the ____, Access permits the change in value to the primary key and changes the appropriate foreign key values in the related table, thereby eliminating the possibility of inconsistent data. a. cascade delete option b. cascade updates option c. propagate option d. referential integrity option 16) Copying records from spreadsheets to tables in a database can be done if the source and destination objects a. contain the same fields in different order
 b. contain the same fields in the same order
 c. have the same structures and fields in the same order d. all of the above 17) In a Guest Reservation DBMS, if you observe that you are entering the same data again and again such as the name of the guest in the Reservation table, you could fix this by ____. a. only including the Guest ID field in the Reservation table
 b. only including the Guest ID field in the Guest table
 c. making sure that you type the Guest data accurately every time to avoid inconsistency d. none of the above 18) To create a query that displays the Donor Name, Agency, Donations, and Date fields for all donors who are not from Illinois or who have donated in the month of June 2101, you should use a(n) ____. a. OR aggregate function b. AND logical operator c. OR logical operator d. Calculated field 19) FILL IN THE BLANK 20) In a given table, a field is defined as a(n) ____________________ when its values uniquely identify each record in the table. 21) A set of field values for a specific entry is a(n) ____________________. 22) When you design a query, you include the fields and record selection criteria for the information you want to see in the ____________________ grid in the design view. 23) When you design a query , in order to define a condition for a field, you place the condition in the field's ____________________ text box in the design grid. 24) A(n) ____________________ is a field that displays the results of an expression. 25) Rearranging the order of records is ____________________. 26) You must place date and time values inside _____________ when using these values as selection criteria. 27) Unlike a Field text box, which is too small to show an entire expression at one time, the _______________ and Expression Builder are large enough to display lengthy expressions. 28) The AutoNumber, Currency, Date/Time, Memo, Number, OLE Object, Text, and Yes/No data types all support the Max aggregate function. ____________________

  • Answer:

    You may want to ask this question on a different area in Yahoo Answers. This forum is for asking technology employment questions. After you get your IT degree well underway and we will be glad to help answer any questions on finding employment. Best Wishes!

Bob at Yahoo! Answers Visit the source

Was this solution helpful to you?

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.