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... show more 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!!!
2 answers 2