Course Hero Logo

Which fields are commonly defined with an input mask

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 17 - 18 out of 18 pages.

Which fields are commonly defined with an input mask?a.Social Security Numberb.First, middle, and last namec.City, state and zip code (partially right)d.All of the above
Which field data type appears as a check box in a table?
Theprimary keyis a field, or combination of fields,that uniquely identifies a record
Using the Lookup Wizard for a field in a table, will result in a ______ ________ displaying on aform based off of that fieldoCombo box or drop-down listTrue/ False: Updating form data will update the associated data record in the corresponding table.Queries:1.The most common type of query is called a2.Which of the following criteria will return the record Anderson?
a.Like “Ander?”b.Like “Ander*”c.Both a and bd.Neither a nor b3.Which function can be used instead of the OR criteria?
4.All are valid functions for grouped queries except
5.If your balance is 10,000, what is the result of this expression?
6.True/False: you can modify the query results, but the changes will not be reflected in theunderlying table
End of preview. Want to read all 18 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
NoProfessor
Tags
Relational model, relation

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture