Please review the outline for this class to see if you are comfortable with the technical features from this level. Here are some questions to help determine if this level is right for you.
1. Breaking a table down to more granular tables for greatest efficiency is called
A. Normalizing
B. Restructuring
C. Efficiency
D. None of the above
2. Unmatched queries-
A. Look to see if two tables are properly matched
B. Look to see if there are orphaned records not conforming to relationships
C. Look to see if one query is the same as another
D. None of the above
3. In Design View of a Query you DON’T use the big “E” sigma icon in the ribbon-
A. To build a Totals query that totals and groups data
B. To sum up list of records in a table
C. To aggregate data in a totals query
D. To aggregate data in a totals query based on a function like average
4. A crosstab query mainly-
A. Is used to link data across tables
B. Enables you to see aggregates of data down rows and across columns
C. Pulls up data from many tables simultaneously
D. None of the above
5. What best describes Pivot Table is that it-
A. Enables you to pivot and change your mind
B. Creates aggregate data across rows and columns
C. Enables tables to talk to one another
D. None of the above
6. Which is NOT true of a macro?
A. It enables you to capture a set of steps, and play them back all at once
B. It enables you to save time by not have to go through many steps in your work
C. It speeds up the use and performance of Access
D. It is used mainly to connect two databases
7. Tabbed pages is NOT mainly used to-
A. Make your interface look appealing
B. Organize your access to tables, queries, forms, and reports
C. Have a more professional look
D. Organize Help for users
8. You DON’T normally link Access to this data source:
A. Excel
B. SQL Server
C. Web data
D. PowerPoint
Answers: 1.A 2.B 3.B 4.B 5.B 6.D 7.D 8.D