Microsoft Access is one of the key components of MS Office and is a powerful relational database application.
You can use Access to manage large lists of information such as:
- Names and addresses
- Benefactors
- Inventory
- Survey responses data
- Sales performance data tracking
This course will help you understand the benefits and structure of an Access database.
Course Duration: 45 minutes.
Learning Outcomes:
On completion of this course, learner will be able to:
- Understand the basic concepts of Access
- Design and create the elements of a database Table
- Construct Queries from Tables
- Relate the tables using primary keys and referential integrity
- Create a simple Database
- Build and modify Relationships
Target Audience:
- This course is primarily designed for people who need to know how to use Microsoft Access to create databases.
- It is ideal for people who work in a variety of occupations where the assembly and collection of data is important.
- It allows developers to produce sophisticated database management solutions.
Pre–requisites:
This course assumes no prior knowledge of Microsoft Access. However, it would be beneficial to have a general understanding of personal computers and the Windows operating system.
Methodology:
The exercises are designed to impart relevant skills and knowledge by simulating the actual software environment.
The instructional strategy is to:
- First show the operations.
- Invite the learner to try to perform the required operations with some guidance.
- Finally, allow him / her to try the operations all by him / herself.
This provides a smooth transition in learning - from watching, then trying and finally, doing.
