Microsoft Access in 7 steps-7days - Beginner to Advanced
Microsoft Access in 7 steps-7days - Beginner to Advanced
Published 7/2024
Duration: 2h23m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.5 GB
Genre: eLearning | Language: English
Published 7/2024
Duration: 2h23m | .MP4 1280x720, 30 fps(r) | AAC, 44100 Hz, 2ch | 1.5 GB
Genre: eLearning | Language: English
Learning the key basics of Microsoft Access covering Tables, Forms, Queries, Reports, Macros with 7 sections - in 7 days
What you'll learn
Develop Ms Access programs or applications to manage data.
Create Ms Access Tables, Forms, Queries and Reports
Import data from other sources like Ms Excel and other Ms Access Databases
Create Macros to automate repetitive tasks
Learn how to secure your Microsoft Access Database
Learn how to create automatic backup based on a criteria
Learn how to keep images or pictures in an Ms Access Database
Requirements
You need a computer with Ms Access and Ms Excel installed.
Understanding of a Computer with windows.
NO prior knowledge in Microsoft Access needed. You will learn everything you need to know
Description
This 7-7 course teaches you the fundamentals of Microsoft Access covering the major aspects of a database like Table, Forms, Queries, Reports, Macros and Modules. At the end of the course, you will have enough knowledge to design real working programs or applications that can be used in business operations like Asset Management, Inventory Management, Human Resource Management, Accounting and so on. This course will show you some tricks like creation of Automatic Daily or weekly backups of your applications. You will learn about data types in tables, how to design user forms, how to query information using queries, how to make DashBoards used by users to Navigate the application, how to set and unset database password, how to import and export data from and to other sources. The course will also highlight some methods of trouble shooting errors while developing the applications. The course will show you how to use functions and formulae in Table, Queries and Forms to enable you optimize the database.
The course will provide templates that can be used to practice what you have learnt by enabling you to go to design view and changes a few aspects and see how your application comes out. You will also learn to re-use objects like Tables, Forms etc residing in another Ms Access application by importing them to your development environment.
Who this course is for:
Individuals who want to dive into Ms Access applications development and Data Analytics
More Info