TipsMake

The Microsoft Access test has a P3 answer

Microsoft Office Access, often referred to as MS Access or simply Access, is a management software that is a relational database owned by Microsoft. Please join the Network Administrator to learn about this topic through multiple choice questions.

★ Microsoft Access has a P2 answer
★ The Microsoft Access test has the answer P4
  • Question 1. A form after design is shown in many forms
    • 4
    • 3
    • 2
    • first
  • Question 2. When creating a query, if you want to sort data in either up or down direction, then in the grid area, select the item
    • Index
      1. Index and Sort
    • Show
    • Sort
  • Question 3. The total number of Fields in an Index
    • ten
    • 255
    • 32
    • Optional
  • Question 4. In a Select Query, a field of type is an expression that cannot be contained
      1. Math operations
    • School names
    • Functions
    • Procedures
  • Question 5. Each Access database is saved on disk in the form of
    • Each component (Table, Query, Form, Report, Macro, Module) is saved as a separate file
    • Table component is saved as a .DBF file, while other components are stored in a .MDB file
    • Component module saved as .PRG file, the rest of the components are stored in .MDB file
    • All components are stored in a single file with extensions
      .MDB
  • Question 6. When an Update Query is open in DataSheet View mode
    • Cannot add any items to the results table
    • Cannot edit the value of the records in the results table
    • Can add and edit the value of the records on the results table
    • Cannot add and edit values ​​on the results table
  • Question 7.In the form 'BIEUMAU' there is a Textbox with the attribute Name is KH, from any object, want to access this Textbox, we choose
    • [BIEUMAU]! [Form]. [KH]
    • [Form]. [KH]
    • [Forms]! [BIEUMAU]! [KH]
    • Forms]! [BIEUMAU]. [KH]
  • Question 8. We establish the relationship between tables is to
    • Copy information between tables
    • Remove duplicate information between 2 tables
    • Move information between tables
    • Accessing the right data between tables is related
  • Question 9. A primary key must
    • Unique value (not the same)
    • Not empty
    • Uniquely identify a message
    • Unique value (not identical); must not be empty; uniquely identify a message
  • Question 10. When creating tables in an Access database, we should do the following
    • Create links, create primary keys, input data
    • Create primary key, create link, input
    • Create primary key, input data, create link
    • Enter data, create primary key, link
  • Question 11. The Autoexec macro is:
    • A macro automatically executes when you open Access
    • A macro automatically executes when you press a specified hotkey
    • A macro automatically executes when you open Access's Database file
    • A macro automatically executes when you exit Access
  • Question 12. When creating a Form with Design view mode, you can get data from:
    • A Table or a Query
    • One or more Query
    • A table and multiple queries
    • Multiple tables and multiple queries
  • Question 13. Foreign lock is:
    • One or more fields in a table
    • A special message
    • None of the table's primary keys
    • All three sentences (A), (B), (C) are correct
  • Question 14. When selecting a field in a table as the primary key, the REQUIRED attribute of that field must be selected
    • YES
    • NO
    • Optional
    • All answers above
  • Question 15. When you want to establish Relationship between two tables, each table must be
    • There is at least one message
    • There are at least three schools
    • There are at least one school
    • All three answers are correct

Discover more

quizzes Microsoft Access computer literacy tests access 2010 access usage databases
Lesley Montoya

Share by

Lesley Montoya
Update 24 May 2019

You should read it