Computer Awareness Set- 25 (MS Acess)

Which object in Microsoft Access is used to automate repetitive tasks and perform complex actions using a visual interface?

Which option in Microsoft Access allows you to create a report that displays data in a columnar format, with each record on a separate line?

Which feature in Microsoft Access allows you to create a chart or graph based on data from a table or query?

The Fill/Back Color button on the formatting toolbar applies color to:

Which property in Microsoft Access allows you to specify the format in which data is displayed in a field, such as currency or date format?

Which option in Microsoft Access allows you to create a query that combines records from two or more tables, including records that have no matching values?

Which feature in Microsoft Access allows you to create custom error messages, prompts, and input masks for data entry?

In Access to switch between Edit mode (with insertion point displaye(D)

Which option in Microsoft Access allows you to create a calculated field that performs arithmetic or logical operations on existing fields?

Which option in Microsoft Access allows you to create a report that displays data in a grouped format, with subtotals and grand totals ?

Which object in Microsoft Access is used to store pre-written SQL statements for reuse in queries or other objects?

Which feature in Microsoft Access allows you to create a navigation menu that provides easy access to different forms and reports in your database?

In access press to Move to the next page of the wizard

Which option in Microsoft Access allows you to create a relationship between tables based on a common field?

Which option in Microsoft Access allows you to create a query that combines data from multiple tables based on matching fields?

Which feature in Microsoft Access allows you to create a calculated field that performs mathematical or logical operations on other fields?

Which feature in Microsoft Access allows you to create a parameter query where the user is prompted to enter a value when the query is run?

Which property in Microsoft Access allows you to specify the maximum number of characters that can be entered into a text field?

In Access to open the Find tab in the Find and Replace dialog box (Datasheet view and Form view only)

The following database object can you import from one Microsoft Access database to another?

Which option in Microsoft Access allows you to create a new database by selecting a template with predefined objects and settings?

Which option in Microsoft Access is used to create a form that displays data from multiple related tables?

Which property in Microsoft Access allows you to specify the maximum number of characters that can be entered into a memo field?

Which option in Microsoft Access allows you to create a summary of data grouped by one or more fields?

Which feature in Microsoft Access allows you to create a backup copy of your database at regular intervals?

Which feature in Microsoft Access allows you to create custom navigation menus or toolbars for your database application?

In Access press CTRL+F8 to

Which feature in Microsoft Access allows you to create custom calculations and perform advanced data manipulation using SQL statements?

Which option in Microsoft Access allows you to compact and repair a database to fix any issues and optimize performance?

Which property in Microsoft Access allows you to specify whether a field must contain a unique value or can have duplicate values?

Which option in Microsoft Access allows you to create a new record in a table or form?

Which feature in Microsoft Access allows you to create a form that displays data from multiple tables in a tabular format?

Which property in Microsoft Access allows you to specify the data type of a field?

Which object in Microsoft Access is used to define a set of rules that determine how data should be displayed, validated, or processed?

Which property in Microsoft Access allows you to specify whether a field must contain a value or can be left empty?

Which property in Microsoft Access allows you to specify a default value that is automatically entered into a field when a new record is created?

Which option in Microsoft Access allows you to create a report that displays data in a tabular format with rows and columns?

Which option in Microsoft Access allows you to create a new table by importing data from an external file?

Which option in Microsoft Access allows you to compact and repair a database to fix any issues and reduce file size ?

Which feature in Microsoft Access allows you to import data from external databases, such as SQL Server or Oracle?