Podcast
Questions and Answers
Which of the following is not a suggested guideline for table design?
Which of the following is not a suggested guideline for table design?
What determines the amount of space a field uses in a database?
What determines the amount of space a field uses in a database?
In which view can the table be when entering, deleting, or editing data?
In which view can the table be when entering, deleting, or editing data?
Which statement about importing data into Access is true?
Which statement about importing data into Access is true?
Signup and view all the answers
What is the main reason to set a validation rule in Access?
What is the main reason to set a validation rule in Access?
Signup and view all the answers
An illustration of a one-to-many relationship would be:
An illustration of a one-to-many relationship would be:
Signup and view all the answers
Where must a query’s specifications be entered regarding the records to include?
Where must a query’s specifications be entered regarding the records to include?
Signup and view all the answers
When adding date criteria in Query Design view, what delimits the dates you enter?
When adding date criteria in Query Design view, what delimits the dates you enter?
Signup and view all the answers
Study Notes
Table Design Guidelines
- Avoid date arithmetic in table design.
- Store data in smallest parts possible.
- Include necessary data in the table.
- Link tables using common fields.
Field Size Determination
- Field size is not the primary determinant for field space; data type is.
Data Entry, Deletion, and Editing
- Data can be entered, deleted, and edited in Datasheet view.
Importing Data into Access
- The Import Wizard can import data from various sources, not only Excel.
- The wizard is on the External Data tab, not Create.
- You cannot assign a primary key during import.
- Imported table designs can be modified in Access.
Validation Rules
- Validation rules restrict incorrect entries.
One-to-Many Relationships
- A customer can have multiple accounts (one-to-many).
Query Specifications in Design View
- Query specifications for records to include are entered on the Criteria row.
Date Criteria in Query Design
- Dates in queries are delimited by pound signs (#).
Query Copying vs. Creating
- Copying an existing query is more efficient if the new query uses the same tables & fields and has similar criteria.
Access Query Wizard
- Criteria can be added in the Query Wizard.
- Related tables can be selected.
- Fields of various data types are permissible.
- Summarizing data is not mandatory with the Query Wizard.
Studying That Suits You
Use AI to generate personalized quizzes and flashcards to suit your learning preferences.
Description
Test your knowledge on essential database design guidelines and principles. This quiz covers topics such as table design, data entry, validation rules, and relationships in databases. Ideal for students and professionals looking to solidify their understanding of database management systems.
