Over a Decade of Serious Learning for Ambitious Minds. * 9.5 of 10 (over 18 k student survey results - 2020)

Find A Class in Your City:


Access Introduction Assessment / Quiz

Email this page | Print this page

Access Introduction Assessment / Quiz


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. A relational database means-

          A. The database fields in a single table are related to one another

B. The databases’ tables are related to one another through a common field

C. You can only have one table per database file

D. The database is related to an Excel file all the time


2. The primary key is used to-

A. Link that field to another similar field in another table

B. Focus on that field for presentation purposes

C. Indicate that it is the most important field in the table

D. Solely make the database run faster


3.  In creating table relationships you are for the most part-

            A. Indicating which table is higher in the hierarchy

            B. Linking common fields across two or more tables to enable powerful queries

            C. You are making the database run faster and smoother

            D. Increasing the number of records you can enter into the system

 

4. The order of creating a database is-

A. Enter the records first, then build the structure, queries, forms, etc.

B. As you design each field, enter appropriate data into that field in Datasheet view

C. Design the fields for the table first, enter some data, and build queries, forms, reports

D. Just enter data into Datasheet view, and Access will build  the design for you


5. The essential things you do in a query are-

A. Select one or more tables, select fields, select sorts, add criteria, and run it

B. Build spreadsheet like calculations in the query

C. Group records together for building reports

D. Relate tables together for reports


6. A form is essentially used to-

A Select desired records

B. See multiple records at once

C. See one record fully at a time

D. Prepare to build reports.


7. A report has the following central attribute-

            A. Its got all the records in one place

            B. It is a way to combine tables into queries

  C. It enables you to create and view presentable data with groupings of information

            D. It is a substitute for using tables and queries to view outputs


8. Groupings of data in a report enable--

            A. Records to be seen per category, such as by individual customer or product

            B. Connecting of information from various tables together

  C. You to see how one table’s data is related to another

            D. You to  make the database run faster



Answers: 1. B, 2. A, 3. B, 4. C, 5. A, 6. C, 7. C, 8. A