How do you enter more than one value in a multivalued lookup field in table datasheet view?
Scheduled maintenance: Saturday, September 10 from 11PM to 12AM PDT Show
Home Subjects Solutions Create Log in Sign up Upgrade to remove ads Only SGD 41.99/year
Terms in this set (65)In the database environment, _____ means looking for records that satisfy some criteria. Searching If your criterion involves more than one field, use Filter By _____. Form When you create a database, you define its _____; that is, you assign names and types to all the fields. Structure A _____ field allows the user to select from a list of values when updating the contents of the field. Lookup A field that can be computed from other fields is called a _____ field or computed field. Calculated A _____ query allows you to delete all the records satisfying some criterion. Delete You can add the results of a query to an existing table by using an _____ query. Append A(n) _____ value is a value that Access will display on the screen in a particular field before the user begins adding a record. Default You can use the _____ operator to specify a range of values. BETWEEN You can modify the appearance of the datasheet by changing the _____ color, a color that appears on every other row in the datasheet. Alternate Fill (T/F) Restructuring a database can include adding new fields to a table, changing the characteristics of existing fields, and removing existing fields. True (T/F) Although you can make some changes to the database structure in Design View, it is usually easier and better to make these changes in Datasheet View. False (T/F) If you plan to move your data to another relational database management system, such as SQL Server, it is best to use multivalued fields. False (T/F) If you do not specify any criteria in a delete query, Access will delete all the records in the table. True (T/F) Validation rules can indicate a required field, a field in which the user must enter data; failing to enter data into a required field generates an error. True (T/F) To specify that a field is to be required, change the value for the required property from False to True. False (T/F) Using a multivalued lookup field is similar to using a regular lookup field. The difference is that when you drop down the list, the entries all will be preceded by row selectors. False (T/F) In a one-to-one relationship, the matching fields are both primary keys. True (T/F) The availability of a subdatahseet is indicated by an equals sign that appears in front of the rows of a table. False (T/F) To change the order in which records appear, use the Ascending or Descending buttons. True _____ the database means modifying the data to keep it up to date by adding new records, changing the data for existing records, and deleting records. Maintaining A(n) _____ allows you to simultaneously view both simple form and datasheet views if the data. Split Form To have only the record or records that satisfy the criterion appear, use a(n) _____. Filter The ______ button switches between filtered and unfiltered displays of the records in the table. Toggle Filter Both the question mark (?) and the asterisk (*) _____ can be used in filters created using Advanced Filter/ Sort. Wildcards In Access, it is possible to have _____ fields, that is, fields that can contain more than one value. Multivalued A(n) _____ table is a table that contains data that is no longer used in operations but that might still be needed by the organization. Archive A(n) _____ query adds, deletes, or changes data in a table. Action _____ rules are rules that a user must follow when entering data. Validation A(n) ______ relationship means that one record in the first table is related to, or matches, many records in the second table, but each record in the second table is related to only one record in the first. One-To-Many to create a split form, select the table in the Navigation Pane, click CREATE on the ribbon, click the _____ button on the CREATE tab to display a menu, and then click Split Form on the menu. More Forms To move from Layout view to Form view, tap or click the ____ button on the Access status bar. Form View To use Filter By Selection to find all customers located in Granger, click the City field for any record where the city is Granger and then click the _____ button on the HOME tab. Selection When a filter is in effect, you can redisplay all records by tapping or clicking the ____ button on the HOME tab. Toggle Filter To clear a filter, click the ____ button on the HOME tab and then click Clear All Filters. Advanced To use a common filter to find only those customers whose city begins with G, click the arrow to the right of the field name and point to the _____ command to display the custom text filters. Text Filters To use Filter By Form to filter records, click the _____ button on the HOME tab and then click Filter By Form. Advanced When you use Filter By Form to restrict records that appear, you create the filter and then click the _____ button to apply the filter. Toggle Filter To filter records using complex criteria, click the _____ button on the HOME tab and then click Advanced Filter/ Sort on the menu that appears. Advanced When you use Advanced Filter/Sort to filter records using complex criteria, create the filter and then click the ____ button on the HOME tab to view the results. Toggle Filter To delete a field from a table, open the table in ____ view, click the row selector for the field to be deleted and then press the DELETE key. Design A _____ field allows the user to select from a list of values. Lookup To change the list of choices in a single or multivalued lookup field, open the table in Design view, select the field to be modified, and click the _____ tab in the Field Properties pane. Lookup To create a multivalued field, create a ____ field being sure to check the Allow Multiple Values check box. Lookup A(n) _____ field is a field that can be compute from other fields. Calculated To create an update query, create a new query and then click the _____ button on the DESIGN tab. Update To update records using an update query, enter the field to be updated in the design grid, enter any necessary criterion, and then click the _____ button to update the records. Run A(n) _____ query adds a group of records from one table to the end of another table. Append A(n) _____ query adds records from an existing table to a new table, that is, a table that has not yet been created. Make-Table To specify that a field is to be required, change the value for the _____ property from No to Yes. Required To create a validation rule for the State field to restrict entries to TN or TX, enter _____ in the Validation Rule property box. T? To specify that entries in the current due field must be between $0.00 and $30,000.00, enter ____ in the Validation Rule property box. >=0 and <=30000 If the Account Number field in a record always should display the three characters in the account number in uppercase, then the correct format for this field is ____. > To save validation rules, default values, and formats, click the Save button on the ____ to save the changes. Quick Access Toolbar To include totals and other statistics at the bottom of a datasheet, click the _____ button on the HOME tab to include the Total row in the datasheet. Totals To remove a total row that appears in a datasheet, click the ____ button on the HOME tab. Totals To find duplicate records in a table, use the _____ Query Wizard. Find Duplicates To find records in one table that have no matching records in another table, use the _____ Query Wizard. Find Unmatched To order the records in the Account table by city in alphabetical order, use the _____ button. Ascending To order the records in the Account table in reverse alphabetical order by City, click the _____ button. Descending Maintaining a database can include _____. Filtering Records You can add a record to a table by ____. Clicking the New (Blank) Record Button on the Navigation Pane The wildcard symbols for use with filters are _____. Asterisk (*) Validation rules can indicate a ____. Required Field Computations available for the Total row in a column that contains currency include ____. Sum Sets with similar termsOIS FINAL TEST 3105 terms oaklynne_elaine CGS Final Review58 terms ElizabethMejia CIS160 Access Exam80 terms lauren_keck1 JWCC: CSC 116 - Database Core Level (Access 2013 L…53 terms Melody_Bock
Other sets by this creatorFinancial Math General Vocabulary Terms68 terms jkolar13 Livestock Judging275 terms jkolar13 Access Chapter 2: BIM41 terms jkolar13 Word Chapter 3 Review: BIM30 terms jkolar13 Verified questionsCOMPUTER SCIENCE Which of the following statements increase the value of x by 1? I. x++; II. x=x+1; III. x+=1; a. I only, b. II only, c. I and III, d. II and III, e. I, II, and III. Verified answer
COMPUTER SCIENCE True/False. In the declaration int num=2.4; the 2.4 will automatically be converted to an int and num will get the value 2. Verified answer
COMPUTER SCIENCE An extensive encoding scheme that can represent characters for many languages in the world is __________. a. binary numbering b. ASCII c. Unicode d. ENIAC Verified answer COMPUTER SCIENCE What are the advantages of using recursion? Verified answer Other Quizlet sets362 final18 terms nathanyee412 Quiz 2 (2265, Module 6)20 terms IT_Mouse BA 342 Final15 terms mjohn243 Views and User Set Ups14 terms andibrugnoli Related questionsQUESTION Why might a language like Extensible Markup Language (XML) be commonly used in a document database? 15 answers QUESTION Query criteria that are created when a user clicks on a graphic 4 answers QUESTION A command used in Oracle to display how the query optimizer intends to access indexes, use parallel servers, and join tables to prepare query results is the: 6 answers QUESTION Once an ADO.NET dataset is constructed, its contents can be formatted as an XML document with a single command. 12 answers How do you enter more than one value in a multivalued lookup field?Create a multivalued field. On the first page, select I will type in the values that I want, and then click Next.. On the second page, keep 1 column selected, enter several values, one in each row under the column header, and then click Next.. How do you enter a value in a lookup field in table Datasheet view?Create a values list field. In the Access desktop program, open the table in Design view. Important: In a web app, you need to use a new field. ... . Add a new field, and choose Lookup as the data type. ... . Click the I will type in the values that I want box.. Enter the values, one on each line, then click OK.. How do you select multiple values from a lookup field in a record in Access?In the Lookup Wizard, type the label for your lookup field. Under Do you want to store multiple values for this lookup?, select the Allow Multiple Values check box. Note: This check box must be selected to enable storing multiple values. Click Finish.
|