Learn the basics of Microsoft’s relational database management system, Access.
Get an insight into relational database design and creating tables, forms, queries, and reports.
All learning is supported with practical exercises to extend your knowledge and skills.
Participants in the course must complete all the listed assignments for marking by the instructor in order to pass.
Curriculum
- 1 Section
- 14 Lessons
- 5 Weeks
Expand all sectionsCollapse all sections
- Microsoft Access25
- 1.11 – Access overview
- 1.22 – Relational database design
- 1.3Working with Access – Practical Exercise 1
- 1.43 – Creating Tables
- 1.53a – Creating a table
- 1.6Working with Access – Practical Exercise 2
- 1.73b – Basic Field Properties
- 1.8Working with Access – Practical Exercise 3
- 1.93c – Adding Records
- 1.10Working with Access – Practical Exercise 4
- 1.113d – Modifying Tables
- 1.12Working with Access – Practical Exercise 5
- 1.133e – Importing Data
- 1.14Working with Access – Practical Exercise 7
- 1.153f – Working with records
- 1.16Working with Access – Practical Exercise 6
- 1.173g – Lookup Fields
- 1.18Working with Access – Practical Exercise 8
- 1.194 – Creating Forms
- 1.204a – Modifying a form
- 1.21Working with Access – Practical Exercise 9
- 1.225 – Queries
- 1.23Working with Access – Practical Exercise 10
- 1.246 – Reports
- 1.25Working with Access – Practical Exercise 11
