logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which view allows you to design the layout of a form?

  • Datasheet View
  • Design View
  • Form View
  • Layout View
Mark for review

Which function is used to count the number of records in a query?

  • COUNT()
  • SUM()
  • AVG()
  • MAX()
Mark for review

How do you make a field required in Access?

  • By setting a default value
  • By setting a validation rule
  • By setting a field property
  • By using a macro
Mark for review

What is the use of the 'Foreign Key' in Access?

  • To encrypt data
  • To establish relationships
  • To generate reports
  • To format text
Mark for review

How can you create a backup of an Access database?

  • By using a query
  • By copying the file
  • By creating a form
  • By setting permissions
Mark for review

How do you filter records in a datasheet view?

  • Use the Filter command
  • Use a query
  • Use a form
  • Use a report
Mark for review

What is the purpose of a form in Access?

  • To display data
  • To analyze data
  • To create tables
  • To generate queries
Mark for review

Which of the following is an example of a database object in Access?

  • Spreadsheet
  • Document
  • Table
  • Image
Mark for review

How can you ensure data integrity between related tables?

  • By using primary keys
  • By using validation rules
  • By creating forms
  • By writing SQL code
Mark for review

What does the 'JOIN' keyword do in an SQL query?

  • Deletes records
  • Joins tables
  • Updates records
  • Creates tables
Mark for review

What does the 'Sort Ascending' command do?

  • Sorts from Z to A
  • Sorts from A to Z
  • Sorts numerically
  • Removes duplicates
Mark for review

How do you define relationships between tables in Access?

  • By creating a form
  • By using relationships
  • By writing SQL code
  • By creating queries
Mark for review

Which Access feature is used to validate data before entering it into a table?

  • Field Validation
  • Data Entry
  • Table Design
  • Form Design
Mark for review

How do you add a new record to a table in Access?

  • Use a macro
  • Enter data directly
  • Use a query
  • Create a report
Mark for review

How can you prevent users from modifying data in a table?

  • By using a macro
  • By setting permissions
  • By using a form
  • By creating a query
Mark for review

What is the purpose of the 'Input Mask' property in Access?

  • To format data entry
  • To encrypt data
  • To validate data
  • To sort records
Mark for review

What is the function of the 'Expression Builder' in Access?

  • To design forms
  • To create queries
  • To build complex expressions
  • To manage data
Mark for review

Which Access object is used to create user interfaces?

  • Table
  • Query
  • Form
  • Report
Mark for review

How do you prevent duplicate records from being entered into a table?

  • By setting a primary key
  • By using a report
  • By using a macro
  • By creating a query
Mark for review

What is the purpose of the 'Export' feature in Access?

  • To save a backup
  • To move data to another format
  • To create a new table
  • To update records
Mark for review

How do you display the total number of records in a form?

  • Use the 'Total' field
  • Use the 'Count' function
  • Use the 'Sum' function
  • Use the 'Count' control
Mark for review

Which Access object would you use to generate a summary report?

  • Query
  • Form
  • Report
  • Table
Mark for review

What is the use of the 'Group By' clause in an Access query?

  • To sort records
  • To calculate sums
  • To filter data
  • To group data
Mark for review

How can you automatically update records in Access?

  • By using a macro
  • By using a report
  • By using a form
  • By using an update query
Mark for review

What feature helps to ensure that data entered into a field is correct?

  • Validation Rule
  • Lookup Field
  • Default Value
  • Input Mask
Mark for review

What type of report shows data grouped by categories?

  • Detail Report
  • Summary Report
  • Group Report
  • List Report
Mark for review

Which object would you use to calculate totals in Access?

  • Table
  • Query
  • Report
  • Form
Mark for review

What is the default sort order when sorting a column in Access?

  • Ascending
  • Descending
  • By date
  • By alphabetical order
Mark for review

What is the purpose of a primary key in a table?

  • To identify duplicates
  • To link tables
  • To sort records
  • To filter data
Mark for review

What type of query will you use to find specific records in a database?

  • Action Query
  • Select Query
  • Crosstab Query
  • Parameter Query
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session