McqMate
These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: MCQ on Computer Softwares , Common Topics in Competitive and Entrance exams , Microsoft Office .
| 501. |
Which of the following columns does not exist in macro design window? |
| A. | Arguments |
| B. | Comments |
| C. | Conditions |
| D. | Actions |
| Answer» C. Conditions | |
| 502. |
What is the type of query that extracts data from a table and puts them into separate table? |
| A. | Parameter query |
| B. | Make table query |
| C. | Update query |
| D. | Put table query |
| Answer» B. Make table query | |
| 503. |
What type of control in a form can display data from database table? |
| A. | Bound control |
| B. | Unbound control |
| C. | Both of above |
| D. | None of above |
| Answer» A. Bound control | |
| 504. |
To display value from table for a label control |
| A. | Set teh control source and record source prom property panel |
| B. | Choose the databse, table, field and select data value to display |
| C. | Look at the table and type value in the caption |
| D. | Set the record source property and then control source |
| Answer» D. Set the record source property and then control source | |
| 505. |
Which of the following is not a section in report design window? |
| A. | Report header section |
| B. | Page header section |
| C. | Summary section |
| D. | Report footer section |
| Answer» C. Summary section | |
| 506. |
You can not import data into access database from |
| A. | Dbase iii database files |
| B. | Excel spreadsheets |
| C. | Comma delimited text files |
| D. | None of the above |
| Answer» D. None of the above | |
| 507. |
Which control does access use to link data access page components to Access data? |
| A. | Microsoft dynamic data control |
| B. | Microsoft data connection control |
| C. | Microsoft office data source control |
| D. | None of the above |
| Answer» C. Microsoft office data source control | |
| 508. |
which program do you use to edit code for data access pages? |
| A. | Microsoft script editor |
| B. | Microsoft code editor |
| C. | Microsoft data access pages editor |
| D. | None of above |
| Answer» A. Microsoft script editor | |
| 509. |
the way a particular application views the data from the database that the applicaton uses is a |
| A. | Module |
| B. | Relational model |
| C. | Schema |
| D. | Sub-schema |
| Answer» D. Sub-schema | |
| 510. |
which of the following is a database management system? |
| A. | Ms-word |
| B. | Lotus 1-2-3 |
| C. | Oracle |
| D. | None of above |
| Answer» C. Oracle | |
| 511. |
what is the corresponding text for the <#1/1/95# validation rule setting? |
| A. | Neter a value less or more than 1,195 |
| B. | Value must be less than 95 characters |
| C. | Enter a date before 1995 |
| D. | All of above |
| Answer» A. Neter a value less or more than 1,195 | |
| 512. |
what is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members? |
| A. | Object viewer |
| B. | Object browser |
| C. | Type library spy |
| D. | None of above |
| Answer» B. Object browser | |
| 513. |
a computer language for informing the dbms regarding the data structure used is |
| A. | Pascal |
| B. | Ddl |
| C. | Prolog |
| D. | Fortran |
| Answer» B. Ddl | |
| 514. |
which of the following is not a data type |
| A. | Picture/graphic |
| B. | Data/time |
| C. | Texst |
| D. | Number |
| Answer» A. Picture/graphic | |
| 515. |
the executive responsible for the data processing function in an organization is |
| A. | Pm |
| B. | Dbms |
| C. | Dp |
| D. | Dpm |
| Answer» B. Dbms | |
| 516. |
which of the following is not a type of Microsoft Access database object? |
| A. | Queries |
| B. | Workbooks |
| C. | Forms |
| D. | Tables |
| Answer» B. Workbooks | |
| 517. |
a file containing relatively permanent data is |
| A. | Random file |
| B. | Transaction file |
| C. | Master file |
| D. | Sequential file |
| Answer» C. Master file | |
| 518. |
the complete picture of data stored in database is known as |
| A. | Record |
| B. | Scheme |
| C. | System flowchart |
| D. | Dbms |
| Answer» B. Scheme | |
| 519. |
a subset of characters within a data field is known as |
| A. | Record |
| B. | File |
| C. | Data string |
| D. | Byte |
| Answer» C. Data string | |
| 520. |
data items groped together for storage purposes are called a |
| A. | Record |
| B. | Title |
| C. | List |
| D. | String |
| Answer» A. Record | |
| 521. |
which of the following terms does not describe a database structure used by a dbms to link data from several files? |
| A. | Relational |
| B. | Structural |
| C. | Network |
| D. | All of the above |
| Answer» B. Structural | |
| 522. |
in a relational schema, each tuple is divided into fields called |
| A. | Relations |
| B. | Domains |
| C. | Queries |
| D. | All of the above |
| Answer» B. Domains | |
| 523. |
how do you filter by selection? |
| A. | Right click the field value and select filter by selection from the shortcut menu |
| B. | Find and double click the value on which you want to base the filter |
| C. | Find and select the value on which you want to base the filter and select tools>filter by selection from the menu |
| D. | None |
| Answer» A. Right click the field value and select filter by selection from the shortcut menu | |
| 524. |
what is a fast way t adjust the width of a column? |
| A. | Right click the left side of the column heading |
| B. | Double click the left side of the column heading |
| C. | Double click the right side of the column heading |
| D. | Select tools>adjust column width from the menu |
| Answer» C. Double click the right side of the column heading | |
| 525. |
what are the columns in a Microsoft Access table called? |
| A. | Rows |
| B. | Fields |
| C. | Cells |
| D. | Records |
| Answer» B. Fields | |
| 526. |
how do you update pivot table report data after changes are made to the source data? |
| A. | Save your changes, close the workbook, and then reopen it. |
| B. | Select the pivot table worksheet and press f9 on the keyboard |
| C. | Click the report, and on the pivot table toolbar, click the refresh data button |
| D. | All of the above |
| Answer» C. Click the report, and on the pivot table toolbar, click the refresh data button | |
| 527. |
In access, the best types of queries to use for data analysis are: |
| A. | Select queries |
| B. | Parameter queries |
| C. | Action queries |
| D. | All of the above |
| Answer» A. Select queries | |
| 528. |
How can you add a table to the relationship window? |
| A. | Select tools>add table from the menu |
| B. | Select the table from the table list on the toolbar |
| C. | Click the show table button on the toolbar |
| D. | Select edit>add table from the menu |
| Answer» B. Select the table from the table list on the toolbar | |
| 529. |
What is the first step in creating a form or report with the form wizard or report wizard? |
| A. | Selecting the fields that you want to appear in the form or report |
| B. | Selecting the underlying table or query on which you want to base the form or report |
| C. | Reading several screens of mostly useless information and clicking next |
| D. | Selecting how the form or report should be formatted |
| Answer» B. Selecting the underlying table or query on which you want to base the form or report | |
| 530. |
Which action will optimize your database performance? |
| A. | Set the record set type to snapshot |
| B. | Use the compact and repair database tool |
| C. | Create a replica of the database |
| D. | All of the above |
| Answer» B. Use the compact and repair database tool | |
| 531. |
The arranging of data in a logical sequence is called |
| A. | Sorting |
| B. | Classifying |
| C. | Reproducing |
| D. | Summarizing |
| Answer» A. Sorting | |
| 532. |
According to access help, what’s a good way to design a database? |
| A. | Start from data access pages and work backward |
| B. | Sketch the design of your database using a pencil and paper |
| C. | Use the table analyzer to reverse-engineer your flat source data. |
| D. | None of above |
| Answer» B. Sketch the design of your database using a pencil and paper | |
| 533. |
If a piece of data is stored in two places in the database, then |
| A. | Storage space is wasted |
| B. | Changing the data is one spot will cause data inconsistency |
| C. | It can be more easily accessed |
| D. | Both a and b |
| Answer» D. Both a and b | |
| 534. |
A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As |
| A. | Tables |
| B. | Relations |
| C. | Tuple |
| D. | Both a and b |
| Answer» D. Both a and b | |
| 535. |
Which of the following database objects asks a question of information in a database and then displays the result? |
| A. | Tables |
| B. | Reports |
| C. | Queries |
| D. | Forms |
| Answer» C. Queries | |
| 536. |
What data type should yo choose for a zip code field in a table? |
| A. | Text |
| B. | Number |
| C. | Memo |
| D. | All of above |
| Answer» A. Text | |
| 537. |
In order to use dbms, it is important to understand |
| A. | The physical schema |
| B. | All sub schemas that the sytem supports |
| C. | One sub schema |
| D. | Both a and b |
| Answer» C. One sub schema | |
| 538. |
A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be |
| A. | The pin code |
| B. | The last name |
| C. | A compound key consisting of the first name and the last name |
| D. | All of the above |
| Answer» C. A compound key consisting of the first name and the last name | |
| 539. |
What happens when you add the asterisk (*) from any field list ot a query? |
| A. | The table will not include any fields from the table |
| B. | The query sorts the table’s record in the order you specify |
| C. | The query will include every field from the table |
| D. | The query uses the records from the table without displaying them |
| Answer» C. The query will include every field from the table | |
| 540. |
The filter by selection feature allows you to filter: |
| A. | Those records that match an entity in a field |
| B. | Records based on a criterion you specify |
| C. | Records that meet any of several criteria you specify |
| D. | All of above |
| Answer» A. Those records that match an entity in a field | |
| 541. |
What is the memo data type field used for? |
| A. | To add table |
| B. | To store objects created in other programs |
| C. | For long text entries |
| D. | For shout text entries of no more than 255 characters |
| Answer» C. For long text entries | |
| 542. |
What is the purpose of the description column in table design view? |
| A. | To define the data type applied to each field within the table |
| B. | To describe the data that should be entered in each field |
| C. | To enter lookup data that the field should refer to. |
| D. | None of the ablve |
| Answer» B. To describe the data that should be entered in each field | |
| 543. |
Which of the following is not a selection technique |
| A. | To select a word, double click the word |
| B. | To select an entire table click the empty bosx to the left of the field names |
| C. | To select a row, click the record selector box to the left of the row |
| D. | To select a column, double click anywhere in the column |
| Answer» D. To select a column, double click anywhere in the column | |
| 544. |
How can you display pivot table report summary data in a currency format? |
| A. | Use custom calculation |
| B. | Type in the currency symbol |
| C. | Modify the field settings |
| D. | None of the above |
| Answer» C. Modify the field settings | |
Done Studing? Take A Test.
Great job completing your study session! Now it's time to put your knowledge to the test. Challenge yourself, see how much you've learned, and identify areas for improvement. Don’t worry, this is all part of the journey to mastery. Ready for the next step? Take a quiz to solidify what you've just studied.