Question:
Anyone have the answers to the Microsoft access exam. I'm taking CGS and have the test tomorrow?
bob s
2008-12-03 20:03:37 UTC
1. (Points: 1)
A ____ is a question you ask about data stored in a database.

1. report
2. query
3. macro
4. form
Save Answer

2. (Points: 1)
In Datasheet view, clicking a row selector selects an entire ____.

1. record
2. field
3. array
4. attribute
Save Answer

3. (Points: 1)
In Datasheet view, the star symbol that appears in the record selector area always identifies the ____ in the database.

1. next available row for a new record
2. first record
3. current field
4. first field
Save Answer

4. (Points: 1)
The first step in organizing data into a database is to define the ____.

1. records
2. fields
3. reports
4. formats
Save Answer

5. (Points: 1)
The three basic steps to creating a database, in order, are: ____.

1. group fields in a table, identify the individual fields, enter field values for each record
2. identify the individual fields, group fields in a table, enter field values for each record
3. enter field values for each record, group fields in a table, identify individual fields
4. group fields in a table, identify individual fields, enter field values for each record
Save Answer

6. (Points: 1)
A field can be described as a(n) ____.

1. attribute
2. table
3. object
4. record
Save Answer

7. (Points: 1)
A field, or a combination of fields, that has a unique value is a ____.

1. table
2. foreign key
3. primary key
4. relation
Save Answer

8. (Points: 1)
A primary key ____.

1. has the same value for all records
2. must contain a unique value for each record within the table
3. consists of only one field
4. is not usually necessary
Save Answer

9. (Points: 1)
A relational database management system’s data is organized as a collection of ____.

1. tables
2. elements
3. records
4. common fields
Save Answer

10. (Points: 1)
An example of a relational DBMS is ____.

1. Word
2. Excel
3. Access
4. PowerPoint
Save Answer

11. (Points: 1)
Most current database management systems are called ____ database management systems.

1. relational
2. hierarchical
3. elemental
4. linked
Save Answer

12. (Points: 1)
When you first start Access, the program window that appears is the ____ window.

1. Navigation Pane
2. Getting Started with Microsoft Office Access
3. Open Database
4. Database
Save Answer

13. (Points: 1)
Diane is working in the customer table and needs to know if any customers are located in Texas. To find this information, she would ____.

1. create a query
2. define a new table
3. access the Database Wizard
4. define a new form
Save Answer

14. (Points: 1)
Access can guide you through the steps to create a query by using the Query ____.

1. Creator
2. Manager
3. Generator
4. Wizard
Save Answer

15. (Points: 1)
You can move to each subsequent step in any Wizard dialog box by clicking the ____ button.

1. Finish
2. Advance
3. Next
4. New
Save Answer

16. (Points: 1)
After all selection and field information has been entered in the Simple Query Wizard, you complete the query definition by clicking the ____ button.

1. Save
2. Finish
3. Design
4. Next
Save Answer

17. (Points: 1)
Data can be formatted prior to printing by creating a ____.

1. report
2. new database
3. spreadsheet
4. table
Save Answer

18. (Points: 1)
____ a database rearranges data and objects in a database to make its size smaller.

1. Compacting
2. Realigning
3. Customizing
4. Compressing
Save Answer

19. (Points: 1)


In the figure above, each column represents a ____.

1. field
2. table
3. primary key
4. record
Save Answer

20. (Points: 1)


In the figure above, Owen is a ____.

1. field
2. field value
3. key
4. record
Save Answer

21. (Points: 1)


In the figure above, the last row of data shown (11053, Hwan, Tang, etc.) is a ____.

1. key
2. record
3. table
4. field
Save Answer

22. (Points: 1)


In the figure above, there are ____ fields shown.

1. 6
2. 5
3. 3
4. 4
Save Answer

23. (Points: 1)
Which extension identifies a file as a Microsoft Access 2007 database?

1. .adb
2. .acc
3. .accdb
4. .mdb
Save Answer

24. (Points: 1)


In the figure above, the large arrow labeled 1 is used to ____.

1. select all the records in the table
2. navigate to the next record
3. select the current record
4. copy the records in the table
Save Answer

25. (Points: 1)


In the figure above, the large arrow labeled 2 shows the ____.

1. current field value
2. name of the table
3. scroll bar
4. field name
Save Answer

26. (Points: 1)


In the figure above, the large arrow labeled 3 is used to ____.

1. switch to
Three answers:
Terence S
2008-12-05 18:42:10 UTC
Hey here are the answers to questions 1-13. If you need the rest of them; just reply to this as soon as possible!!! I am assuming that you have the test at UCF in the morning. So do I!!!!

1- query

2-record

3- next availibe row for a new record

4- fields

5- answer# 2

6- attribute

7- primary key

8- must contain a unique value

9- tables

10- access

11- relationsl

12- gettin started with microsoft

13- create a query
Felicio
2015-08-18 15:03:41 UTC
This Site Might Help You.



RE:

Anyone have the answers to the Microsoft access exam. I'm taking CGS and have the test tomorrow?

1. (Points: 1)

A ____ is a question you ask about data stored in a database.



1. report

2. query

3. macro

4. form

Save Answer



2. (Points: 1)

In Datasheet view, clicking a row selector selects an entire ____.



1. record

2. field

3. array

4. attribute

Save...
roy
2014-09-02 08:30:54 UTC
What restrictions does the Simple Query Wizard have for creating queries?


This content was originally posted on Y! Answers, a Q&A website that shut down in 2021.
Loading...