Self Studies

MP Board Book for Class 11th Accountancy Chapter 15- Accounting System Using Data Management System

Quiz Image
Stay Updated on Exams and New Study Materials by entering your details below.
Select College

 

MP Board Book for Class 11th Accountancy Chapter 15- Accounting System Using Data Management System

Database Management System ( DBMS) is to create, store and manage databases.

  • Tables- To create data tables with field names, data types with field names, data types and properties.
  • Queries- The object class is to create the query statement.
  • Forms- Helps to create an appropriate user interface.
  • Reports- Various reports are created which are based on tables and queries.
  • Pages- It is to create database pages.
  • Macros- It is a list of actions that run as a unit.
  • Modules- Foundation of any application

Steps for creating database-

  1. Open access account window to choose blank access database and click ok button.
  2. Access responds by displaying the file and the new database dialog box.
  3. To enter the file name and location for the database.
  4. Choose the file menu bar and click new to open the new task panel to open the new task panel to create a new database.

 

Properties of the column of a table-

  • Field name- name of the table and column.
  • Data Types
  1. Text- Includes characters, words and numbers. It’s length is about 25 characters.
  2. Memo- Storing of documents
  3. Number- To store numbers which could be integers too.
  4. Date/Time- Used to store dates and time.
  5. Currency- Storing numbers in terms of rupees or dollars.
  6. Auto-Number- It is an automatic number which is being entered.
  7. Yes/ No- Logical field that is yes or no, on or off, true or false.
  8. Ole object- Object linking and embedding. It comprises photograph, bar, code, image.
  9. Hyperlink- Universal Resource Locator ( URL).
  • Properties- In this it is defined about the properties of each column.

In conclusion the chapter is all about the computerised data keeping system, how to enter the data, its steps and all. This is very useful for accounting as one does need to enter every single transaction manually. It would be very helpful if we link all the accounts and let the computer do the entering for us. 

Self Studies Get latest Exam Updates
& Study Material Alerts!
No, Thanks
Self Studies
Click on Allow to receive notifications
Allow Notification
Self Studies
Self Studies Self Studies
To enable notifications follow this 2 steps:
  • First Click on Secure Icon Self Studies
  • Second click on the toggle icon
Allow Notification
Get latest Exam Updates & FREE Study Material Alerts!
Self Studies ×
Open Now