DH Templates

Microsoft Access 2007 questions, plz help!?

Which of the following is a type of table template? Events Issues Tasks Contacts All of these Question 2 (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 3 (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 4 (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 5 (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 6 (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 7 (Matching Worth 45 points) MatchTermDefinition AccessA) A simple list unrelated to other data ExcelB) Allows you to see what is in your database dataC) Prebuilt databases designed to suit your needs PivotD) Individual items of information relational data structureE) Interactive tables or charts database templatesF) Best program for analyzing data that has been collected Navigation PaneG) Best program for storing and maintaining data flat data structureH) Used to enter information into Access data entry formI) Divides information into logical pieces and places each piece in a separate table Question 8 (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. Question 9 (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 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) 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 12 (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

Public Comments