Today's Topic Introduction To Microsoft Access as a DBMS

Q1) The example of popular DBMS is:

1. MS- Word
2. MS- Power Point
3. MS-Excel
4. MS- Access

Answer:MS- Access

Explanation:Easily find and report on data stored in Access. Create rich data entry forms.

2.

Q2) In MS-Access, table contains:

1. Field
2. File
3. Character
4. Record

Answer:Record

Explanation:A table has records (rows) and fields (columns). Fields have different types of data, such as text, numbers, dates, and hyperlinks. A record: Contains specific data, like information about a particular employee or a product.

Q3) Which of the following object of database is used to retrieve data from database?

1. Queries
2. Tables
3. Reports
4. Forms

Answer:Queries

Explanation:A query in a database is a request for information from a database management system (DBMS), which is the software program that maintains data.

Q4) Which object is the output of a database application?

1. (A) Form
2. Report
3. Tables
4. Query

Answer:Report

Explanation:A report is a database object that comes in handy when you want to present the information in your database for any of the following uses: Display or distribute a summary of data.

Q5) The output of the query is in the form of:

1. Table
2. Query .
3. Report
4. Form

Answer:Query

Explanation:The 'output of a query' appears in the form of ​ a table. A query form suggests the interface of a groundwork engine.

Q6) SQL is used for: .

1. Data manipulation
2. manipulati pulation
3. Data definition
4. Data Creation

Answer:Data definition

Explanation: Data, in the context of databases, refers to all the single items that are stored in a database, either individually or as a set.

Q7) Ms Access saves the DataBase with the extension:

1. .mbd
2. .mdb
3. .Mcdb
4. .ppt

Answer:.mdb

Explanation:accdb is the default Access file format. But Microsoft Access database file that literally stands for Microsoft Database. This is the default database file format used in Access 2003 and earlier, while newer versions use the ACCDB format..mdb

Q9) Which objects is used to store data

1. Table
2. Hybrid
3. Centralized
4. Macro

Answer:Table

Explanation:Tables are database objects that contain all the data in a database.

Q10) Which strategy is used to store data at a single site in database

1. Related
2. Designed
3. Partitioned

Answer:Related

Explanation:Related

Q11) _____ Dash is used to retrive data from one or more table of a single database

1. Macro
2. Table
3. Form
4. Query

Answer:Query

Explanation:Query

Q12)A report may be based on

1. Form
2. Relationship
3. Attribute
4. Data Table

Answer:Form

Explanation:Form

Q13) It makes very simple to create a database

1. Simple Table
2. Wizard
3. Easier Programming
4. Comman Standard

Answer:Wizard

Explanation:Wizard

Q14) In MS access table contains

1. Records
2. Fields
3. Character
4. File

Answer:Records

Explanation:Records