To create a database on your computer you need a Database Management System (DBMS) that allows you to define and modify database structure, and allow users to add or enter data. There are many DBMSs, such as SQL Server, Oracle, and SAP, but the most common DBMS for desktop computers is Microsoft Office Access®. This resource uses Microsoft Office Access 2013 in a Windows 8 environment to demonstrate database features.
This module covers:
- Databases
- Microsoft Access
- Creating a new database with a table
- Primary keys
- Modifying tables
- Relationships
between tables
- Create a lookup
- Queries
- Reports
- Modifying reports
- Forms
- Database maintenance
- Getting help