Which report section prints once at the bottom of every printed page?
Database Management Systems are featured with:
The expression builder is an access tool that controls an expression___ for entering an expression
Which of the following is a condensed form of standard generalized markup language?
Queries in access can be used as
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
How can you define a field so that when entering data for that field it will display ****** instead of actual typed text
The executive responsible for the data processing function in an organization is
The _____ Builder is an Access tool for selecting colors from a palette or creating custom colors.
Which is not a view to display a table in Access?
The size of a field with Number data type can not be
What does an inner join display?
What determines a table’s sort order?
This type of query summarizes large amounts of data in easy-to-read, row-and-column format.
A computer language for informing the dbms regarding the data structure used is
A summary query can be created by adding which row to the design grid of a select query?
Which major database object stores all data?
In access, this displays the results of a calculation in a query
The quickest way to add a field to the selected fields list is to double-click its field name in this list.
To create primary key for a table when in design view
If you need to edit a relationship
Which of the following database object is created first before any other created?
Which data type is better to use for storing the price of an item?
A computer language for informing the dbms regarding the data structure used is
Why you can rely on MCQ Sets to prepare your computer jobs exams?
Which of the following properties identifies the type of information stored in a field?
To assign a macro to an event, users need to open the form in Design View.
The ‘filter by selection’ allows you to filter those records
Which function extracts the name of the month from a date/time value?
Which of the following is not a view for interacting with a form object?
What is the propose to a sub datasheet?
In a query when you have multiple conditions and each of them must satisfy to return the result, use
What type of relationship is created when you select a primary key in both related tables?
Which of the following types of joins displays records with the same value in the common field?
Which data type is better to use for storing phone number in the following format “977-1-1234567”?
What is an intersection of a row and a column?
Which of the following views is used to graphically summarize and analyze data in a recordset?
After creating the table which of the following is correct?
In a module, a(n) _______ is a series of commands and properties that perform a specific task.