L-5 Ms-Access / Class-8 Q-Ans

Class - VIII

Subject : computer Science 

  L-5 Ms-Access 

Book Exercise

A) Fill in the blanks

1.) Datasheet View allows you to view data stored in your tables.

2.) Datasheet View  is used to enter and view the data for the records.

3.) The primary key  is the unique identifies for each record in a table .

4.) The report is created in design  view.

5.) Data type determines what kind of data the field can store.

B) Answer the following questions:

1.) What is primary key? How to set a primary key?

Ans: A primary key is a unique identifier for a record in a database table.

To set a primary key:

1. Open the table in design view.
2. Select the field you want as the primary key.
3. Click on the "Primary Key" icon in the toolbar.

Alternatively, right-click on the field and select "Primary Key" from the context menu.

2.) What is a form in ms-access? Give details of different views information.

Ans: A form in MS Access is a user interface that allows for easier data entry, editing, and viewing of records in a database table.

Different Views:

1. Form View: Allows users to interact with and enter data into the form fields.

2. Design View: Lets you modify the structure, layout, and properties of the form.

3. Layout View: Offers a more visually-oriented way to modify form layout and design.

4. PivotTable View: Allows for data analysis in a table format with drag-and-drop functionality.

5. PivotChart View: Enables creation and modification of dynamic charts based on the form's data.

6. Datasheet View: Presents data in a spreadsheet-like format for easy viewing and editing.

These views provide different ways to work with and customize forms in MS Access.

3.) What is database? Name their major objects?

Ans: A database is a structured collection of data organized in a way that allows for efficient storage, retrieval, and manipulation.

Major Objects in a Database:

1. Tables: Store data in rows and columns, forming the foundation of a database.

2. Queries: Retrieve specific data from tables based on defined criteria.

3. Forms: Provide a user-friendly interface for data entry, editing, and viewing.

4. Reports: Present data in a formatted and printable layout for analysis or documentation.

5. Indexes: Improve the speed of data retrieval by creating efficient access paths.

6. Relationships: Define connections between tables to establish links between related data.

7. Forms: Provide a user-friendly interface for data entry, editing, and viewing.

8. Reports: Present data in a formatted and printable layout for analysis or documentation.

These objects work together to help organize, manage, and utilize data effectively within a database system.

4.) What is table?

Ans: A table is a structured collection of data organized into rows and columns. It is a fundamental object in a database where information is stored, representing entities such as customers, products, or orders. Each row in a table corresponds to a specific record, while each column represents a different attribute or field of the data.

5.) What are fields and fields data type?

Ans: Fields are individual columns within a database table that represent specific attributes or properties. They define the type of information that can be stored for each record.

Field Data Types specify the kind of data that a field can hold, such as text, numbers, dates, or binary data. Common data types include Text, Number, Date/Time, Boolean, and Memo.