ACTIVITY 8: MICROSOFT ACCESS DATABASE WORK ENVIRONMENT AND BENEFITS OF USING ACCESS DBMS

1. One advantage of Excel over Access is that Excel is easy to _______ and easy to use.

 2. Excel become problematic as the data ______ and _____ over time.

3. Spreadsheets are not ideal for handling hundreds of ________ when creating an important file for a client, a contact or an executive. 

4. It’s very easy to make _______ in a spreadsheet, which then makes analysis, summing and reporting very challenging.

5. Microsoft Access is an __________ tool, or ________, database that helps you store information for reference, reporting and analysis. 

6. Access can also overcome the ___________ found when trying to manage large amounts of information in Excel or other spreadsheet applications. 

7. One of the reasons why Microsoft Access is consistently the database of choice is the _______ of development.

8. Since Access is a Microsoft Office product, it has been designed to be______ with other products in the Microsoft Office Suite.

9. What is the full meaning of ODBC ?

10. The ability of Access to maintain the data format of data after importing data thereby ensuring that the data property is not lost is known as _______ data. 

11. One of the benefits of using Microsoft Access is its __________ which contains not only the application but also the data in one file. 

12. Upgrading an Access database system is attainable without difficulties. This property is known as _________

13. In Access, what is the full meaning of ADP?

14. Why is a unique identifier important in a database?


Comments

Post a Comment

Popular Posts

Suremoneyng Investment Review: Legit or Scam

What is Suremoneyng Investment? Suremoneyng Investment is a funding network, can also be called a Ponzi Scheme because of its operation, However Suremoneyng investment platform promises investors 100% profit on their investment. The first investment gets this 100% after 5 days. What’s more is that Suremoneyng investment allows users to withdraw only the profit amount and then capital when you cycle out. However, there is something I want you to know that majority of the people don’t realize. Suremoney says you get 100% profit on your first investment, but I say no. This is because the system does not allow you to withdraw both your capital and profit at once, when  due until you reinvest. Now, your investment can be anything from N5,000 to N50,000. You are also not allowed to make re-commitments lower than what you invested before. That is, if you invest 10,000 at start, the least amount of re-commitment is 10,000. But you are free to increase your investment. HOW DOES SUREMONEYNG ...
Read more

Dreams And Goals

A dream  or vision chart is a picture you can create using newspaper or magazine clippings that represent your dream, such as quotes or pictures and paste them onto a board. In this post I show you how to create your very own dream or vision chart.   Dreams V’s Goals   Dreams differ from goals in that your Dreams are your big goals. For example retire at 40, travel the world.  These are your dreams. How you get there are your smaller goals. Obviously only you can decide what you want your Dreams to be, but here we look at how you can make them real. How you can make them real is by using a technique called visualisation. This is where you ‘see’ your Dreams through pictures and words – it’s about making your dreams ‘real’ by grouping together pictures of the things that represent your dreams to you. Let me demonstrate this for you. Say you want to buy a new car. Let’s say it’s a BMW. Suddenly, every car you see on the road is a BMW.   Funny thing is, yo...
Read more