MS Access
WHAT IS A DATABASE?
Databases allow you to store vast amounts of information so that you can keep track of it. Once the information is stored you can create objects such as queries, forms, reports. You are able to display information quickly and easily.
Examples of places that may use databases
Invercargill Medical Centre to store information on patients
WHY DATABASES?
Databases allow you to store vast amounts of information so that you can keep track of it. Once the information is stored you can create objects such as queries, forms, reports. You are able to display information quickly and easily.
WHY WE SHOULD USE A DATABASE IN OUR WEBSITES?
data storage
fast data processing
ease of changes to data
ADVANTAGES
Allow for multiple searches.
Sorting is quicker and easier.
They can be easily backed up.
They can link with other computer programs like Word Processing.
DISADVANTAGES:
Time consuming to learn new software - this you should feel.
Examples of ONLINE databases
LEARNING TASKS SHEET
MORE RESOURCES
Here is the link to the playlist on YouTube for more information on MS Access.
In this video playlist, you'll get to know the functions and features of Access 2019, Access 2016, and Office 365. Visit https://edu.gcfglobal.org/en/access/ for our text-based tutorial.
With this video series, you'll understand how to use the powerful tools in Access 2019, Access 2016, and Office 365 to produce forms, queries, and reports, including designing multi-table queries, modifying tables, and designing your own database.
Note: MS Access is cover more in NCEA Level 1 for Digital Technology Media and Level 2 SQL (Structured Query Language) in Digital Technology Programming.