1. Which of the following columns does not exist in macro design window?
Correct : C. Conditions
2. What is the type of query that extracts data from a table and puts them into separate table?
Correct : B. Make table query
3. What type of control in a form can display data from database table?
Correct : A. Bound control
4. To display value from table for a label control
Correct : D. Set the record source property and then control source
5. Which of the following is not a section in report design window?
Correct : C. Summary section
6. You can not import data into access database from
Correct : D. None of the above
7. Which control does access use to link data access page components to Access data?
Correct : C. Microsoft office data source control
8. which program do you use to edit code for data access pages?
Correct : A. Microsoft script editor
9. the way a particular application views the data from the database that the applicaton uses is a
Correct : D. Sub-schema
10. which of the following is a database management system?
Correct : C. Oracle
11. what is the corresponding text for the <#1/1/95# validation rule setting?
Correct : A. Neter a value less or more than 1,195
12. 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?
Correct : B. Object browser
13. a computer language for informing the dbms regarding the data structure used is
Correct : B. Ddl
14. which of the following is not a data type
Correct : A. Picture/graphic
15. the executive responsible for the data processing function in an organization is
Correct : B. Dbms
16. which of the following is not a type of Microsoft Access database object?
Correct : B. Workbooks
17. a file containing relatively permanent data is
Correct : C. Master file
18. the complete picture of data stored in database is known as
Correct : B. Scheme
19. a subset of characters within a data field is known as
Correct : C. Data string
20. data items groped together for storage purposes are called a
Correct : A. Record
21. which of the following terms does not describe a database structure used by a dbms to link data from several files?
Correct : B. Structural
22. in a relational schema, each tuple is divided into fields called
Correct : B. Domains
23. how do you filter by selection?
Correct : A. Right click the field value and select filter by selection from the shortcut menu
24. what is a fast way t adjust the width of a column?
Correct : C. Double click the right side of the column heading
25. what are the columns in a Microsoft Access table called?
Correct : B. Fields
26. how do you update pivot table report data after changes are made to the source data?
Correct : C. Click the report, and on the pivot table toolbar, click the refresh data button
27. In access, the best types of queries to use for data analysis are:
Correct : A. Select queries
28. How can you add a table to the relationship window?
Correct : B. Select the table from the table list on the toolbar
29. What is the first step in creating a form or report with the form wizard or report wizard?
Correct : B. Selecting the underlying table or query on which you want to base the form or report
30. Which action will optimize your database performance?
Correct : B. Use the compact and repair database tool
31. The arranging of data in a logical sequence is called
Correct : A. Sorting
32. According to access help, what’s a good way to design a database?
Correct : B. Sketch the design of your database using a pencil and paper
33. If a piece of data is stored in two places in the database, then
Correct : D. Both a and b
34. A relational database management (RDBMS) package manages data in more than one file at once. How does it organize these file? As
Correct : D. Both a and b
35. Which of the following database objects asks a question of information in a database and then displays the result?
Correct : C. Queries
36. What data type should yo choose for a zip code field in a table?
Correct : A. Text
37. In order to use dbms, it is important to understand
Correct : C. One sub schema
38. 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
Correct : C. A compound key consisting of the first name and the last name
39. What happens when you add the asterisk (*) from any field list ot a query?
Correct : C. The query will include every field from the table
40. The filter by selection feature allows you to filter:
Correct : A. Those records that match an entity in a field
41. What is the memo data type field used for?
Correct : C. For long text entries
42. What is the purpose of the description column in table design view?
Correct : B. To describe the data that should be entered in each field
43. Which of the following is not a selection technique
Correct : D. To select a column, double click anywhere in the column
44. How can you display pivot table report summary data in a currency format?