DH Templates

Help with computers!?

Question 1 (Multiple Choice Worth 5 points) What is a flat data structure? It is a simple list, not connected to other data. It contains data that is simple and boring. It contains a series of data tables that are unrelated to each other. A complex database that is not related to any other database. -------------------------------------------------------------------------------- Question 2 (Multiple Choice Worth 5 points) What is a relational database structure? It uses multiple tables to organize information; all tables in the database are related in some way. It relates information in one database to information in another database. It analyzes related information in each database. It simply shows the relationships between different data entered for each related database. -------------------------------------------------------------------------------- Question 3 (Matching Worth 45 points) Match Term Definition Access A) Interactive tables or charts Excel B) Best program for storing and maintaining data data C) Best program for analyzing data that has been collected Pivot D) Used to enter information into Access relational data structure E) Divides information into logical pieces and places each piece in a separate table database templates F) Prebuilt databases designed to suit your needs Navigation Pane G) A simple list unrelated to other data flat data structure H) Individual items of information data entry form I) Allows you to see what is in your database -------------------------------------------------------------------------------- Question 4 (Multiple Choice Worth 5 points) You should use Access when: You need a relational data structure Multiple users need to work on the data at the same time You have a large amount of text data All of the above -------------------------------------------------------------------------------- Question 5 (Multiple Choice Worth 5 points) How do you know if you need a relational structure? When you have repeated data and/or you need to track actions or events For a family tree where everyone is related Have a small amount of information that needs to be analyzed Have to perform a lot of calculations with the data -------------------------------------------------------------------------------- Question 6 (Multiple Choice Worth 5 points) How do you base a new report on an existing table? Copy and paste the table data into the new report Select the table in the Navigation Pane and click Report on the Create tab Click Microsoft Office Button, Save As, Report On the Create tab, in the Reports group, click New Table -------------------------------------------------------------------------------- Question 7 (Multiple Choice Worth 5 points) What's the fastest way to create a database for your contacts? Click Contacts from Featured Online Templates Click Blank Database Go to Google and search for one Click Assets from Featured Online Templates -------------------------------------------------------------------------------- Question 8 (Multiple Choice Worth 5 points) What are Access templates? Forms to be completed by the user Pre-built databases for specific tasks Ideas for new databases None of these -------------------------------------------------------------------------------- Question 9 (Multiple Choice Worth 5 points) What is available on the Getting Started page? Online Database Templates Blank Database button Previously created databases All of these -------------------------------------------------------------------------------- Question 10 (Multiple Choice Worth 5 points) Where can you see what items (such as tables, forms, reports, queries) are in the database you are using? Navigation Pane Home tab External Data tab Database Tools tab -------------------------------------------------------------------------------- Question 11 (Multiple Choice Worth 5 points) Which of the following is a type of table template? Events Issues Tasks Contacts All of these -------------------------------------------------------------------------------- Question 12 (Multiple Choice Worth 5 points) Which of the following are true statements about Excel and Access? Access is designed for relational data while Excel is best for flat data structures. Excel is designed for relational data while Access is best for flat data structures. Access and Excel are both designed for relational data; Access is just a simpler program for beginners. Access and Excel are both designed for flat data; Excel is just a simpler program for beginners.

Public Comments

1. i think you need to search the answers using google not answers