Learn Advance Access | Select Query | How to work on MS Access | MS Access for Beginner | Lesson 1

Learn Advance Access | Select Query | How to work on MS Access | MS Access for Beginner | Lesson 1

@ESTEntertainment
@RGEntertainmentIndia
@user-vl8nj1yu4s
@JobSeekers1
@technicalgovernmentjoballoveri
@SETIndia
@ThinkSchool

What is the advantages of MS Access?
Image result
Microsoft Access is an information management tool, or relational database, that helps you store information for reference, reporting and analysis. Access can also overcome the limitations found when trying to manage large amounts of information in Excel or other spreadsheet applications.

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools (not to be confused with the old Microsoft Access which was a telecommunication program that provided terminal emulation

What are the 7 major components of MS Access?
The parts of an Access database
Tables.
Forms.
Reports.
Queries.
Macros.
Modules.

What is MS Access table?
Tables. MS Access tables are the key objects in the Access file, as they contain the data that is stored in the database. Tables are made up of rows and columns and allow for direct data entry into their grids. The row is the record that contains the individual data pieces making up an individual record.

Data modeling tools
List of data modeling and database design tools.

Data modeling is the process of creating and analyzing data models for resources stored in a database. The Data Model is an abstract model that standardizes the data description, data semantic, and consistency constraints of data. Its main purpose is to represent the types of data within a system, the relationships between objects, and its attributes. The data model helps to understand what data is needed and how data should be organized. It is like a blueprint for an architect to better understand what is being created.

Data catalogs
List of data catalogs tools

Data catalog is a structured collection of data used by an organization. It is a kind of data library where data is indexed, well-organized, and securely stored. Most data catalog tools contain information about the source, data usage, relationships between entities as well as data lineage. This provides a description of the origin of the data and tracks changes in the data to its final form.

Data dictionary tools
List of tools that enable design and building of data dictionaries.

Data Dictionary is a set of important information about data used within an organization (metadata). This information includes names, definitions, and attributes about data, owners, and creators of assets. Data Dictionary tools provide insights into meaning and purposes of data elements. They add useful aliases about the scope and characteristics of data elements, as well as the rules for their usage and application.

Business Glossary tools
List of tools that help build, maintain an share business glossaries.
Learn Advance Access | Select Query | How to work on MS Access | MS Access for Beginner | Lesson 1

Business Glossary is a collection of definitions and terms used within a business unit organization. It is not used to define data, but rather to define what a particular term means from a business perspective. The definitions are mapped and logically linked to entities in the database. This enables structured communication between teams and allows them to reveal potential errors resulting from incorrect nomenclature.

Data compare tools
List of data compare, synchronization and migration tools.

Data comparison is a process to inspect the structural differences between the source database and the target one. To carry out the comparison process, databases must meet the conditions of compatibility. However, some comparison tools have the ability to synchronize resources whose original schemas did not match each other.

Data Governance tools
List of data governance tools

Data governance is a strategy of handling data within an organization. It is a set of rules, policies, standards, practices etc. which main purpose is to ensure data has a high quality and integrity, is safely stored and there are no ambiguities in meaning of common terms. Applying this strategy is a long process, engaging whole organization, especially IT and data consuming departments. There are certain data governance tools which helps applying these theoretical plans in real life.

Data lineage tools
Data profiling tools
Data quality tools
Database design tools
List of tools that allow for the design of a database.

Database design is a set of activities aimed at improving the development, implementation, and maintenance of an enterprise data management system. Its main goal is to reflect the outline of the database system into real models: physical and logical. Database designers determine what data is to be stored inside the database, and how objects are to be related to each other.

Видео Learn Advance Access | Select Query | How to work on MS Access | MS Access for Beginner | Lesson 1 канала Nahar's Computer