Q1.What is database ?
Q2.What is relational database?
Ans: As we know, relational database is a database where fields in one table are linking to rows in the other tables. Example MS- Access, MOI, SQL, Oracle are also use relational database.
Q3. Differences between data and information
Ans: Data: Numbers, characters, symbols, images etc., which can be processed by a Computer that is called Data. # Data is a representation of information #.
Information: Information is any kind of knowledge that is exchangeable by the people, about things, facts, concepts, etc., in some context. # Information is process data #.
Q4.what is field
Ans: A space allocated for a particular item of information. In database systems, fields are the smallest units of information that we can access.
Q5. What is record
Ans: A collection of information/fields is called a record, which relates to a particular item within our database table.
Q6.What is table, Record, Field, Data types?
Ans: Table: A Table holds data about a particular item, such as products or suppliers.
Record: A collection of fields is called a record.
Fields: A Fields are the individual items which make up a record with our database.
Data types: A Field must have a specific data type format in MS Access like Text, Number, Currency etc.
Q7. What is Index? Why Index is necessary for a table data?
Ans: An index is a small copy of a database table sorted by key values. Access uses the index to find the location of the required data. Indexes can be created using a single field, or using multiple fields.
Q8. Write the basic designing rules of a table within a database
Ans: # Make each record unique. # Make each field unique. # Make fields functionally dependent.# Ensure each field is independent. # Ensure fields don’t contain calculated or derived data. # Ensure data is in its smallest logical parts
Q9. How would you create a table and specify field data types ?
Ans: Process of Create a table and specify field data types is
Click on Create tab from Ribbon à Click table in design view à Click on the drop down button of Data type column à Select data type
Q10. What is Keyboard short cut for moving to a specific record?
Ans : Moving to a specific record using the keyboard shortcut. Press F5 to highlight the record number on the scroll bar, type the number on the record you want .press Enter.
Q11. How to creat a relationship in MS-Access?
ANS : Click on the “Database tools” tab from the Ribbon à Click on “Relationships”à click on the “Show table” (if the show table dialog box is not already displayed) à Select tables from the show table dialog box and then click the add buttonà link the tields that are to be related.
Q12.How to save a table in Access?
Ans: We can save a table in Access by clicking on the Save button from the Quick Access Toolbar or press the Ctrl + S.
Q13. How to adds fields in design view in Access?
Ans: In the Navigation Pane, right-click the table à Design View à In the Field Name column, select a blank row and type a name for the new field à In the Data Type column, select a data type for the new field à Then Save changes.
Q14. What are the Steps to close table in Access?
Ans: (File à Close database) Click on the File tab à Close database command.
Q15. Steps to rename table in Access.
Ans: Select (but not open) the table from the Navigation Pan à Right click on the table à Rename à Edit the table name and then Enter.
Q16. What are the Steps to edit data within a record in Access?
Ans: Open table àSelect the Data to edit àEdit data and then press Enter
Q17.What are Steps to delete data within a record in Access
Ans: Open tableà Select the data to deleteà Press Delete.
Q18.Describe data type in acccess?
Ans: data types in acccess are as follows:
Text : Alphaanumeric characters up to 255 charecters in length, can be used for text or text and number that are not used in calculations.
Memo: Alphanumeric characters (Maximum of 65535 Character’s \) and can store text with rich text formatting (.rtf)
Number : Numeric values including fractional or integers.
Date/Time: Dates and times values, Stores both a data component and a time component.
Currency : monetary values, (with or without a currency symbol)
Auto Number : A unique and sequential number inserted automatically each time a new record is added.
Yes/No: Yes?no, True?Fales Value( 1 is Yes, 0 equals No)
Ole object: Ole object Used for storing OLE objects from others Microsoft windows application
Lookup Wizard… : Starts a lookup wizard to create a combo box to look up values.
Q19.In design view how to set data type of a column
Ans: To Set a data type of column in design view ; Click on the drop down button of Data type column à Select data type and then Save.
Q20. How to move a column to rearrange the column order.
Ans: Move the mouse pointer to a column filed name, such as price, When the pointer changes to a down arrow, click once to highlight, the column and then,
1.Click and hold the Field Name à2. Drag the column until the guide-line is between two columns à3. Release the mouse button.
Q21.what is filtering in access?
Ans: Filtering an Access datasheet is a way to focus on specific records, from all the records in a table. We can filter out records that aren't relevant to what we are trying to do at the moment.
Q22.How to automatically resizing the column width to fit content?
Ans: The Steps of automatically resizing the column width to fit content are given below;
Select all the columns containing data à Double click on the junction between one of the column header within the selected columns.
Q23.Why index is used in access?
Ans: To help locate and sort information quickly.
Q24.What is Navigation Pane?
Ans: The Navigation pane is a list containing every object in our database like tables, forms, quaries, reports etc. We can open, rename, and delete objects using the Navigation pane.
And we can also minimized the Navigation pan.
Q25. In Access in field properties which logical operators are used? Describe them?
Ans: And - true both conditions are true
Or - when anyone of the two condition is true
Eqv - true when both values are equal
Not - true when condition is false and false when condition true
Xor - true when anyone condition is true but not both
Q26.Discuss the field properties in Access?
Ans: field size: maximum number of characters or width
format: how the field is to be displayed
input mask: a template to allow ease of use in input
caption: another name for a field which will be displayed
default value: automatic value, may be overridden
validation rule: logical expression which must be met by input data
validation text: text which is displayed when the validation rule is not met
required: is this field required to be filled
allow zero length: allow zero length strings
indexed: should this field be used as an index for quick sorting and selection
number of decimal places: for numeric data, number of places to the right of the decimal point
Q27. What are the Types of Table Relationships in access? Describe them?
Ans: There are three types of Table Relationships in MS-Access. They are;
One-To-One Relationships: In a one-to-one relationship, a row in table “A” can have no more than one matching row in table “B”. A one-to-one relationship is created if both of the related columns are primary keys.
One-To-Many Relationships: A one-to-many relationship is the most common type of relationship. In this type of relationship, a row in table “A” can have many matching rows in table B, but a row in table B can have only one matching row in table “A”. A one-to-many relationship is created if only one of the related columns is a primary key.
Many-To-Many Relationships: In a many-to-many relationship, a row in table “A” can have many matching rows in table B, and vice versa. You create such a relationship by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table “A” and table “B”.
Q28.What is query in Access?
Ans: A query is a database object that creates a datasheet of specified records from one or more tables. We use a query to view only the fields with the required information.
Q30.What are the types of query in Access?
Ans:
select query: It is the simplest type of query and because of that, it is also the most commonly used on in Microsoft Access databases. It can be used to select and display data from one or more tables.
Append Query: takes the set results of a query and "appends" (or adds) them to an existing table.
Delete Query: deletes all records in an underlying table from the set results of a query.
Make Table Query: as the name suggests, it creates a table based on the set results of a query.
Update Query: allows for one or more field in your table to be updated
Q31.What is form in Access? Why it is used?
Ans: Forms provide an aesthetically pleasing window to enter and display record information. Forms can be used to display and maintain records within database. Forms can be designed to display fields from multiple tables and also can be used to restrict what users have access to. In addition buttons can also be added to provide automated functionally
Q32. How can you create an MS Access Form?
Ans: At first Open a saved data table from the Navigation pan à Click on Create tab from the Ribbon àClick on the Form from the forms group and then save the Form by a Form Name.
Q33. What are the uses of database?
Ans: Uses for database systems include:
1. Store data. 2. Store special information used to manage the data. 3. Can solve cases where many users want to access the same entries of data. 4. Manage access rights.
Q34. What is the use of Design View in MS Access?
Ans: We can use of Design View in MS- Access to create a data table with Primary Key, Fild Name, Data types, Criteria etc.
Q35. How can you add criteria to an MS Access query?
Ans: Use criteria to get the most specific information from a query.
Open query in Design view à In the query design grid, click the Criteria row of the field where you want to add the criterion à Add the criteria and press ENTER.
Click Run to see the results in Datasheet view.
Q36. What are Wildcards in MS-Access?
Ans: Wildcards are special characters that we use within a query to specify a pattern or include/exclude certain characters.
Most common wildcards are ? ! [ ] - # *
Q37. What are uses of Reports in MS Access?
Ans: We are uses of Reports to view, format, and summarize the information in our MS-Access database. For example, we can create a simple report of phone numbers for all your contacts, or a summary report on the total sales across different regions and time periods.
Q 38. write the steps to creat a report?
Ans: At first open a database table or query table then, then Click on the File tab from the Ribbon à create à report à view à report view.
Ans: A database is a collection of information that is organized, so that it
can easily be accessed, managed, and updated.
Q2.What is relational database?
Ans: As we know, relational database is a database where fields in one table are linking to rows in the other tables. Example MS- Access, MOI, SQL, Oracle are also use relational database.
Q3. Differences between data and information
Ans: Data: Numbers, characters, symbols, images etc., which can be processed by a Computer that is called Data. # Data is a representation of information #.
Information: Information is any kind of knowledge that is exchangeable by the people, about things, facts, concepts, etc., in some context. # Information is process data #.
Q4.what is field
Ans: A space allocated for a particular item of information. In database systems, fields are the smallest units of information that we can access.
Q5. What is record
Ans: A collection of information/fields is called a record, which relates to a particular item within our database table.
Q6.What is table, Record, Field, Data types?
Ans: Table: A Table holds data about a particular item, such as products or suppliers.
Record: A collection of fields is called a record.
Fields: A Fields are the individual items which make up a record with our database.
Data types: A Field must have a specific data type format in MS Access like Text, Number, Currency etc.
Q7. What is Index? Why Index is necessary for a table data?
Ans: An index is a small copy of a database table sorted by key values. Access uses the index to find the location of the required data. Indexes can be created using a single field, or using multiple fields.
Q8. Write the basic designing rules of a table within a database
Ans: # Make each record unique. # Make each field unique. # Make fields functionally dependent.# Ensure each field is independent. # Ensure fields don’t contain calculated or derived data. # Ensure data is in its smallest logical parts
Q9. How would you create a table and specify field data types ?
Ans: Process of Create a table and specify field data types is
Click on Create tab from Ribbon à Click table in design view à Click on the drop down button of Data type column à Select data type
Q10. What is Keyboard short cut for moving to a specific record?
Ans : Moving to a specific record using the keyboard shortcut. Press F5 to highlight the record number on the scroll bar, type the number on the record you want .press Enter.
Q11. How to creat a relationship in MS-Access?
ANS : Click on the “Database tools” tab from the Ribbon à Click on “Relationships”à click on the “Show table” (if the show table dialog box is not already displayed) à Select tables from the show table dialog box and then click the add buttonà link the tields that are to be related.
Q12.How to save a table in Access?
Ans: We can save a table in Access by clicking on the Save button from the Quick Access Toolbar or press the Ctrl + S.
Q13. How to adds fields in design view in Access?
Ans: In the Navigation Pane, right-click the table à Design View à In the Field Name column, select a blank row and type a name for the new field à In the Data Type column, select a data type for the new field à Then Save changes.
Q14. What are the Steps to close table in Access?
Ans: (File à Close database) Click on the File tab à Close database command.
Q15. Steps to rename table in Access.
Ans: Select (but not open) the table from the Navigation Pan à Right click on the table à Rename à Edit the table name and then Enter.
Q16. What are the Steps to edit data within a record in Access?
Ans: Open table àSelect the Data to edit àEdit data and then press Enter
Q17.What are Steps to delete data within a record in Access
Ans: Open tableà Select the data to deleteà Press Delete.
Q18.Describe data type in acccess?
Ans: data types in acccess are as follows:
Text : Alphaanumeric characters up to 255 charecters in length, can be used for text or text and number that are not used in calculations.
Memo: Alphanumeric characters (Maximum of 65535 Character’s \) and can store text with rich text formatting (.rtf)
Number : Numeric values including fractional or integers.
Date/Time: Dates and times values, Stores both a data component and a time component.
Currency : monetary values, (with or without a currency symbol)
Auto Number : A unique and sequential number inserted automatically each time a new record is added.
Yes/No: Yes?no, True?Fales Value( 1 is Yes, 0 equals No)
Ole object: Ole object Used for storing OLE objects from others Microsoft windows application
Lookup Wizard… : Starts a lookup wizard to create a combo box to look up values.
Q19.In design view how to set data type of a column
Ans: To Set a data type of column in design view ; Click on the drop down button of Data type column à Select data type and then Save.
Q20. How to move a column to rearrange the column order.
Ans: Move the mouse pointer to a column filed name, such as price, When the pointer changes to a down arrow, click once to highlight, the column and then,
1.Click and hold the Field Name à2. Drag the column until the guide-line is between two columns à3. Release the mouse button.
Q21.what is filtering in access?
Ans: Filtering an Access datasheet is a way to focus on specific records, from all the records in a table. We can filter out records that aren't relevant to what we are trying to do at the moment.
Q22.How to automatically resizing the column width to fit content?
Ans: The Steps of automatically resizing the column width to fit content are given below;
Select all the columns containing data à Double click on the junction between one of the column header within the selected columns.
Q23.Why index is used in access?
Ans: To help locate and sort information quickly.
Q24.What is Navigation Pane?
Ans: The Navigation pane is a list containing every object in our database like tables, forms, quaries, reports etc. We can open, rename, and delete objects using the Navigation pane.
And we can also minimized the Navigation pan.
Q25. In Access in field properties which logical operators are used? Describe them?
Ans: And - true both conditions are true
Or - when anyone of the two condition is true
Eqv - true when both values are equal
Not - true when condition is false and false when condition true
Xor - true when anyone condition is true but not both
Q26.Discuss the field properties in Access?
Ans: field size: maximum number of characters or width
format: how the field is to be displayed
input mask: a template to allow ease of use in input
caption: another name for a field which will be displayed
default value: automatic value, may be overridden
validation rule: logical expression which must be met by input data
validation text: text which is displayed when the validation rule is not met
required: is this field required to be filled
allow zero length: allow zero length strings
indexed: should this field be used as an index for quick sorting and selection
number of decimal places: for numeric data, number of places to the right of the decimal point
Q27. What are the Types of Table Relationships in access? Describe them?
Ans: There are three types of Table Relationships in MS-Access. They are;
One-To-One Relationships: In a one-to-one relationship, a row in table “A” can have no more than one matching row in table “B”. A one-to-one relationship is created if both of the related columns are primary keys.
One-To-Many Relationships: A one-to-many relationship is the most common type of relationship. In this type of relationship, a row in table “A” can have many matching rows in table B, but a row in table B can have only one matching row in table “A”. A one-to-many relationship is created if only one of the related columns is a primary key.
Many-To-Many Relationships: In a many-to-many relationship, a row in table “A” can have many matching rows in table B, and vice versa. You create such a relationship by defining a third table, called a junction table, whose primary key consists of the foreign keys from both table “A” and table “B”.
Q28.What is query in Access?
Ans: A query is a database object that creates a datasheet of specified records from one or more tables. We use a query to view only the fields with the required information.
Q29.Why Query is used in Access?
Ans: 1. used to extract and analyses data within one or more tables
2. can be saved, edited and reused.
3. Queries are also capable of working with data across multiple tables.
Ans: 1. used to extract and analyses data within one or more tables
2. can be saved, edited and reused.
3. Queries are also capable of working with data across multiple tables.
Q30.What are the types of query in Access?
Ans:
select query: It is the simplest type of query and because of that, it is also the most commonly used on in Microsoft Access databases. It can be used to select and display data from one or more tables.
Append Query: takes the set results of a query and "appends" (or adds) them to an existing table.
Delete Query: deletes all records in an underlying table from the set results of a query.
Make Table Query: as the name suggests, it creates a table based on the set results of a query.
Update Query: allows for one or more field in your table to be updated
Q31.What is form in Access? Why it is used?
Ans: Forms provide an aesthetically pleasing window to enter and display record information. Forms can be used to display and maintain records within database. Forms can be designed to display fields from multiple tables and also can be used to restrict what users have access to. In addition buttons can also be added to provide automated functionally
Q32. How can you create an MS Access Form?
Ans: At first Open a saved data table from the Navigation pan à Click on Create tab from the Ribbon àClick on the Form from the forms group and then save the Form by a Form Name.
Q33. What are the uses of database?
Ans: Uses for database systems include:
1. Store data. 2. Store special information used to manage the data. 3. Can solve cases where many users want to access the same entries of data. 4. Manage access rights.
Q34. What is the use of Design View in MS Access?
Ans: We can use of Design View in MS- Access to create a data table with Primary Key, Fild Name, Data types, Criteria etc.
Q35. How can you add criteria to an MS Access query?
Ans: Use criteria to get the most specific information from a query.
Open query in Design view à In the query design grid, click the Criteria row of the field where you want to add the criterion à Add the criteria and press ENTER.
Click Run to see the results in Datasheet view.
Q36. What are Wildcards in MS-Access?
Ans: Wildcards are special characters that we use within a query to specify a pattern or include/exclude certain characters.
Most common wildcards are ? ! [ ] - # *
Q37. What are uses of Reports in MS Access?
Ans: We are uses of Reports to view, format, and summarize the information in our MS-Access database. For example, we can create a simple report of phone numbers for all your contacts, or a summary report on the total sales across different regions and time periods.
Q 38. write the steps to creat a report?
Ans: At first open a database table or query table then, then Click on the File tab from the Ribbon à create à report à view à report view.
Tags
Fundamental