1. Question:What do you mean by foreign key? 

    Answer
    The common field in child table that maintains relation with master table is foreign key.

    1. Report
  2. Question:What is a table? 

    Answer
    A table is a collection of data about a specific topic such as products, students or suppliers. A table organizes data into columns (fields) and rows (records or tuples).

    1. Report
  3. Question:What are the elements/objects of a database? 

    Answer
    The major six elements of a database are
    Tables, Queries, Form, Reports, Macros, Modules

    1. Report
  4. Question:What is a field? 

    Answer
    A field in a database is a piece of information about a subject. Each field is arranged as a column in table.

    1. Report
  5. Question:What is a record? 

    Answer
    A record is complete information about a subject. A record is a collection of fields and presented as a row in a table of database.

    1. Report
  6. Question:What is a query? 

    Answer
    A query is a question about data in database. It results a set of data from database that can be used as a source of records for reports and forms.

    1. Report
  7. Question:What is a form? 

    Answer
    Entering and viewing data directly on the database table is not always convenient. So, a form is created to facilitate easy entering data and created that retrieve records from a single table or from multiple tables.

    1. Report
  8. Question:What is a report? 

    Answer
    A report is an object in MS-Access that is used to view and print data. Though a Report is similar to a form; its specialty lies in special features like help to summarize data.

    1. Report
  9. Question:What are the differences between a form and a report? 

    Answer
    Forms are primarily used to edit overview data whereas reports are used primarily to print or view data.
    In a form your usually navigate from one record to another, whereas in reports summarized data are possible to present.

    1. Report
  10. Question:What is a macro? 

    Answer
    A macro is an object in MS-Access that is used to execute one or more database commands automatically. Macros are useful in tasks such as printing month-end reports, adding new record to a table, printing letters to customers periodically.

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