Designing and creating simple tables, forms, and queries - class-XI

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.

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.

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.

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.

In the context of database accounting designs, the design view is typically used to structure the layout and logic for generating reports like a trial balance.

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.

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.

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

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.

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.

The data storage structure are also called as data tables, which are created as a part of structuring database for accounting.

Normalisation is a process of refining a database design through which the possibility of duplicate or redundant data items are reduced or eliminated.

Data processing cycle, when thought of in the context of accounting, requires a series of steps that are source documents, input of data, data storage, manipulation of data and output of data.

The first step to capture accounting data from transaction(s) so as to prepare a document, is called voucher that expresses and document an accounting transaction.

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. 

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. 

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.

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 flow chart.

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.

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

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

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

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.

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.

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.

MS access is one of the popularly used Database Management System (DBMS) to create, store and manage database. It is also popularly called ACCESS.

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.

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.

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.

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.

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.

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.

A report is prepared with a definite objective. Every report is collection of related information for a particular need and purpose and must meet the twin objectives of reporting: one to reduce the level of uncertainty that is faced by a decision-maker; second to influence the behavior (or positive actions) of the decision-maker.

The record set of final SQL that relies upon preceding SQL statement, is collection of report-oriented information. This record set need be embedded in the report being produced.

Queries are the database objects used to retrieve, filter, and manipulate data from tables using SQL or graphical interfaces.

Data access pages are specialized HTML files created in older versions of MS Access to allow database interaction over the web or via email.

In accounting database models, positive values are typically assigned to debits, while negative values are assigned to credits to allow for simple summation.

In the context of the specific database accounting model being referenced, the trial balance report is the object saved and displayed under the reports list.

To ensure that credit amounts are treated as negative values in a calculation, they are multiplied by -1, which flips their sign while maintaining their magnitude.

Similar to Model-II, Model-I requires multiplying the sum of certain amounts by -1 to ensure the total field reflects the correct negative balance for credits.

In a double-entry accounting system, every transaction involves at least two entries: one debit and one credit, meaning the amount appears twice in the record set.