Computer Awareness Set- 25 (MS Acess)

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

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

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

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

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?

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

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 custom calculations and perform advanced data manipulation using SQL statements?

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

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

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

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

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

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

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

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 object in Microsoft Access is used to define a set of rules that determine how data should be displayed, validated, or processed?

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 custom navigation menus or toolbars for your database application?

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 format in which data is displayed in a field, such as currency or date format?

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

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 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 new database by selecting a template with predefined objects and settings?

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

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

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

In Access press CTRL+F8 to

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

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

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

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

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 create a calculated field that performs arithmetic or logical operations on existing fields?

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

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

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

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?