What Guidelines Should You Follow When Designing A Database

(Correct Answer Below)

Reveal the answer to this question whenever you are ready.

What Guidelines Should You Follow When Designing A Database

ase? 2. What is the purpose of the Data Type property for a Þeld? 3. The property speciÞes how a Þeld's name is displayed in data- base objects, including table and query datasheets, forms, and reports. 4. For which three types of Þelds can you assign a Þeld size? 5. The default Field Size property setting for a Text Þeld is . 6. In Design view, which key do you press to move from the Table Design grid to the Field Properties pane? 7. A(n) value, which results when you do not enter a value for a Þeld, is not permitted for a primary key.1. To insert a check mark in an empty check box for a Yes/No Þeld, you press the . 2. What is the keyboard shortcut for inserting the value from the same Þeld in the previous record into the current record? 3. data is a process that allows you to copy the data from a source without having to open the source Þle. 4. The gallery allows you to add a group of related Þelds to a table at the same time, rather than adding each Þeld to the table individually. 5. What is the effect of deleting a Þeld from a table structure? 6. A(n) text Þle is one in which Þelds of data are separated by a character such as a comma or a tab. 7. The is the "one" table in a one-to-many relationship, and the is the "many" table in the relationship. 8. is a set of rules that Access enforces to maintain consistency between related tables when you update data in a database.
Front

Advertisement

1. Identify all the fields needed to produce the required information, organize each piece of data into its smallest useful part, group related fields into tables, determine each table's primary key, include a common field in related tables, avoid data redundancy, and determine the properties of each field. 2. The Data Type property determines what field values you can enter into the field and what other properties the field will have. 3. Caption 4. Text, Number, and AutoNumber 5. 255 6. F6 7. null Session 2.2 1. spacebar 2. Ctrl + ' 3. Importing 4. Data Type 5. The field and all its values are removed from the table. 6. delimited 7. primary table; related table 8. Referential integrity

About the flashcard:

This flashcard is meant to be used for studying, quizzing and learning new information. Many scouting web questions are common questions that are typically seen in the classroom, for homework or on quizzes and tests. Flashcards vary depending on the topic, questions and age group. The cards are meant to be seen as a digital flashcard as they appear double sided, or rather hide the answer giving you the opportunity to think about the question at hand and answer it in your head or on a sheet before revealing the correct answer to yourself or studying partner. Some questions will include multiple choice options to show you the options involved and other questions will just have the questions and corrects answers. Simply reveal the answer when you are ready to check your work. Absolutely no cheating is acceptable.