Acharya Nagarjuna University Data Base Applications Important Questions

Here are the Acharya Nagarjuna University Data Base Applications Important Questions for 3rd B.Com Computer students. All the important Questions are presented into two groups like shot answer question and long answer question for each unit.

Unit-I

Short Answer Questions.

1. Advantages of Access.
2. Data types and properties.
3. How to resize the fields in Access?
4. Steps in Designing Tables
5. Explain about primary key.
6. Freezing columns
7. Indexing Fields
8. How to view list of database properties?

Long Answer Questions

1. Explain the procedure to create database with out using wizard?  
2. Explain the procedure to create database with using wizard?  
3. How to add records to a table in Access? Explain.
4. Explain the Data Types and Properties available in MS-Access.

Unit-II

Short Answer Questions.

1. What are the main sections in a Form?
2. Describe the ways to select fields and records in Data sheet view.
3. Write about Autoform feature.
4. Explain the procedure to enter data in a Form
5. Explain the way to edit data in form view
6. Describe the three views of a form
7. Explain the steps to set properties for a form.
8. What are the navigation buttons? Explain their use.

Long Answer Questions

1. Explain the procedure to create From with out using wizard?Can I use a query as the data source for that form?
2. Explain the procedure to create From with using wizard?  
3. What is Front end application? Explain the need for data entry screen.
4. How to create mailing labels in MS-Access.

Unit-III

Short Answer Questions.

1. What are the Wild cards? How to use them?
2. How to do multi level sorting using queries in Access.
3. How to find incomplete Matches using queries in Access
4. Write about AutoReport.
5. Explain how to print Mailing Labels 
6. How to change Label Design

Long Answer Questions

1. What are cross tab queries? Explain how to build them.
2. What is queries? How they are useful? Explain how to create simple queries with example.
3. What are dynasets? Explain reformatting  dynasets.
4. Explain various sections of a report.
5. How to modify Reports manually in Access? Explain.

Unit-IV

Short Answer Questions.

1. What are the advantages of relational database.
2. Relational database VS flat files
3. How to edit and view relationships in access?
4. Explain about expression building.
5. Referential Integrity.
6. Types of relations.

Long Answer Questions

1. Explain the relationships in Access with suitable examples.
2. How to create a Macro? Explain in detail with suitable example.
3. What are the objects of database systems? Explain them. 

Unit-V

Short Answer Questions.

1. Distinguish between importing and linking.
2. How to import data from a MS-Word file?
3. Explain the procedure of importing data from a spreadsheet.

 Long Answer Questions

1. Explain the procedure to insert unbounded graphics in a form.
2. Explain the procedure for linking a non-access database as a table.
3. Discuss about bounded graphics in Records.
4. Write about bounded and unbounded graphics.