Tag: accountancy

Questions Related to accountancy

Which one of the following is a DataBase Management System?

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. MS Access

  2. MS Excel

  3. MS Outlook

  4. None of the above

Show answer
Correct Option: A
Explanation:

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. 

Which of the following has RDBMS?
i. Access
ii. Excel

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. (i) and (ii)

  2. Only (i)

  3. Only (ii)

  4. None of the above

Show answer
Correct Option: B
Explanation:

Microsoft  Excel and Access are Microsoft's two different application software. They both handle tabular data, but there are still many differences between them. Excel is a spreadsheet application program, but Access is a database program. 

A representational data model through which ER design is transformed into inter-related data tables along with the restriction of rules specified to ensure the consistency and integrity of stored data is _________.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Reality

  2. Relational Data Model

  3. ER design

  4. Refinement

Show answer
Correct Option: B
Explanation:

Relational Data Model is a representational data model through which ER design is transformed into inter-related data tables along with the restriction on the form of rules specified to ensure the consistency and integrity of stored data.

To manage a business well is to manage it's future and to manage the future is to manage information is termed as____________.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Management information system

  2. Marketing information system

  3. Future information system

  4. General information system

Show answer
Correct Option: A
Explanation:

MIS is the acronym for Management Information Systems. In a nutshell, MIS is a collection of systems, hardware, procedures and people that all work together to process, store, and produce information that is useful to the organization.

The process of designing a database for accounting is best described through a ________.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Tree diagram

  2. Flow chart

  3. Pictorial presentation

  4. None of the Above

Show answer
Correct Option: B
Explanation:

The process of designing a database for accounting is best described through a flow chart.

 A flowchart can also be defined as a diagrammatic representation of an algorithm, a step-by-step approach to solving a task.

_____________ is a formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. ER Design

  2. Relational Data Model

  3. Reality

  4. Refinement

Show answer
Correct Option: A
Explanation:

A formal blueprint, with a pictorial presentation, in which Entity Relationship Model concepts are used to represent description of reality is known as ER Design.

The _________ are used for storing accounting data.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Data storage

  2. Databases

  3. Computers

  4. None of these

Show answer
Correct Option: B
Explanation:

Both computerised and computer-based AIS require a definite data structure for storing the accounting data. The databases are used for storing accounting data.

__________ is the outcome of the process of normalisation.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Normalisation

  2. Reality

  3. Refinement

  4. ER Design

Show answer
Correct Option: C
Explanation:

Refinement is the outcome of the process of normalisation. The final database design is arrived at after the process of normalisation is completed.

Access is functionally available with the following seven-object classes.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. Tables, Queries, Forms, Reports, Pages, Macros, Modules

  2. Tables, Queries, Forms, Reports, Page no., Macros, Modules

  3. Tables, Queries, Forms, Reports, Pages, Micros, Modules

  4. Tables, Queries, Forms, Responsibility, Pages, Micros, Modules

Show answer
Correct Option: A
Explanation:

MS access is one of the popularly used Database Management System (DBMS) to create, store and manage database. Access is functionally available with the following seven-object classes. Each of these object classes is capable of creating their respective object replicas. The seven objects are as follows: Tables, Queries, Forms, Reports, Pages, Macros, Modules.

Each of seven-object classes is contained in the named database file of access with _____ extension.

accountancy accounting software - tally concept of entity and relationship designing and creating simple tables, forms, and queries objective in dbms

  1. JPG

  2. MDB

  3. PNG

  4. GIF

Show answer
Correct Option: B
Explanation:

Each seven-object classes is contained in the named database file of access with MDB extension. Whenever this file is opened, a database window, as shown on the next page, opens with all the above object classes available on the left hand side.