MS - Access Exam
After right click the field selector button, which do you choose to delete a field in design view?
Which of the following can a Report Wizard NOT do?
Add summary functions
Group fields into more than one Control Layout
Each record is constituted by a number of individual data items which are called
Which of the following field properties is an expression that specifies criteria or requirements for entering data?
Which of the following field properties displays a model or pattern for entering data?
The command center of access file that appears when you create or open the MS Access database file.
Design view window
What is the keyboard shortcut to move to the last records in a table?
A(n) _____ is a control that, when clicked, executes an action or series of actions.
Combo box control
It is a database object to view, change, and analyze data in different ways
None of the above
Which of the following is the DBMS type
Flat File System
All of the Above
Which of the following database object hold data?
This data type allows alphanumeric characters and special symbols.
None of these
When a picture or other graphic image is placed in the report header section it will appear____
Once in the bugging of the report
At the top of every page
Every after record break
On the 1st and last pages of the report
Which of the following is not a logical database structure?
When increasing the Control Padding, space is added where?
Between the content of the controls and the outside edge of then controls
Between all controls
Between the control and the Form\’s edge
Between controls and gridlines
Which of the following is not a data type
How do you update pivot table report data after changes are made to the source data?
Save your changes, close the workbook, and then reopen it.
Select the pivot table worksheet and press f9 on the keyboard
Click the report, and on the pivot table toolbar, click the refresh data button
All of the above
A(n)_______ is a major object that can run independent of a control.
Which of the following SQL query deletes Product table from Store database?
DEL Product FROM Store
DROP TABLE Product
Any of b or c
Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
A collection of related records in database is known as a
None of above
A Smart Tag can be set using the _____ tab in the property sheet.
The operation of checking input data against specified criteria is known as?
When you add fields in ____, a Field List pane displays.
The appropriate Data Type to store Time in MS Access?
Time cannot be stored
To achieve and effect when you are entering criteria in a query design window
Write criteria values vertically one in a row
Write criteria values horizontally
Write criteria values in same field separated with and
Write criteria values in same field separated with &
A(n) __________ is an Extensible Scheme Standard file that is an approved W3C standard design as a basic infrastructure.
Which setting you must modify to print a report using letterhead?
When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.
To sort records in a table
Open table, click on the field on which the sorting is to be done, then click Sort button on database toolbar
Open table, click Sort button on database toolbar, choose field based on which to sort, click OK
Click the field heading to sort it ascending or descending
All of above
Which data type is better to use for storing the price of an item?
What do you mean by one to many relationship between student and class table?
One student can have many classes
One class may have many student
Many classes may have many students
Many students may have manu classes
A database language concerned with the definition of the whole database structure and schema is ________
All of above
The three parts of an IIF function are separated by _____.
Which of the following is a database management system?
Which of the following views enables users to create and modify the sections of a form?
A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
The Input Mask wizard does NOT include the ability to do which of the following?
Force all uppercase
Store symbols with data
Use preset masks
A composite key is
Required when a table does not have any unique fields in it
The primary key with AutoNumber as the field type
Made up of two or more fields to uniquely identify records
Is a foreign key that uniquely identifies records
If you make an invalid entry in the input mask wizard dialog box, this will display to advise you that the entry is not correct
Mark For Review & Next
© Copyright © 2020-2021 MyPariksha.com All Rights Reserved.