Tag: accountancy

Questions Related to accountancy

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

Which one of the following is a DataBase Management System?

  1. MS Access

  2. MS Excel

  3. MS Outlook

  4. None of the above

Reveal answer Fill a bubble to check yourself
A Correct answer
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. 

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

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

  1. (i) and (ii)

  2. Only (i)

  3. Only (ii)

  4. None of the above

Reveal answer Fill a bubble to check yourself
B Correct answer
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. 

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

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 _________.

  1. Reality

  2. Relational Data Model

  3. ER design

  4. Refinement

Reveal answer Fill a bubble to check yourself
B Correct answer
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.

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

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

  1. Management information system

  2. Marketing information system

  3. Future information system

  4. General information system

Reveal answer Fill a bubble to check yourself
A Correct answer
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.

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

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

  1. Tree diagram

  2. Flow chart

  3. Pictorial presentation

  4. None of the Above

Reveal answer Fill a bubble to check yourself
B Correct answer
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.

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

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

  1. ER Design

  2. Relational Data Model

  3. Reality

  4. Refinement

Reveal answer Fill a bubble to check yourself
A Correct answer
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.

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

The _________ are used for storing accounting data.

  1. Data storage

  2. Databases

  3. Computers

  4. None of these

Reveal answer Fill a bubble to check yourself
B Correct answer
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.

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

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

  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

Reveal answer Fill a bubble to check yourself
A Correct answer
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.

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

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

  1. JPG

  2. MDB

  3. PNG

  4. GIF

Reveal answer Fill a bubble to check yourself
B Correct answer
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.