SIZ Approved Course | Lecture 01 | Introduction of Microsoft Access |10% Payout To @Siz-Official

in Steem Infinity Zone2 months ago (edited)

Hello Everyone!!!

Slide1.JPG

I hope You all are happy and well with the Grace of ALLAH Almighty . I'm very glade to be a part of such an amazing SIZ platform where we will show our skills and learn more with productive manner.You all people are so nice and very skilled.

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Introduction Of MICROSOFT ACCESS



Microsoft Access is a Database Management System provided by Microsoft teams. Microsoft Access provides database functionality and editing capabilities to facilitate navigation in the form of tables, reports ,form, or queries. It helps you analyze many details, and manage the data well.

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Now in My First Lecture I will introduce you some basic terms and objects of MS Access.

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Database Files

  • A file that stores the entire database.
  • The data file is stored on your hard drive or other storage devices.
  • It contains data such as tables , indexes and stored procedure

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Data types

Capturetable.PNG

  • Data types are features of each field.
  • Every field has one type of data such as text, number, date, etc.

Type of DataDescriptionSize
short textText or combinations of text and numbers, including numbers that do not require calculating (e.g. phone numbers).Up to 255 characters
Long TextLengthy text or combinations of text and numbers.Up to 63, 999 characters.
Number Numeric data used in mathematical calculations.1, 2, 4, or 8 bytes
Date/TimeDate and time values 8 bytes
Attachment Files, such as digital photos. Many files can be attached to each record. This type of data is not available in previous versions of Access.Up to 2 GB
OLE ObjectsOLE objects can store photos, audio, video, or other BLOBs (Big Binary Objects)Up to 2 GB
HyperlinkText or combinations of text and numbers stored as text and used as a hyperlink address.Up to 8,192 character
The lookup wizard The inclusion of the Wookup Wizard in the data type column in Design View is not actually the data type. When you select this installation, the wizard starts to help you define a simple or complex looking field.dependent on data type lookup field

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Table

Screenshot (30).png

  • A table is a data storage device in line and column format to store data.
  • A table is often associated with other tables in a data file.
  • Each column must have a different name
  • We can also define the Primary key in the table.
  • Each field must have a different name, and data type.
  • Tables containing fields or columns that store various types of data, such as name or address, as well as records or lines that collect all information about a particular subject matter, such as all information about a customer or employee etc.
  • You can specify a key key, one or more fields with a different value for each record, and one or more indexes per table to help retrieve your data as quickly as possible.

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Form

Screenshot (36).png

  • A form is a database that you can use to create a user interface for a data application.
  • It is very good way that provide interaction between user and data base.
  • Forms help you display interactive data from a table. It is used to slow down the data entry or editing process.

JvFFVmatwWHRfvmtd53nmEJ94xpKydwmbSC5H5svBACH7yn3hQvH3tWtRnETjjmgQt8nEwZ4nXDWLQjMqVMSwTqH6zPpX3tKBFp4heNDKyfVqegDtGoD4MsVsWFwzsQcMSXEk95E6r.jpg

Report

Screenshot (40).png

  • Reports are a great way to organize and present data from MS Access database.
  • It is in the form of a picture that highlighting main facts and trends.
  • It is present your data in an attractive and informative way.
  • A report is a desktop information tool used to format, calculate, print, and summarize selected data.
  • You can customize the look and feel of the report.

sa.png

Be prepare for second week Lecture.

Week 2


• How to Create Tables in MS Access
• How to Adding data in tables in MS Access
• How to Create Queries in MS Access
• what Action Quires in MS Access

Thanks to
Steem Infinity Zone Team
@cryptokraze | @suboohi | @vvarishayy | @qasimwaqar | @arie.steem

sa.png

Regards @salmashraf

Sort:  
 2 months ago 

@vvarishayy Thanks @salmasharaf for sharing this informative post about Microsoft access.This is a age of technology so this post will be very informative for people whose profession is related to technology.
Keep sharing this kind of informative posts.
#sizcomments
https://steemit.com/hive-181430/@salmashraf/siz-approved-course-or-lecture-01-or-introduction-of-microsoft-access-or-10-payout-to-siz-official

 2 months ago 

Thanks u so much @sahar78 for your Nice words.

 2 months ago 

Your welcome 🙂

 2 months ago 

Thank you, its really helpful for us, From very basic you start your tutorial its very fruitful. Access is essential app for office, we have to be proficient in Microsoft access.

 2 months ago 

Always welcome dear ❤️

 2 months ago 

Wow amazing dear friend you make a very good post thanks for sharing information about Microsoft Access it is very informative post. You make a very good lecture i am waiting for your next lecture best of luck my best wishes for you.

divider3mqf93qRC7L6ehes1x.png

@vvarishayy
#sizcomments


let's take part in this SIZ comment contest and make our community strong and win 1 $

Divider 1.png

Regards, @faran-nabeel

 2 months ago 

Thanks u so much for your kind apprication

Amazing and informative post you share.

Very informative post you share.

Your post content is plagiarized

@endingplagiarism
Notification to community administrators and moderators:
@dobartim ADMIN Founder
@flysky MOD Founder
@tatjanastan MOD Founder
@communityschools MOD Founder
@healthrepublic MOD MOD
@steemitwarrior MOD MOD
@enveng MOD MOD
@steemvalues MOD Founder

Screenshot_2021-08-17-11-01-53-731_com.android.chrome.jpg

 2 months ago 

But am not use any plagrism @hafiz130

 2 months ago 

Its starting same line of definition that's not big issue bachy @hafiz130.