Скачать или смотреть Part-2- Beginners MS Access Tutorial in Hindi- Introduction to DBMS| DBMS Tutorial | By Arvind

Join Channel Membership for More Contents
   / @ssweducation  
मध्‍यप्रदेश लोक सेवा आयोग मुख्‍य परीक्षा की संपूर्ण तैयारी के लिए अभी Join करें
👉For PDF- Join Telegram: https://t.me/SarkarStudyWaves
👉For Discussion- https://t.me/ssw_edu_discussion
👉उत्‍तर लेखन अभ्‍यास Group- https://t.me/SswMainsWriting
👉Student Registration Form- https://forms.gle/Ai721pjkB4EWWXs48
👉App Link- https://play.google.com/store/apps/de...

#MS_ACCESS #DBMS #DATABASE

Access Beginner Tutorial
Microsoft Access is a unique tool released by Microsoft that provides both the functionality of a database and the programming capabilities to create end-user screens. Each version of Access can "look and feel" completely different from another.

We've divided the Access tutorial into mini-tutorials to cover topics such as Forms, Combo Boxes, Reports, etc. Click the button below to select an Access tutorial that matches your version of MSAccess!
MsAccess Objects
Tables Tables in the Database
Queries Queries such as SELECT, APPEND, UPDATE, and DELETE
Forms User Interface for the Database
Reports Reports for the Database
Modules / VBA Code Modules that contain VBA code
MsAccess Controls
Combo Boxes Object that allows user to select an item from a drop down list
Text Boxes Object that allows user to enter a value manually
Subforms A Form within a Form
Constants MsgBox and VarType Constants
Date/Time Issues dealing with Date/Time

01. What is Microsoft Access?
What is a database?
Why use a database?
Progression from paper
Benefits of Access
Parts of an Access database
Table
Fields / Columns
Records / Rows
Query, Form, Report
Macro, Module

Starting Access
Pin to TaskBar
Create a new blank database
Parts of the screen
Title bar
Window control buttons
The Ribbon
Collapse (Minimize) the Ribbon
Quick Access Toolbar
Minimize the Navigation Pane
Status Bar
Object Pane
Turn on Overlapping Windows
Get Rid of Tabbed Documents
Close & Reopen Database
Security Warning
Create New Table
Datasheet View, Table Design
Field Name, Data Type, Description
Field naming conventions
Short Text, Long Text (Memo)
Numbers (Long Integer, Double)
Date/Time, Currency, Yes/No
AutoNumber
OLE Object, Attachment
Hyperlink
Calculated Field
Lookup Wizard
Text or Number?
Calculations, Sort Order, Leading Zeros
Long Integer, Double
Why use an ID field?
How to move a field in the table
Save your table
Table naming conventions
Primary Key

MS Access - Home
MS Access - Overview
MS Access - RDBMS
MS Access - Objects
MS Access - Create Database
MS Access - Data Types
MS Access - Create Tables
MS Access - Adding Data
MS Access - Query Data
MS Access - Query Criteria
MS Access - Action Queries
MS Access - Create Queries
MS Access - Parameter Queries
MS Access - Alternate Criteria
MS Access - Relating Data
MS Access - Create Relationships
One-To-One Relationship
One-To-Many Relationship
Many-To-Many Relationship
MS Access - Wildcards
MS Access - Calculated Expression
MS Access - Indexing
MS Access - Grouping Data
MS Access - Summarizing Data
MS Access - Joins
MS Access - Duplicate Query Wizard
Unmatched Query Wizard
MS Access - Create A Form
MS Access - Modify A Form
MS Access - Navigation Form
MS Access - Combo Box
MS Access - SQL View
MS Access - Formatting
MS Access - Controls & Properties
MS Access - Reports Basics
MS Access - Formatting Reports
MS Access - Built-In Functions
MS Access - Macros
MS Access - Data Import
MS Access - Data Export