- 0 (Registered)
This course introduces the basics of database development. It draws a brief comparison between Spreadsheet applications and database applications. Students will have a working knowledge of database structure and how it is implemented.
Microsoft Access (ver 2007 or higher) is the database application that will be used throughout this lesson. Microsoft Access is included in any Microsoft Office Professional suite from Microsoft.
On completion of this course students should be able to:
- Identify the difference between a spreadsheet application and a database application.
- Understand how to use the Ribbon with Microsoft Access.
- Understand the differences between the database entities and attributes.
- Identify the different objects of a Microsoft Access Database.
- Create and populate a simply Microsoft Access Database Table..
- Create a simply Microsoft Access Database Form that is used to populate a table.
- Create and run simple queries to display selective data from tables.
- Create and run simple reports to display data from tables and queries.
You will generally find a short quiz at the end of each lesson. Although not compulsory, we recommend that you take each quiz so that you can test yourself to make sure that you have covered the material adequately.
COMPLETE ALL LESSONS It is recommended that you take the lessons in sequence starting at Lesson 1. Most of the lessons continue to build on the previous lesson and will ensure that you have acquired the necessary knowledge to proceed and successfully complete the course.
- DDB Lesson 1: The Difference Between Spreadsheets and Databases
- DDB Lesson 2: Microsoft Access Ribbon Introduction
- DDB Lesson 3: Database Entities and Attributes
- DDB Lesson 4: Microsoft Access Database Objects
- DDB Lesson 5: Create and Populate a Microsoft Access Database Table
- DDB Lesson 6: Create and use Forms to Populate Tables
- DDB Lesson 7: Create and run simple Queries to display selective data from tables.
- DDB Lesson 8: Create and run simple Reports to display data from tables and queries.