Question:What do you mean by foreign key?
Answer
The common field in child table that maintains relation with master table is foreign key.
Question:What do you mean by foreign key?
The common field in child table that maintains relation with master table is foreign key.
Question:What is a table?
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).
Question:What are the elements/objects of a database?
The major six elements of a database are Tables, Queries, Form, Reports, Macros, Modules
Question:What is a field?
A field in a database is a piece of information about a subject. Each field is arranged as a column in table.
Question:What is a record?
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.
Question:What is a query?
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.
Question:What is a form?
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.
Question:What is a report?
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.
Question:What are the differences between a form and a report?
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.
Question:What is a macro?
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.