Home Tech info Quiz technology

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.

  1. 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:
    1. Validation Rule: Year ([NGAYSINH])> = 1994
    2. Validation Rule: Year ([NGAYSINH])> 1994
    3. Validation Rule: Year ([NGAYSINH])
    4. Validation Rule: Year ([NGAYSINH]) <= 1994
  2. Question 2. Which of the following names cannot be used as the Field name:
    1. Good
    2. [Right now]
    3. Address
    4. Allowance
  3. 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:
    1. Enforce Referential Integrity
    2. Cascade Update Related Fields
    3. Cascade Delete Related Fields
    4. Failed to fulfill the above requirement
  4. Question 4. Data of a field of type Autonumber:
    1. May be random, may increase gradually
    2. Always descending
    3. Always increasing
    4. Optional users
  5. Question 5. When a table is open we can:
    1. Cannot delete any items
    2. Insert a record into any position
    3. Delete any message
    4. Can be deleted but cannot insert any message
  6. Question 6. What data type for HOTEN field allows you to enter your name?
    1. Memo style
    2. Text and Memo style
    3. Text style
    4. String type
  7. Question 7. Find the expression that gives FALSE results in the following expressions:
    1. (3> 2) and (4 <5)
    2. ("ABC" <= "abc") and ("A" <= "a")
    3. ("ABC" <= "abc") or ("A"> "a")
    4. ("ABC" <= "abc") and ("A"> "a")
  8. Question 8. Find the expression that results in TRUE in the following expressions:
    1. 3 Print (1.5)
    2. 3 Between (1.5)
    3. 3 Between 1 And 5
    4. 3 In 1 And 5
  9. Question 9. How many modes can a form in an Access database open:
    1. first
    2. 2
    3. 3
    4. 4
  10. Question 10. The main similarity between Report and Form is:
    1. Insert information
    2. View data
    3. Edit data
    4. a and C are right

You've just finished reading the article "The Microsoft Access test has the answer P7" edited by the TipsMake team. You can save the-microsoft-access-test-has-the-answer-p7.pdf to your computer here to read later or print it out. We hope this article has provided you with many useful tech tips and tricks. You can search for similar articles on tips and guides. Thank you for reading and for following us regularly.

Microsoft Access computer literacy tests access 2010 access usage
« PREV What do you understand about Windows P3 operating system?
NEXT » IQ puzzle or answer P7
Read more