Tag: accountancy

Quizzes (207) Questions (428)

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

______ are the foundations of any application and allow the designer to create a set of programming instructions called functions.

  1. Forms

  2. Pages

  3. Modules

  4. Macro
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Modules are the foundations of any application and allow the designer to create a set of programming instructions called functions or sub-routines that can be used throughout the application.

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

In macro programming, the objects using individual instructions called ______-oriented actions are manipulated.

  1. forms

  2. pages

  3. queries

  4. macro
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In macro programming, the objects using individual instructions called macro-oriented actions are manipulated. A macro is a list of macro-oriented actions that run as a unit. Access provides for such macro programming.

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

______ leads to data transformation and when this processing is in accordance with decision usefulness, it is called information.

  1. Data processing

  2. Data report

  3. Data management

  4. Data analysis
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Data processing leads to data transformation and when this processing is in accordance with decision usefulness, it is called information. Information generation is the process of compiling, arranging, formatting and presenting information to the users.

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

__________ is one of the popularly used Database Management System (DBMS) to create, store and manage database. 

  1. MS access

  2. MS excel

  3. MS Word

  4. MS power point
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. It is also popularly called ACCESS.

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

______ object class is used to create various reports, the source of information content of which is based on tables, queries or both.

  1. Forms

  2. Reports

  3. Pages

  4. Queries
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Reports object class is used to create various reports, the source of information content of which is based on tables, queries or both. Such reports are designed in access according to the requirement of end-user.

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

Every component that is created using access is a subject and several such similar objects constitute a class.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

MS access is one of the popularly used Database Management System (DBMS) to create, store and manage database. Every component that is created using access is an object and several such similar objects constitute a class. Access is functionally available with the seven object classes.

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 statement is correct for queries object?
a. This object class allows a database designer to create the data tables with their respective field names.
b. This object class is meant to create the SQL compatible query statement with the help of Geometrical User Interface (GUI).

  1. Only a

  2. Only b

  3. Both a and b

  4. None of the above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Queries object class is meant to create the SQL compatible query statement with or without the help of Graphic User Interface (GUI) to define tables, store data and retrieves both data and information.

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

The need for which is anticipated, the information content of which may not be useful but casually required are known as casual reports.

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The need for which is not anticipated, the information content of which may be useful but casually required are known as casual reports.These are adhoc reports and are generated casually by executing some simple queries without requiring much of professional assistance.

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

_________ reports are generated only on the triggering of some event.

  1. Scheduled

  2. Causal

  3. On demand

  4. Programmed
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The reports, which are generated only on the triggering of some event are called On demand reports. Some examples of on demand reports are customer's statement of account, inventory re-order report, Stock in hand report for a selected group of items, etc.

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 generating  accounting reports in access involves which of the following steps?

  1. Designing the report, Identifying accounting information queries, Using the record set of final MDB

  2. Designing the report, Identifying accounting information queries, Using the record set of final SQL

  3. Designing the report, Identifying data analysis, Using the record set of final SQL

  4. None of the above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The process of generating accounting reports in access involves three steps: Designing the report, Identifying the accounting information queries, and finally creating an accounting report by using such queries.