1. Question:What is a module? 

    Answer
    A module object in Access is a program written using VBA (Visual Basic for Application) to automate and customize database function.

    1. Report
  2. Question:What are the different Number field types in Access? 

    Answer
    The different number field types are:
    - Byte
    - Integer
    - Long Integer
    - Single
    - Double

    1. Report
  3. Question:What are the ten field types in Access? 

    Answer
    - Text
    - Memo
    - Number
    - Date/Time
    - Currency
    - Auto-Number
    - Yes/No
    - OLE Object
    - Hyperlink
    - Lookup Wizard

    1. Report
  4. Question:What are the two types of data processing techniques? 

    Answer
    The two types of data processing techniques are batch processing or offline processing and online processing or real-time processing.

    1. Report
  5. Question:What is batch processing or offline processing? 

    Answer
    Offline processing is a technique in which data is collected for a pre-determined period of time, after which it is processed. For example payroll processing, inventory processing. It is time delay data processing system.

    1. Report
  6. Question:What is online processing or real-time processing? 

    Answer
    This is data processing technique where data is processed in real time. This is used when delay in handling data is undesirable. Examples of online data processing systems
    are air ticketing system, banking system etc.

    1. Report
  7. Question:Who introduced Relational Database Model? 

    Answer
    Dr. E. F. Codd introduced relational database model.Dr. E. F. Codd

    1. Report
  8. Question:What are the front-end and back-end components of a database? 

    Answer
    The back-end database file contains the tables. Other database objects such as queries, forms, reports, macros, modules and the links to the tables in back end are known
    as back end database components.

    1. Report
  9. Question:What are link tables? 

    Answer
    Links of the tables in other databases or files created in Access database so that the data can be viewed and edited in Microsoft Access in addition to the original software.

    1. Report
  10. Question:What is the meaning of following field properties? Field Size, Format, Input Mask, Caption, Decimal Places, Default Value, Validation Rule, Validation Text, Required, Allow Zero Length, Indexed. 

    Answer
    Field properties and their meaning are described below:Field Size: Maximum number of character or value you can enter in fieldFormat: Format for the field. It gives the layout for the field.Input Mask: A way or pattern of data to be entered.Caption: The label for the fieldDecimal Places: The number of digits to the right of decimal place.Default Value: The value automatically entered for the new record.Validation Rule: An expression that limit the value to be entered in the field.Validation Text: The message to be displayed while user violates the rule when entering data.Required: The data should be entered the field can't be left blank.Allow Zero Length: Permits zero length of stringIndexed: The field is to be indexed. Indexing speeds up the searching & sorting.

    1. Report
Copyright © 2024. Powered by Intellect Software Ltd