TipsMake

The Microsoft Access test has the answer P7

Multiple choice questions on access software include 10 questions to help readers check their knowledge. Please try it together.

★ Microsoft Access has a P2 answer
★ The Microsoft Access test has the answer P4
  • Question 1. NGAYSINH School in a table only allows entry in the year of birth before 1986, whichever is the right choice in the following options:
    • Validation Rule: Year ([NGAYSINH])> = 1994
    • Validation Rule: Year ([NGAYSINH])> 1994
    • Validation Rule: Year ([NGAYSINH])
    • Validation Rule: Year ([NGAYSINH]) <= 1994
  • Question 2. Which of the following names cannot be used as the Field name:
    • Good
    • [Right now]
    • Address
    • Allowance
  • Question 3. Suppose two tables have a 1-n relationship, if you want to delete a record in the parent table (Table 1), Access also deletes the related records in the child table (table n), then in the link. link (relationship) of these two tables we choose:
    • Enforce Referential Integrity
    • Cascade Update Related Fields
    • Cascade Delete Related Fields
    • Failed to fulfill the above requirement
  • Question 4. Data of a field of type Autonumber:
    • May be random, may increase gradually
    • Always descending
    • Always increasing
    • Optional users
  • Question 5. When a table is open we can:
    • Cannot delete any items
    • Insert a record into any position
    • Delete any message
    • Can be deleted but cannot insert any message
  • Question 6. What data type for HOTEN field allows you to enter your name?
    • Memo style
    • Text and Memo style
    • Text style
    • String type
  • Question 7. Find the expression that gives FALSE results in the following expressions:
    • (3> 2) and (4 <5)
    • ("ABC" <= "abc") and ("A" <= "a")
    • ("ABC" <= "abc") or ("A"> "a")
    • ("ABC" <= "abc") and ("A"> "a")
  • Question 8. Find the expression that results in TRUE in the following expressions:
    • 3 Print (1.5)
    • 3 Between (1.5)
    • 3 Between 1 And 5
    • 3 In 1 And 5
  • Question 9. How many modes can a form in an Access database open:
    • first
    • 2
    • 3
    • 4
  • Question 10. The main similarity between Report and Form is:
    • Insert information
    • View data
    • Edit data
    • a and C are right

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