25 Lecture
CS101
Midterm & Final Term Short Notes
Database MS Access
Microsoft Access is a relational database management system (RDBMS) developed by Microsoft. It is a powerful tool that enables users to create and manage their own databases, making it one of the most popular database software in the world.
Important Mcq's
Midterm & Finalterm Prepration
Past papers included
Download PDF
What is MS Access? A. A spreadsheet software B. A word processing software C. A database management system D. A presentation software Answer: C
What is a table in MS Access? A. A collection of data organized into rows and columns B. A request for data that meets specific criteria C. A user interface that allows users to input data into a database D. A formatted presentation of data from a database Answer: A
What is a query in MS Access? A. A collection of data organized into rows and columns B. A request for data that meets specific criteria C. A user interface that allows users to input data into a database D. A formatted presentation of data from a database Answer: B
What is a form in MS Access? A. A collection of data organized into rows and columns B. A request for data that meets specific criteria C. A user interface that allows users to input data into a database D. A formatted presentation of data from a database Answer: C
What is a report in MS Access? A. A collection of data organized into rows and columns B. A request for data that meets specific criteria C. A user interface that allows users to input data into a database D. A formatted presentation of data from a database Answer: D
What is a primary key in MS Access? A. A field or combination of fields that uniquely identifies each record in a table B. A request for data that meets specific criteria C. A user interface that allows users to input data into a database D. A formatted presentation of data from a database Answer: A
What is a macro in MS Access? A. A tool used to create tables B. A tool used to create forms C. A tool used to automate repetitive tasks D. A tool used to create reports Answer: C
What is the relationship in MS Access? A. A connection between two tables based on a common field B. A request for data that meets specific criteria C. A user interface that allows users to input data into a database D. A formatted presentation of data from a database Answer: A
What are some of the security features provided by MS Access? A. The ability to set permissions for different database objects B. The ability to encrypt data C. The ability to create backups of the database D. All of the above Answer: D
What is the maximum number of records that can be stored in a single table in MS Access? A. 1,000 B. 10,000 C. 100,000 D. 1 million Answer: D
Subjective Short Notes
Midterm & Finalterm Prepration
Past papers included
Download PDF
What is MS Access? Answer: MS Access is a relational database management system developed by Microsoft.
What are some of the advantages of using MS Access? Answer: Some of the advantages of using MS Access include its ease of use, scalability, and security features.
What is a table in MS Access? Answer: A table in MS Access is a collection of data organized into rows and columns.
What is a query in MS Access? Answer: A query in MS Access is a request for data that meets specific criteria.
How can MS Access be used to automate repetitive tasks? Answer: MS Access can be used to automate repetitive tasks by creating macros that perform specific actions automatically.
What are some of the security features provided by MS Access? Answer: Some of the security features provided by MS Access include the ability to set permissions for different database objects and encryption features to protect sensitive data.
What is a form in MS Access? Answer: A form in MS Access is a user interface that allows users to input data into a database.
What is a report in MS Access? Answer: A report in MS Access is a formatted presentation of data from a database.
How can MS Access be used to manage large amounts of data? Answer: MS Access can be used to manage large amounts of data by creating multi-user databases that can be shared across a network.
What is a primary key in MS Access? Answer: A primary key in MS Access is a field or combination of fields that uniquely identifies each record in a table.