Tag: designing and creating simple tables, forms, and queries

Quizzes (0) Questions (43)

Questions Related to designing and creating simple tables, forms, and queries

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

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

  1. Forms

  2. Tables

  3. Pages

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

In database management systems like MS Access, reports are the specific object class designed to present data from tables or queries in a formatted, printable layout.

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

The object class which allows a database designer to create the data tables with their respective field names, data types is called ________.

  1. queries

  2. tables

  3. forms

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

Tables are the fundamental building blocks of a relational database, used to store data in rows and columns with defined field names and data types.

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

A _________ is a list of macro-oriented actions that run as a unit. 

  1. report

  2. page

  3. table

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

A macro in database software is a tool that allows you to automate tasks and add functionality to your forms, reports, and controls by grouping a series of actions.

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

______ reports contain information useful for decision-making situations that the user have anticipated to occur. 

  1. Scheduled

  2. Programmed

  3. Protected

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

Programmed reports contain information useful for decision-making situations that the user have anticipated to occur. There are two types of reports within this reports type: Scheduled and on demand.

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

_______ are the object class which allows the designer to create an appropriate user interface to formally interact with the back end database, defined by the tables and queries.

  1. Forms

  2. Reports

  3. Pages

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

Forms provide the user interface in a database, allowing users to interact with the underlying data in tables and queries in a structured and user-friendly way.

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

The report design prepared is saved as __________ by design.

  1. balance sheet

  2. profit and loss

  3. trial balance

  4. both a and b
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In specific database accounting tutorials or models, the report design for a trial balance is often saved under that specific name to distinguish it from other financial reports.

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

The series, to find the total amount by which the accounts have been debited is used in database design for ________.

  1. Model-I

  2. Model-II

  3. Model-III

  4. Model-IV
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Model-I is a specific design convention in database accounting tutorials used to handle debits and credits by assigning signs to amounts.

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

Selecting reports from objects list provided by LHS of Database Window and clicking at New object button of tool bar is step ___ in procedure in access for designing a simple.

  1. 1

  2. 2

  3. 3

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

In standard MS Access procedures for creating a new object, selecting the object type and clicking the New button is the initial step to initiate the creation process.

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

____________ refers to some aspect of real world situation, for which database is to be designed.

  1. ER Design

  2. Reality

  3. Relational Data Model

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

Reality refers to some aspect of real world situation, for which database is to be designed. In the context of accounting, it is an accounting reality that is to be expressed with complete description.