Unit 5 Competency 3 - Perform database applications.
Suggested Objective a: Demonstrate the use of a database
There are many great resources available for learning to use Microsoft Access database. Several resources are provided on this page. Many come from GCF LearnFree. The GCF Learn Free links have several pages to each topic and will need to be "clicked through" to see all of the information as well as any videos watched. Others are videos from different people. Click each link and take notes as needed to learn how to use Access.
Introduction to Databases Links to an external site.
Introduction to Objects Links to an external site.
Getting Started in Access Links to an external site.
Managing Databases and Objects Links to an external site.
The next tutorial is a 31 page "book" created by teachers at Northwest Rankin Middle School. It is very detailed and will guide you through MANY of the concepts for this page and more. Look closely at the information and read thoroughly for understanding.
Microsoft_Access_2010-3.pdf Download Microsoft_Access_2010-3.pdf
Access 2010: Introduction to Databases
Links to an external site.
Access 2013: Getting around in Access 2013
Links to an external site.
Access 2013: Working with Databases
Links to an external site.
Suggested Objective b: Create and modify forms and tables in a database
Access allows a user to create forms and tables for records management. These forms and tables may need to be be modified at some point. Learn how to do these activities by clicking the links below to read the provided information or watch the videos. Be sure to take notes.
Working with Tables Links to an external site.
Working with Forms Links to an external site.
Modifying Tables Links to an external site.
Creating Forms Links to an external site.
Formatting Forms Links to an external site.
Tables: How to Create Calculated Fields and Total Rows Links to an external site.
Access 2010: Introduction to Objects
Links to an external site.
Access 2013: Working with Tables
Links to an external site.
Access 2013: Customizing Tables
Links to an external site.
Access 2013: Working with Forms
Links to an external site.
Access 2013: Modifying Tables
Links to an external site.
Access 2013: Creating Forms
Links to an external site.
Access 2013: Customizing Form Settings
Links to an external site.
Access 2013: Formatting Forms
Links to an external site.
Suggested Objective c: Enter and update records in a database
We have learned how to create tables and forms. Now let's see how to add data into our database. Look at the information below.
Designing Your Own Database Links to an external site.
Adding Records in Access 2010
Links to an external site.
Microsoft Access 2010 - Editing Records in a Table - Tutorial
Links to an external site.
Suggested Objective d: Sort records in a database
Finally, for this page of information, we will learn how to sort and filter our database information. Not everything in a database is needed for viewing at one time. You may need to filter for certain records. You may need to sort the records. Let's learn how to perform these actions by looking at the information below.
Sorting and Filtering Records Links to an external site.
Access 2013: Sorting and Filtering
Links to an external site.