This assessment is a gauge to estimate your knowledge of MS Access Relational Database Design. The results will help you and the instructor determine how you may need to spend more time learning about MS Access capabilities as they relate to Relational Database Design (building lists).
After reviewing the Relational Database Design handout, take a few moments to answer the questions below. Do NOT review the material untial after you have answered the questions. Be sure that you have a thorough understanding of the questions and correct answers before attending the Access Essentials training Read moresession.
Stores data
Sorts data
Filters data
Analyzes data
Rate this question:
True
False
Rate this question:
You have one table with a large number of fields that don't all relate to the same subject.
You have fields that are intentionally left blank in many records because they aren't appliable to those records.
You have a large number of tables, many of which contain the same fields.
All of the above.
Rate this question:
Talking to the people who will use the database.
Brainstorming about the questions you'd like the database to answer.
Sketching out the reports you'd like it to produce.
Gathering the forms you currently use to record your data.
All of the above.
Rate this question:
Identifying the end users
Building forms and reports
Determing the tables you'll need
None of the above
Rate this question:
Related to addressed.
Characteristics of the table.
A place to store extra information that you may need later.
Derived or calculated data.
Rate this question:
Relate each field directly to the subject of the table.
Avoid derived or calculated data.
Include all the information you need.
Store information in its smallest logical parts.
All of the above.
Rate this question:
The primary key of the table
An identifier field
The unique record
None of the above
Rate this question:
That you store related data in separate tables and then define relationships between the tables.
That information about relatives is stored in tables.
That relationships are used to find associated information stored in the database.
A and C above.
Rate this question:
Parent-to-child, sister-to-brother and cousin-to-cousin relationships.
Hierarchical, flat and layered relationships.
One-to-many, many-to-many and one-to-one relationship.
Simple, complex and multiple relationships.
Rate this question:
Did you forget any fields? Is there information that you need that isn't included? If it's information about something else, you may need to create another table.
Did you choose a good primary key for each table? If you use it to search for specific records, is it easy to remember and type? Make sure that you won't need to enter a value in a primary key field that duplicates another value in the field.
Are you repeatedly entering duplicate information in one of your tables? If so, you probably need to divide the table into two with a one-to-many relationship.
Do you have tables with many fields, a limited number of records, and many empty fields in individual records? If so, think about redesigning the table so it has fewer fields and more records.
All of the above.
Rate this question:
Purpose - determine your purpose and choose which facts to store. Tables - separate subjects such as "Manufacturer" and "Address". Fields - Decide what information to keep within each table. Relationships - Review each table and decide how the data in one table is related to the data in other tables. Analyze - your design for errors and refine if necessary.
Categorize each field after deciding on your purpose and use the SAVE AS feature to insure your work is not lost. Then, sort the tables so as to eliminate any errors before printing.
Purpose, tables, fields and categories are the primary steps involved ending with a careful analysis and check for errors.
Rate this question:
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.