DH Templates

Microsoft Access Help Please?

1)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 2)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 3)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 4)What is available on the Getting Started page? Online Database Templates Blank Database button Previously created databases All of these 5)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. 6)Which of the following is a type of table template? Events Issues Tasks Contacts All of these 7)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 8)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. 9)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 10)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 11)What are Access templates? Forms to be completed by the user Pre-built databases for specific tasks Ideas for new databases None of these If you don't want to help that's fine, no need to say anything like 'do your own homework!'. I have read the freaking tutoral like twice and I'm still really confused! Please help?? Answers greatly appreciated!!! Thanks!!!

Public Comments

1. WoW Eryn, i hope i don't get to fix your access programming one day......but hey im all for cheatery 1.)You should use Access when: All of the above 2)What's the fastest way to create a database for your contacts? Click Contacts from Featured Online Templates 3)Where can you see what items (such as tables, forms, reports, queries) are in the database you are using? Navigation Pane 4)What is available on the Getting Started page? All of these 5)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. 6)Which of the following is a type of table template? All of these 7)What is a flat data structure? It is a simple list, not connected to other data. 8)What is a relational database structure? It uses multiple tables to organize information; all tables in the database are related in some way. 9)How do you know if you need a relational structure? When you have repeated data and/or you need to track actions or events 10)How do you base a new report on an existing table? Select the table in the Navigation Pane and click Report on the Create tab 11)What are Access templates? Pre-built databases for specific tasks If you want to impress them tell them you think the Nz function is much more useful than writing IIF(IS NULL()) statements.