What is Access? When would you use Access instead of Excel?

What will be an ideal response?


Access is DBMS (database management system) software that allows you to organize, store, and manipulate data as well as select and report on it. You would use Access when:
a. You need to store data in multiple tables and need relationships between the tables.
b. You have a large amount of data.
c. You have large amountsof nonnumeric data.
d. You want to have many different queries and reports.
e. You have multiple users accessing your data.

Computer Science & Information Technology

You might also like to view...

If the initializer for a const variable is a function call, then the initialization occurs at ________.

a. compile time b. load time c. preprocessor time d. run time

Computer Science & Information Technology

Case-Based Critical Thinking QuestionsCase 4-1Tatiana is building out the details of her project in Resource Sheet view for the first time, so she turns to her colleague Angela for help with the trickier aspects of the work.The photographer Tatiana has hired charges by the day. What does she need to do in the Resource Sheet view to accommodate this?

A. Change the Base Calendar to the daily calendar. B. Enter "per day" as the Cost/Use value. C. Override the Std. Rate default with the /d setting. D. Nothing: this is the default setting.

Computer Science & Information Technology

The protection of the confidentiality, integrity, and availability of information assets, whether in storage, processing, or transmission, via the application of policy, education, training and awareness, and technology is known as ___________.

A. ?communications security  B. ?network security C. ?physical security D. ?information security

Computer Science & Information Technology

The analysis of multi-event patterns is called ________.

A. event scoring B. event correlation C. event aggregation D. event filtering

Computer Science & Information Technology