TipsMake

Microsoft Access test has P8 answer

The following Access database quiz will provide you with useful information on this topic, invite readers to try the same questions below.

★ Microsoft Access has a P2 answer
★ The Microsoft Access test has the answer P4
  • Question 1. Attribute Validation Text of field A will specify:
    • The error message line when entering the value of field A is invalid
    • The message line appears when the cursor moves into column A
    • Conditions require the cursor to move into column A
    • Valid data condition to limit the value field to enter field A
  • Question 2. Table Name:
    • There is white space
    • There is an arbitrary name length
    • There are no spaces
    • There is a maximum length of 64 characters, white space should not be used and accented Vietnamese should not be used
  • Question 3. Input Mask used for
    • Data format
    • Data protection in tables
    • Specifies a template for data entry
    • Data shield
  • Question 4. To establish relations between tables, we execute the command:
    • EditTool .
    • ViewRelationships
    • InsertRelationships
    • ToolRelationships
  • Question 5. When you want to establish Relationship between two tables, each table must:
    • There is at least one message
    • There are at least three schools
    • There are at least one school
    • All three sentences (A), (B), (C) are correct
  • Question 6. In design mode to get data for From using properties?
    • Record Source
    • Control Source
    • Data
    • All answers above
  • Question 7. Want to copy (copy) data from a table to a new table for storage, we use:
    • Make Table Query
    • Update Query
    • Add Query
    • Append Query
  • Question 8. Suppose that in the table there is MAHANG field, want the data of this field when input into the first character must be "B" then:
    • In Validation Rule write: Like "* B"
    • In the Format write: Like "B *"
    • In Validation Rule write: Like "B *"
    • Unable to execute the above request
  • Question 9. What is the number of characters in the column name (field name)?
    • Less than or equal to 255
    • Less than or equal to 8
    • Less than or equal to 256
    • Less than or equal to 64
  • Question 10. Can the name of the column (school name) be placed in Vietnamese with a seal?
    • OK
    • Should not
    • Can not
    • Optional

Discover more

quizzes Microsoft Access computer literacy tests access 2010 access usage databases
David Pac

Share by

David Pac
Update 24 May 2019

You should read it