These are 100 multiple-choice questions on Microsoft Access for PEO exam and junior assistant
Which of the following is a database management system provided by Microsoft?
a) Microsoft Word
b) Microsoft Excel
c) Microsoft PowerPoint
d) Microsoft Access
Answer: d) Microsoft Access
What is the file extension used by Microsoft Access?
a) .mdb
b) .xls
c) .doc
d) .ppt
Answer: a) .mdb
Which of the following is used to create tables in Microsoft Access?
a) Query
b) Form
c) Report
d) Table Design View
Answer: d) Table Design View
What is a primary key in a table?
a) A key that provides access to all the data in the table
b) A key that uniquely identifies each record in the table
c) A key that is used to sort the records in the table
d) A key that is used to link multiple tables together
Answer: b) A key that uniquely identifies each record in the table
Which of the following is used to define relationships between tables in Microsoft Access?
a) Query
b) Form
c) Report
d) Relationships View
Answer: d) Relationships View
What is the maximum number of characters that can be stored in a Text field in Microsoft Access?
a) 255
b) 1024
c) 2048
d) 4096
Answer: a) 255
Which of the following is used to retrieve data from one or more tables in Microsoft Access?
a) Query
b) Form
c) Report
d) Table
Answer: a) Query
What is the purpose of a form in Microsoft Access?
a) To display data from a table
b) To create relationships between tables
c) To perform calculations on data
d) To create reports
Answer: a) To display data from a table
Which of the following is used to present data in a formatted manner in Microsoft Access?
a) Query
b) Form
c) Report
d) Table
Answer: c) Report
What is the purpose of a query parameter in Microsoft Access?
a) To filter records based on specific criteria
b) To create relationships between tables
c) To perform calculations on data
d) To define the structure of a table
Answer: a) To filter records based on specific criteria
Which of the following is used to perform calculations on data in Microsoft Access?
a) Query
b) Form
c) Report
d) Expression Builder
Answer: d) Expression Builder
What is the purpose of a validation rule in Microsoft Access?
a) To ensure that only unique values are entered in a field
b) To restrict the values that can be entered in a field
c) To perform calculations on data in a field
d) To define relationships between tables
Answer: b) To restrict the values that can be entered in a field
Which of the following is used to import data from an external source into Microsoft Access?
a) Export
b) Query
c) Import
d) Table
Answer: c) Import
What is the purpose of a subform in Microsoft Access?
a) To display related records from another table
b) To perform calculations on data
c) To create reports
d) To define relationships between tables
Answer: a) To display related records from another table
What is the purpose of a macro in Microsoft Access?
a) To perform automated tasks
b) To define relationships between tables
c) To create reports
d) To import data from external sources
Answer: a) To perform automated tasks
Which of the following is used to create a user interface in Microsoft Access?
a) Query
b) Form
c) Report
d) Table
Answer: b) Form
What is the purpose of the Compact and Repair Database feature in Microsoft Access?
a) To create backups of the database
b) To optimize the performance of the database
c) To import data from external sources
d) To define relationships between tables
Answer: b) To optimize the performance of the database
Which of the following is used to control access to data in Microsoft Access?
a) User-level security
b) Database password
c) Encryption
d) Validation rule
Answer: a) User-level security
What is the purpose of the Navigation Pane in Microsoft Access?
a) To display a list of tables, queries, forms, and reports in the database
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To display a list of tables, queries, forms, and reports in the database
Which of the following is used to sort data in a table in Microsoft Access?
a) Query
b) Form
c) Report
d) Table
Answer: d) Table
What is the purpose of the Expression Builder in Microsoft Access?
a) To perform calculations on data
b) To define relationships between tables
c) To create reports
d) To import data from external sources
Answer: a) To perform calculations on data
Which of the following is used to create a backup of the database in Microsoft Access?
a) Export
b) Query
c) Compact and Repair Database
d) Backup Database
Answer: d) Backup Database
What is the purpose of the Datasheet View in Microsoft Access?
a) To enter and edit data in a table
b) To create relationships between tables
c) To perform calculations on data
d) To create reports
Answer: a) To enter and edit data in a table
Which of the following is used to print data in a formatted manner in Microsoft Access?
a) Query
b) Form
c) Report
d) Table
Answer: c) Report
What is the purpose of the Find and Replace feature in Microsoft Access?
a) To search for specific data in a table
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To search for specific data in a table
Which of the following is used to create a relationship between two tables in Microsoft Access?
a) Query
b) Form
c) Report
d) Relationships View
Answer: d) Relationships View
What is the purpose of the End-of-Record marker in Microsoft Access?
a) To indicate the end of a record in a table
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To indicate the end of a record in a table
Which of the following is used to create a new database in Microsoft Access?
a) Export
b) Query
c) New Database
d) Table
Answer: c) New Database
What is the purpose of the AutoNumber data type in Microsoft Access?
a) To automatically assign a unique number to each record in a table
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To automatically assign a unique number to each record in a table
Which of the following is used to create a summary of data in Microsoft Access?
a) Query
b) Form
c) Report
d) Table
Answer: c) Report
What is the purpose of the Data Type property in Microsoft Access?
a) To specify the type of data that can be entered in a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the type of data that can be entered in a field
Which of the following is used to create a multi-table query in Microsoft Access?
a) Export
b) Query
c) Import
d) Table
Answer: b) Query
What is the purpose of the Cascade Update Related Fields option in Microsoft Access?
a) To update related fields automatically when the primary key changes
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To update related fields automatically when the primary key changes
Which of the following is used to define the structure of a table in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: d) Table Design View
What is the purpose of the Lookup Wizard in Microsoft Access?
a) To create a drop-down list of values for a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To create a drop-down list of values for a field
Which of the following is used to create a calculated field in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Table Design View
Answer: a) Expression Builder
What is the purpose of the Sort Ascending and Sort Descending buttons in Microsoft Access?
a) To sort data in a table in ascending or descending order
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To sort data in a table in ascending or descending order
Which of the following is used to create a summary calculation in a query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Totals Row
Answer: d) Totals Row
What is the purpose of the Lookup Field property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To create a drop-down list of values for a field
Answer: d) To create a drop-down list of values for a field
Which of the following is used to create a table relationship in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Relationships View
Answer: d) Relationships View
What is the purpose of the Input Mask property in Microsoft Access?
a) To format data as it is entered in a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To format data as it is entered in a field
Which of the following is used to define the structure and layout of a report in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: c) Report Design View
What is the purpose of the Index property in Microsoft Access?
a) To improve the performance of searches and queries on a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To improve the performance of searches and queries on a field
Which of the following is used to create a new record in a table in Microsoft Access?
a) Export
b) Query
c) Import
d) Table
Answer: d) Table
What is the purpose of the Attachment data type in Microsoft Access?
a) To store images, documents, or other files in a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To store images, documents, or other files in a field
Which of the following is used to import data from an Excel worksheet into Microsoft Access?
a) Export
b) Query
c) Import
d) Table
Answer: c) Import
What is the purpose of the Lookup Field Wizard in Microsoft Access?
a) To create a drop-down list of values for a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To create a drop-down list of values for a field
Which of the following is used to create a calculated control in a form or report in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Report Design View
Answer: a) Expression Builder
What is the purpose of the Validation Rule property in Microsoft Access?
a) To specify the type of data that can be entered in a field
b) To create relationships between tables
c) To perform calculations on data
d) To restrict the values that can be entered in a field
Answer: d) To restrict the values that can be entered in a field
Which of the following is used to create a data entry form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: b) Form Design View
Which of the following is used to create a calculated field in a query in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Table Design View
Answer: a) Expression Builder
What is the purpose of the Lookup Column property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To display a related value from another table
Answer: d) To display a related value from another table
Which of the following is used to define the criteria for a query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Criteria Builder
Answer: a) Query Design View
What is the purpose of the Primary Key in Microsoft Access?
a) To uniquely identify each record in a table
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To uniquely identify each record in a table
Which of the following is used to create a calculated field in a form or report in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Report Design View
Answer: a) Expression Builder
What is the purpose of the Caption property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To display a custom label for a field
Answer: d) To display a custom label for a field
Which of the following is used to define the layout and formatting of a form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: b) Form Design View
What is the purpose of the Input Mask Wizard in Microsoft Access?
a) To format data as it is entered in a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To format data as it is entered in a field
Which of the following is used to create a parameter query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Query Builder
Answer: a) Query Design View
What is the purpose of the Control Source property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To bind a control to a field or expression
Answer: d) To bind a control to a field or expression
Which of the following is used to define the layout and formatting of a report in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: c) Report Design View
What is the purpose of the DefaultValue property in Microsoft Access?
a) To specify the default value for a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the default value for a field
Which of the following is used to create a parameter form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Form Builder
Answer: b) Form Design View
What is the purpose of the Indexes window in Microsoft Access?
a) To improve the performance of searches and queries on a table
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To improve the performance of searches and queries on a table
Which of the following is used to create a calculated control in a form or report in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Report Design View
Answer: a) Expression Builder
What is the purpose of the Format property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To define the display format of a field or control
Answer: d) To define the display format of a field or control
Which of the following is used to define the layout and formatting of a query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: a) Query Design View
What is the purpose of the Validation Text property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To display a custom error message for a field
Answer: d) To display a custom error message for a field
Which of the following is used to create a parameter report in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Report Builder
Answer: c) Report Design View
What is the purpose of the Field Size property in Microsoft Access?
a) To specify the size of a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the size of a field
Which of the following is used to define the layout and formatting of a table in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: d) Table Design View
What is the purpose of the Caption Property property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To display a custom label for a property
Answer: d) To display a custom label for a property
Which of the following is used to create a parameter form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Form Builder
Answer: b) Form Design View
What is the purpose of the Field Properties window in Microsoft Access?
a) To specify the properties of a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the properties of a field
Which of the following is used to create a calculated field in a query in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Report Design View
Answer: a) Expression Builder
What is the purpose of the Format property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To define the display format of a field or control
Answer: d) To define the display format of a field or control
Which of the following is used to define the layout and formatting of a form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: b) Form Design View
What is the purpose of the Input Mask Wizard in Microsoft Access?
a) To format data as it is entered in a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To format data as it is entered in a field
Which of the following is used to create a parameter query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Query Builder
Answer: a) Query Design View
What is the purpose of the Control Source property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To bind a control to a field or expression
Answer: d) To bind a control to a field or expression
Which of the following is used to define the layout and formatting of a report in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: c) Report Design View
What is the purpose of the DefaultValue property in Microsoft Access?
a) To specify the default value for a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the default value for a field
Which of the following is used to create a parameter form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Form Builder
Answer: b) Form Design View
What is the purpose of the Indexes window in Microsoft Access?
a) To improve the performance of searches and queries on a table
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To improve the performance of searches and queries on a table
Which of the following is used to create a calculated control in a form or report in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Report Design View
Answer: a) Expression Builder
What is the purpose of the Format property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To define the display format of a field or control
Answer: d) To define the display format of a field or control
Which of the following is used to define the layout and formatting of a query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: a) Query Design View
What is the purpose of the Validation Text property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To display a custom error message for a field
Answer: d) To display a custom error message for a field
Which of the following is used to create a parameter report in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Report Builder
Answer: c) Report Design View
What is the purpose of the Field Size property in Microsoft Access?
a) To specify the size of a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the size of a field
Which of the following is used to define the layout and formatting of a table in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: d) Table Design View
What is the purpose of the Caption Property property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To display a custom label for a property
Answer: d) To display a custom label for a property
Which of the following is used to create a parameter form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Form Builder
Answer: b) Form Design View
What is the purpose of the Field Properties window in Microsoft Access?
a) To specify the properties of a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To specify the properties of a field
Which of the following is used to create a calculated field in a query in Microsoft Access?
a) Expression Builder
b) Query Design View
c) Form Design View
d) Report Design View
Answer: a) Expression Builder
What is the purpose of the Format property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To define the display format of a field or control
Answer: d) To define the display format of a field or control
Which of the following is used to define the layout and formatting of a form in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Table Design View
Answer: b) Form Design View
What is the purpose of the Input Mask Wizard in Microsoft Access?
a) To format data as it is entered in a field
b) To create relationships between tables
c) To perform calculations on data
d) To import data from external sources
Answer: a) To format data as it is entered in a field
Which of the following is used to create a parameter query in Microsoft Access?
a) Query Design View
b) Form Design View
c) Report Design View
d) Parameter Query Builder
Answer: a) Query Design View
What is the purpose of the Control Source property in Microsoft Access?
a) To specify the data type of a field
b) To create relationships between tables
c) To perform calculations on data
d) To bind a control to a field or expression
Answer: d) To bind a control to a field or expression
0 Comments