Microsoft Access Video Tutor

About: Microsoft Access Video Tutor

About This App:
This app is a video tutorial app to teach Ms Access (Microsoft Access). With the help of this microsoft access app you can learn microsoft access basics by watching videos any time anywhere you like. There are many microsoft access download apps but you will find this best app among them. There are many microsoft access examples and microsoft access database.
You will be able to develop database by learning this video app about microsoft access code.
There is lot of microsoft access benefits, you can manage your home expenses as well as your business expenses but learning this fully tutorial app.
What is MS Access (Microsoft Access)?



MS Access (Microsoft Access) is a Database Management System offered by Microsoft. It uses the Microsoft Jet Database Engine and comes as a part of the Microsoft Office suite of application.
MS Access (Microsoft Access) offers the functionality of a database and the programming abilities to create easy to navigate screens (forms). It helps you examine large amounts of information, and manage data professionally.

Important Terms and Basic Objects of MS Access (Microsoft Access)
Now in this MS Access (Microsoft Access) tutorial, we will learn about some important terms and basic objects in MS Access (Microsoft Access):
Database File:
It is a file which stores the entire database. The database file is kept to your hard drive or other storage devices.
Data types:
Data types are the properties of each field. Every field has one data type like text, number, date, etc.
Table
• A Table is an object which stores data in Row & Column format to store data.
• A Table is usually related to other tables in the database file.
• Each column must have Unique name
• We can also define Primary Key in a table.
Query
• Queries answer a question by selecting and sorting and filtering data based on search criteria.
• Queries show a selection of data based on criteria (limitations) you provide.
• Queries can pull from one or more related Tables and other Queries.
• Types of Query can be SELECT, INSERT, UPDATE, DELETE.
Form
• A form is a database object that you can use to create a user interface for a database application.
• Forms help you to display live data from the table. It mainly used to ease the process of data entry or editing.
Report
• A report is an object in desktop databases primarily used for formatting, calculating, printing, and summarizing selected data.
• You can even customize the report’s look and feel.
Macros
Macros are mini computer programming constructs. They allow you to set up commands and processes in your forms, like, searching, moving to another record, or running a formula.
Modules:
Modules are procedures (functions) which you can write using Visual Basic for Applications (VBA).