Microsoft Access is a database management system (DBMS) that offers a combination of graphical user interface (GUI) and application development tools. With Access, users can design tables and forms and create complex queries, without having any programming expertise. Whether you are a software developer or a data analyst, you can build software applications using Access as the backend database. Typically, Access applications are developed using Visual Basic for Applications (VBA) and other Microsoft applications.
This course focuses on the concept of a database, what a database is and how it is organized and operated. You will be able to create a simple database, view the database content in various modes, analyse the data and retrieve specific information from a database. Also, you will be able to create and modify tables, forms, queries, and reports for data stored in Access.
What will I learn?
This course will teach you how to create a simple database, view the database content in various modes, as well as how to analyse the data and retrieve specific information from a database. In addition, you will be able to create and modify tables, forms, queries, and reports for data stored in Access.
WEEK 1: Databases, Tables and Field Properties
This week covers what is a database, tables and field properties.
WEEK 2: Creation and working with tables
This week covers how to create and work with tables.
WEEK 3: Queries, Reports, Data export and Printing
This week covers queries, reports, data export, and printing.
WEEK 4: Final Quiz
This section is dedicated to your Course Evaluation.
- Software developers
- Data architects
- Power users
- Develop application software
- Management (E.g. Product Inventory management, Asset Management, Sales related Information, Issue Tracking)
- Business Analysis
- Analyst and Data analyst
- Business innovation and Strategists
- MIS reporting and Data Analysis
- Programmers (Small Scale Application)
- Small-medium enterprises
What’s include in the price pack?
- Notes to study
- Final Exam