This MS Access 2013 course was designed to be easily understood by absolute beginners and at the same time offer value to somewhat proficient users of Microsoft Access.
The course focuses on equipping you with the hands-on skills required to develop database applications with MS Access in as little time as possible.
By the end of the course, you'll have the confidence required to get you started with developing your own database applications.
What's in it for you?
In this course, you will learn how to:
This course was structured to first teach you the fundamentals of database design and then guide you on a step-by-step basis on how to design and create your own database applications
You do not need any prior technical or programming experience to fully participate in this course, you just need the patience and willingness to learn.
You'll have access to the detailed step-by-step Lab Exercises that will guide you through developing the various application components.
There are quizzes at the end of each new concept learnt to validate the knowledge and skills you would have gained.
Introduction to creating databases with MS Access 2013. What to expect in the coming lectures
Understand databases, and why they are important
Understand MS Access, its uses and applications. Understand other DBMSs
A discussion on the final course project and course structure
Brief introduction to the MS Access product and interface.
Description of a table, how it is organised and its uses
Description of relationships, and their uses
Description of a forms and their uses
Description of queries, and their uses
Description of reports, and their uses
Description of other objects not covered in this class such as VBA.
Understand the importance of database design.
Best practice database design principles
A walkthrough of the process of designing a database
How to build the table, and decide on data types
How to insert data into your database tables using the data sheet view.
How to import MS Excel data into your MS Access tables
How to create table relationships and enforce referential integrity
How to create the MS Access forms.
How to modify form's design
How to create the rental reservation form which references multiple tables in our database
How to create MS Access queries and execute them
Introduction to SQL using MS Access. Understand Joins
Create queries in MS Access using the query builder
How to reference queries in combo boxes
Learn some more complex form design concepts
Build the reports for our application
Create a dashboard for easy navigation around our database application
The Instructor - Kelvin Mbatu - has a background in Computer Science and a masters degree in Information Systems from Carnegie Mellon University.
He's an IT enthusiast and has over 9 years professional IT consulting experience; Advising fortune 500 companies on matters related to cyber security, IT governance, and systems implementation.
He loves teaching and believes that nothing is difficult to learn. It's how it is taught that makes the difference.
He has a couple professional IT/Management certifications including: PMP (Project Management Professional), SCJP (Sun Certified Java Programmer), CISSP (Certified Information Systems Security Professional), CISA (Certified Information Systems Auditor), etc