Skip to main content

This is my blogs

harry bhai

By
  HTML Tutorial For Beginners In Hindi (With Notes) Chapter – 0 (Introduction)   HTML – Hyper Text Markup Language Html is the language of the web. It is used to create websites. We use HTML tags to define the look and feel of a website. With an understanding of these tags and How to put them together, we can create beautiful websites easily!   Then why CSS and JavaScript        HTML is used for defining the layout of a page – A barebone page structure.        CSS is used to add styling to that barebone page created using HTML.        JavaScript (JS) is used to program logic for the page layout. E.g. what happens when a user hovers on a text when to hide or show elements etc?   A Beautiful analogy HTML = Card body (only metal) CSS = Car paint, design, etc. JavaScript = Car engine + Interior logic   We will start learning how to build beautiful layouts in this course.   Installing VS Code We can use...
Post a Comment

Learn MS-Access in this blog.

Image
By

MS Access – Database Management System by MicrosoftMS Access or Microsoft Access is a Database Management System (DBMS) by Microsoft. In Microsoft Access, Jet Database Engine is merged with the Graphical User Interface (GUI) and Software development tools. You can create customizable database applications using MS Access with many built-in functions like string, numeric, date, and information functions. MS Access 2016 is a part of the MS Office suite. Here we will learn the basics of MS Access and its design and implementation in context as an accounting system. Let us get started. Suggested Videos
 
ArrowArrowArrowArrowObjectives of BusinessLevels of Management
 MS Access – What is Microsoft Access?ms accessAs we have learned before a Database Management System is software that helps its users store and effectively manage databases. It is a systematic system/software to create, store, manage, manipulate, retrieves, and update any kind of data. One of the main applications of DBMS is that it can also be used to manage an accounting system. And MS Access is one of the popular DBMS tools that is used for the same. As Microsoft’s primary database program MS Access has many applications in the economic world. In accounting, it may be used for reviewing accounts, tracking down invoices, keeping a check on the creditors of the company, reviewing final accounts at year-end, etc. MS Access is a very effective tool for financial management and even tax management.microsoft accessComponents of MS AccessThere are seven major components of Microsoft Access. When we create a component in Access it is an object, and several similar objects grouped together will constitute a class. Let us take a look at the components. Tables MS Access Tables store the data or the information that you feed the program. The data table can be created with the required field names, properties, etc as desired by the user. If the table is not created correctly, the database may be slow in giving results or give wrong results entirely. So the table must be created properly and carefully.RelationshipsRelationships are the connections that form between one or more tables. So the relationships can be one-on-one, one-to-many, and then of course many-to-many.QueriesQueries are when the user or the programmer requests the database for information. The objects help create a SQL compatible query, which can help store data and retrieve information from the database. Queries can also sort and filter data as per the query statement. this is an object class that allows the programmer/designer to create a user interface for MS Access. A form is defined by tables and queries.ReportsOnce all the data has been entered into the database, the user will want to view the information. For this, he can run reports which will allow him to view the information, or summarize the information. The reports can be customized by the user. The source of the information in these reports are the tables and the queries.MacrosMacros are tools on MS Access that allow you to automate tasks on your forms or reports. They are predefined actions that add functionality and efficiency to your database. They can perform a series of actions like open a table, run queries, create reports, etc. The command will be performed each time the macro button is clicked on.ModulesThese are the foundations of the software that allows the programmer to create a set of predefined instructions called sub-routines. These modules can be used throughout the database, they can be used from anywhere in the database. Solved Question for YouQ: Every component that is created using access is a subject and several such similar objects constitute a class. True or False?Ans: MS Acces is a popular DBMS system to create, store, and manage databases. Every component that is created using Access is an object and several such objects constitute a class. Access is functionally available with seven object classes.x

Labels:

Comments

Post a Comment

If you have no doubt then comment here!

Popular posts from this blog

Learn about MS-Word in shortly.

By
     1.- What is WS-Word? -  The WS-Word is application software. It's used to do office work easily.      It's used to change letter formatting, editing text, editing text style & It had many  options for doing office work easily.  there are two ways to open the WS-Word on the computer.                                        these are here below.                                                                                        This is the first way to open WS-Word.     1. go to the  "Start Menu " on the computer.     2. Now go to the " All Program " on the computer.     3. Now go...
Post a Comment
Read more

Learn About MS-Office in shortly...

By
   1. -    What is MS-Office? -    It is a Microsoft Company developed application software.it's used for office work.       It is a very helpful software for men who work in a very big or small office. It did the office work very simply.  2.-   Its version.  -  It had many versions but the same best version is here.        1 MS-Office 2003     2 MS-Office 2007     3 MS-Office 2013 3.-  Its parts. -  It's 4 important parts.    These are here.   1 MS-Word   2 MS-Excel.   3 MS-Powerpoint.   4 MS-Access.                              ➤  1. Let's know about the MS-Word...     -    This is a very important application. It's used to give the user comfort. It is application software and its use only to  edit your letter, formatting differe...
Post a Comment
Read more

harry bhai

By
  HTML Tutorial For Beginners In Hindi (With Notes) Chapter – 0 (Introduction)   HTML – Hyper Text Markup Language Html is the language of the web. It is used to create websites. We use HTML tags to define the look and feel of a website. With an understanding of these tags and How to put them together, we can create beautiful websites easily!   Then why CSS and JavaScript        HTML is used for defining the layout of a page – A barebone page structure.        CSS is used to add styling to that barebone page created using HTML.        JavaScript (JS) is used to program logic for the page layout. E.g. what happens when a user hovers on a text when to hide or show elements etc?   A Beautiful analogy HTML = Card body (only metal) CSS = Car paint, design, etc. JavaScript = Car engine + Interior logic   We will start learning how to build beautiful layouts in this course.   Installing VS Code We can use...
Post a Comment
Read more

Learn About The MS-Powerpoint

By
 Microsoft PowerPoint is a presentation program,[7] created by Robert Gaskins and Dennis Austin[7] at a software company named Forethought, Inc.[7] It was released on April 20, 1987,[8] initially for Macintosh System Operating system based computers only.[7] Microsoft acquired PowerPoint for about $14 million three months after it appeared.[9] This was Microsoft's first significant acquisition,[10] and Microsoft set up a new business unit for PowerPoint in Silicon Valley where Forethought had been located.[10] PowerPoint became a component of the Microsoft Office suite, first offered in 1989 for Macintosh[11] and in 1990 for Windows,[12] which bundled several Microsoft apps. Beginning with PowerPoint 4.0 (1994), PowerPoint was integrated into Microsoft Office development and adopted shared common components and a converged user interface.[13] PowerPoint's market share was very small at first, prior to introducing a version for Microsoft Windows, but grew rapidly with the growth...
Post a Comment
Read more

Learn Microsoft Excel shortly.

By
Introduction to Microsoft Excel 101 What is Microsoft Excel? Microsoft Excel is a spreadsheet program that is used to record and analyze numerical data. Think of a spreadsheet as a collection of columns and rows that form a table. Alphabetical letters are usually assigned to columns and numbers are usually assigned to rows. The point where a column and a row meet is called a cell. The address of a cell is given by the letter representing the column and the number representing a row. Let's illustrate this using the following image. Why Should I Learn Microsoft Excel? We all deal with numbers in one way or the other. We all have daily expenses that we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze, and store such numeric data. Introduction to Microsoft Excel Where can I get Microsoft Excel? There are several ways in which you can get Microsoft Ex...
Post a Comment
Read more