can someone please help me with my review? _____ fields are useful for fields th
ID: 3859665 • Letter: C
Question
can someone please help me with my review?
_____ fields are useful for fields that reference a specific list of items. Date/Time Lookup Number Currency True or False: Filter by selection lets you apply a filter based on any value in your table. True False True or False: When designing a table, you specify what type of information can be entered in each field by selecting the data type. True False Which object displays a collection of student information formatted in rows called records. Field Database Chart Table A primary key is a unique identifier, therefore, all of the following are examples of primary keys EXCEPT. Student ld#. Social Security Number. ISBN number of a textbook. A person's last name. True or False: Every relationship links two fields, each in a different table. True False _____ are conditions that the records must meet in order to be included in the query results. Function. Criteria. Precedence. Query. True or False: A one-to-one relationship links one record in a table to zero or one record in another table. True False True or False: When you enter data in a table or form, Access automatically saves the information when you navigate away from that record. Therefore, you do not need to save your file as often as you do with other Office 2010 applications. True False From _____ you establish the table primary key and table properties as well as specific properties or formatting for individual fields. Login View Datasheet View Design view Query View True or False: A database can be defined as a collection of data that has been organized by fields or topics. True False Enter a _____ to limit the number of characters that can be entered in a text field. Wizard Lookup Field Text field Currency Field SizeExplanation / Answer
Q15-True- filter by selection lets you apply a filter based on any value in the table and this can be achieved by using where clause.
Q16-True-Yes when designing the table we need to specify what typee of information can be entered in each feild by selecting the data type such as int ,varchar,char otherwise there is no way to detect the information type in the table.
Q17-Table- A table is used to display student formatted in rows and columns where each row specify the information for each student.
Q18-A person's last name- A person's last name cannot be a primary key as many people can have same name as their last name and primary key has a constraint of being unique which means it cannot contain duplicate values.
Q19-False- its not always necessary that in a relation ship two feilds are linked in different tables there can be relationship between feilds in the same table also.
Q20-Criteria - criteria is the condition that the records must meet in order to be a part of the result of the query if it does not meet the criteria then it cannot be a part of the resultant table.
Q21-True - A one to one relation ship either links one or no feilds in other table.
Q22-True
Q23-by using the design view we setup the primary key and table properties which is basically the task of designing the table.
Q24-True- the basic defination of a database is collection of data in an arranged format.
Q25-Feild Size- a feild size is used to limit the number of characters that can be entered in a text feild.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.