Overview
Microsoft Access is now much more than a way to create desktop databases. It’s an easy to use tool for quickly creating browser based database applications that help you run your business. Your data is automatically stored in a SQL database, so it’s more secure and scalable than ever, and you can easily share your applications with colleagues. This course will guide you through the basics of relational database design and through the creation of database objects. You will learn how to use forms, query tables and reports to manage data. You will understand the interface, customization and creation editing of the many objects available within the Microsoft Access application. This course is divided in to three separate levels being Basic Microsoft Access, Intermediate Microsoft Access and Advanced Microsoft Access.
Curriculum
Access Beginner
1.1 Introduction Part 1
1.2 Introduction Part 2
1.3 Elements Part 1
1.4 Elements Part 2
1.5 Reviewing Data
1.6 Queries Part 1
1.7 Queries Part 2
1.8 Tracking Time Part 1
1.9 Tracking Time Part 2
1.10 Tracking Time Part 3
1.11 Design Work With Forms
Access Intermediate
1.1 Relationships Part 1
1.2 Relationships Part 2
1.3 Changing Information
1.4 Loading Tables
1.5 Relating Invoices Part 1
1.6 Relating Invoices Part 2
1.7 Relating Invoices Part 3
1.8 Relating Invoices Part 4
1.9 Time Entry Form
Access Advanced
1.1 Queries Part 1
1.2 Queries Part 2
1.3 Queries Part 3
1.4 Queries Part 4
1.5 Reports Based On Queries
1.6 Adding Additional Information
1.7 Update Query Part 1
1.8 Update Query Part 1
1.9 Creating A Report From Scratch Part 1
1.10 Creating A Report From Scratch Part 2
1.11 Creating A Report From Scratch Part 3
Sanaa –
CSI is undoubtedly the top college in South Africa. Highly recommended!
Amina –
The course materials were well-organized and accessible. I could easily navigate through the lessons.
Emily –
I can’t believe how much I’ve learned. Thank you for the amazing course!
Ayanna –
The course provided valuable insights and practical tips that I can immediately implement in my work.
Xolani –
The course offered real-life insights from industry experts, giving me a valuable perspective.
Joseph –
The course had a great pace, allowing me to learn at my own speed without feeling overwhelmed.
Emma –
The course provided excellent resources and references for further learning.
Lila –
I liked the community aspect of the course, as I could interact with other learners and exchange ideas.
William –
Best college in SA
Imani –
The course included regular assessments, allowing me to track my progress and identify areas for improvement.