Access is a Microsoft application which allows you to create, manage and view relational databases easily and efficiently. Access offers a wide variety of tools y options to design, modify, import, export and analyse data. Access for Beginners: Creating Databases offers you comprehensive, practical training in Access, from the basics right through to advanced use. You will learn the importance of storing data in a database, and the basics of database management systems relational SQL, the interface and the tools from Access, and creating databases in Access. You will also learn how to create and customise tables, queries, forms, reports and macros in Access.
Cross-cutting
Digital Skills
15 mins
Access for Beginners: Creating Databases
Digital Skills
15 mins
Introduction
Objectives
-
Understanding the importance of storing the data in a database.
-
Learn the basic concepts of relational SQL database management systems.
-
Use the interface and the Access tools.
-
Creating databases in Access with different options.
-
Customise tables using Access, defining fields, keys and relationships.
-
Create and customise forms, reports and macros using Access.
Table of Contents
VIDEO LESSON 1. THE IMPORTANCE OF STORING DATA IN A DATABASE
VIDEO LESSON 2. SQL RELATIONAL DATABASE MANAGEMENT SYSTEMS
VIDEO LESSON 3. INTRODUCTION TO ACCESS
VIDEO LESSON 4. CREATING DATABASES IN ACCESS
More related courses
Cross-cutting
Cross-cutting
Cross-cutting
Your questions answered
Why choose Educa.Pro?
Educa.Pro enables organisations to centralise training management, personalise learning and gain clear insights into the impact of training programmes. Thanks to its AI-powered technology, organisations can optimise their learning strategies, enhance talent development and make data-driven decisions.
Can the courses be taken at your own pace?
Yes. Most of the courses on Educa.Pro are self-paced and on-demand, allowing users to progress at their own pace without missing out on progress tracking or assessments, which makes it easier to fit them around work or study commitments.
What levels of security and compliance does the platform offer?
Educa.Pro complies with security standards designed to protect user and organisational data. Furthermore, it supports the traceability of certifications, digital signatures and the management of assessments, thereby ensuring regulatory and legal compliance in both educational and corporate environments.
What support and guidance does Educa.Pro offer?
The Educa.Pro team offers comprehensive support throughout implementation, roll-out and adoption, ensuring that organisations get the most out of the platform and achieve measurable results from day one.