Computer
93 Questions
12 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

Which of the following terms describes a computer that is connected to a network

  • Node
  • Unit (correct)
  • Device
  • Bluetooth

    • What is a computer network that spans across a city called

  • MAN (correct)
  • HTTP
  • LAN
  • WAN

    • Which networking device can convert the digital data into analog signal and vice-versa

  • Protocol
  • Router
  • Hub
  • Modem (correct)

    • In which topology the central node acts as a hub, switch or router to which all the other nodes are connected

    <p>Star</p> Signup and view all the answers

    Which of the following is a collection of characters and symbols that has no meaning

    <p>Data</p> Signup and view all the answers

    Which one of these helps to store and retrieve a large amount of data efficiently?

    <p>Database</p> Signup and view all the answers

    Which of the following is a group of related data organised into columns and rows in a database?

    <p>Row</p> Signup and view all the answers

    A _ is a database object to that is specially designed to display or print the data in the formatted way

    <p>Report</p> Signup and view all the answers

    Which of the following is not a relational database

    <p>Ms Excel</p> Signup and view all the answers

    Which option is present on the left side of the access window that displays the names of the objects used in the database such as table,query and form

    <p>Ribbon</p> Signup and view all the answers

    Which of the following data types is used to store a large amount of text or a combination of text and number

    <p>Memo</p> Signup and view all the answers

    In which of the following views, the records are not visible

    <p>Template</p> Signup and view all the answers

    Which of the following data types are used to store currency values

    <p>Currency</p> Signup and view all the answers

    Which of the following is one of the ways to create a table in ms access?

    <p>Design view</p> Signup and view all the answers

    To move between columns and insert new fields at the end , press the _ key

    <p>Ctrl</p> Signup and view all the answers

    Which of the following options is used to unfreeze columns?

    <p>Unfreeze all fields</p> Signup and view all the answers

    In which view of the table can we add records?

    <p>Datasheet view</p> Signup and view all the answers

    Which command is used to insert a text field/column in a table

    <p>Currency</p> Signup and view all the answers

    Which of the following command is used to perform calculation in ms access

    <p>Totals</p> Signup and view all the answers

    Which of the following command is used to find a record in a table

    <p>Sort</p> Signup and view all the answers

    Which of the following is not a sorting option

    <p>Sort A to B</p> Signup and view all the answers

    Which of the following tab is used to import data from other applications to ms access?

    <p>External data</p> Signup and view all the answers

    Which of the following group of the external data tab is used to export data from ms access table?

    <p>Import and link</p> Signup and view all the answers

    _Is a set of rules that governs the communication Between computers on a network

    <p>Protocol</p> Signup and view all the answers

    _Is a protocol used to send e-mail messages over the internet

    <p>SMTP</p> Signup and view all the answers

    _ is a networking device used to connect and facilitate transfer of information between two networks

    <p>Router</p> Signup and view all the answers

    In_ topology, every node is connected all the other nodes

    <p>Mesh</p> Signup and view all the answers

    _ is an expansion card that is used to provide the network access to a computer

    <p>NIC</p> Signup and view all the answers

    A_helps you to retrieve information from a table based on some criteria or condition

    <p>Query</p> Signup and view all the answers

    The columns in a table represent

    <p>Fields</p> Signup and view all the answers

    The _ key is defined in order to show the uniqueness of data

    <p>Primary</p> Signup and view all the answers

    A _ database is a type of database that stores data in several tables

    <p>Relational</p> Signup and view all the answers

    _ buttons help in navigating through the records

    <p>Navigation</p> Signup and view all the answers

    The _ view is the default view of the table in ms access

    <p>Database</p> Signup and view all the answers

    The _ pane is used to define the field names and their data types

    <p>Field grid</p> Signup and view all the answers

    A _ is a field in a table that uniquely identifies each record in the table

    <p>Primary key</p> Signup and view all the answers

    The _ option is used to hide column

    <p>Hide fields</p> Signup and view all the answers

    _ buttons are used to navigate through the records

    <p>Navigation</p> Signup and view all the answers

    The _ pane is used to set column properties

    <p>Field properties</p> Signup and view all the answers

    When you drag a column, a _ bar will appear to show the position of the column

    <p>Blue-colour</p> Signup and view all the answers

    _ is the process of arranging data alphabetical either in ascending or descending order

    <p>Sorting</p> Signup and view all the answers

    The _ command is used to import data from an ms Excel file

    <p>Find</p> Signup and view all the answers

    The _ command is used to export the data in PDF form

    <p>PDF or XPS</p> Signup and view all the answers

    Modulation is the process of converting analog signals into digital signal

    <p>False</p> Signup and view all the answers

    Bluetooth technology uses radio frequency to transmit data from one system to another

    <p>True</p> Signup and view all the answers

    Through computer networking , information can be easily shared amongst people

    <p>True</p> Signup and view all the answers

    In bus topology, all the nodes are connected to a single common path

    <p>True</p> Signup and view all the answers

    A server is also known as host computer

    <p>True</p> Signup and view all the answers

    Ms access is an example of the flat-file database

    <p>False</p> Signup and view all the answers

    DBMS stands for database management system

    <p>True</p> Signup and view all the answers

    A set of values for the fields is called a record

    <p>True</p> Signup and view all the answers

    A database minimises the duplication of data by integrating and sharing the data files

    <p>True</p> Signup and view all the answers

    The field properties pane is used to set the properties of the fields defined in the table

    <p>True</p> Signup and view all the answers

    Navigation pane is present on right side of ms access window

    <p>False</p> Signup and view all the answers

    The maximum size of the number data type is 32 bytes

    <p>False</p> Signup and view all the answers

    Field name can begin with underscore ( _ )

    <p>True</p> Signup and view all the answers

    We can add maximum of 256 columns in a table

    <p>True</p> Signup and view all the answers

    We can create a table using built -in templates

    <p>False</p> Signup and view all the answers

    Freezing means to make one or more columns to be visible all times

    <p>True</p> Signup and view all the answers

    We can move a column from one place to another in the table

    <p>True</p> Signup and view all the answers

    We cannot delete a column from a table

    <p>False</p> Signup and view all the answers

    Custom filter allows you to filter data according to a particular criteria

    <p>True</p> Signup and view all the answers

    We cannot remove filter from a table

    <p>False</p> Signup and view all the answers

    Filtering means to select specific data from a given set of data

    <p>True</p> Signup and view all the answers

    We cannot search a record in an ms access table

    <p>False</p> Signup and view all the answers

    What is protocol

    <p>Protocol is a set of rules that governs the communication Between the computer on a network. Certain network protocols and standards are to be followed in order to ensure that your computer can communicate with other computer over a network</p> Signup and view all the answers

    Name the various components needed for a computer network

    <p>Network interface card (NIC) , HUB or Switch , router, modem, networking cable.</p> Signup and view all the answers

    Define Client and Server

    <p>Server:- It controls the access to the hardware and software on the network Client:- It is a computer that depends on the server for all the resources</p> Signup and view all the answers

    What is topology

    <p>Topology refers to the geometric arrangement of computers or nodes in a network</p> Signup and view all the answers

    What is database ?

    <p>A database can be defined as a collection of data in an organised manner that can be easily accessed , managed and updated</p> Signup and view all the answers

    What do you mean by flat file database

    <p>It is a type of database that contains records having small number of fields without any structured relationship between them</p> Signup and view all the answers

    What is the use of s form in a database

    <p>A form is a database object used to create a user interface to enter or update a record in a table that is connected to it</p> Signup and view all the answers

    What is ms access

    <p>Ms access 2010 is an easy-to-use relational database management system developed by Microsoft. It is a part of ms office suite</p> Signup and view all the answers

    Explain any three features of ms access

    <ul> <li>It allows to generate and format printable reports * it reduces day redundancy. * It helps to search and access data efficiently</li> </ul> Signup and view all the answers

    Write the names of any three data types of ms access

    <p>Text, memo, number, autonumber , Date/time, Yes/No</p> Signup and view all the answers

    What is primary key

    <p>A primary key is a field in a table that uniquely identifies each records in a table</p> Signup and view all the answers

    What do you mean by freezing a column

    <p>Freezing means to make one or more columns to be visible all times while scrolling in any direction</p> Signup and view all the answers

    How many rows can we add in a table

    <p>Ms access 2010 allows us to add maximum of 256 columns and unlimited rows in a table</p> Signup and view all the answers

    Which command is used to delete the record from a table

    <p>Ms access facilitate us to add, delete and edit records in a table</p> Signup and view all the answers

    What is sorting

    <p>Sorting is the process of arranging data alphabetically either in ascending or descending order</p> Signup and view all the answers

    What do you mean by filtering

    <p>Filtering means to select specific data from the given set of data</p> Signup and view all the answers

    What is the meaning of exporting data

    <p>Exporting data means to save an ms access table data into different formats like PDF or spreadsheet</p> Signup and view all the answers

    What is a computer network

    <p>The computer network is a system of interconnected computers that can communicate with each other. Advantages of computer networks:</p> <ul> <li>It helps in reducing the cost of hardware.</li> <li>The Information can be easily shared by the people.</li> <li>It helps to store information in a centralised location</li> <li>Reliability implies backing up of information. If a system crashes, the information can still be accessible on another workstation for future use .</li> <li>It results in the reduction of installation costs.</li> <li>User authentication process helps to secure the data</li> </ul> Signup and view all the answers

    Describe LAN and MAN

    <p>MAN (Metropolitan area network). This network consists of two or more local area networks or campus area network together that usually spans several buildings in the same city or town WAN (Wide Area Network). It is a digital communication system that interconnects a large number of computers in a wide geographical area</p> Signup and view all the answers

    What is a relational database? Give example

    <p>It is a type of database that stores data in several tables and links those tables together to get a common piece of information. This type of database system is called Relational Database Management System (RDBMS).</p> Signup and view all the answers

    Write any three advantages of a database system.

    <p>A database system has many benefits. Some of the important advantages are:</p> <ul> <li>It saves storage space.</li> <li>All the users are provided with the same access rights or privileges and permissions.</li> <li>It improves the data integrity as data is stored in a central location.</li> </ul> Signup and view all the answers

    What is difference Between text and memo data types

    <p>Text:- it is used to store text. It can have maximum of 255 characters. It cannot be used for numeric calculation Memo:- it is used to store large amount of text or a combination of text and number. It stores up to 65,536 characters</p> Signup and view all the answers

    Explain the types of views in a database

    <p>There are two types of views in MS Access: Datasheet view and Design view. We can switch between these two views by clicking on the View command under the Views group on the Home tab. Datasheet View is the default view of the table. It shows all the fields and records as entered by the user. In this view, you can edit the content of the records of the table. Design View the records are not visible. You can only see the field names, along with their data types. You can add or delete a field name.</p> Signup and view all the answers

    What are the rules for writing a field name in database

    <p>The following rules should be remembered while writing field names:</p> <ul> <li>Field name can be up to 64 characters long.</li> <li>Field name can include any combination of letters, numbers, spaces, and special characters except a period (.), an exclamation mark (!), an accent grave (`), and brackets ([]).</li> <li>Field name cannot begin with the leading spaces.</li> <li>Field name cannot include a double quotation mark (&quot;).</li> </ul> Signup and view all the answers

    Write the steps to freezing a column in a table

    <p>Step 1: Right-click on a column header that you want to freeze. A context menu appears. Step 2: Select the &quot;Freeze Fields&quot; option from the context menu.</p> Signup and view all the answers

    Write the steps to add a new column in a table

    <p>To add a new column, follow these steps:<br /> Step 1: Open the table in which you want to add a column. Step 2: Click on the column header on the left where you want to add a column.</p> Signup and view all the answers

    What is the difference between sorting data and filtering data?

    <p>Sorting Data:- Sorting data is the process of arranging data alphabetically either in ascending or descending order. Filtering Data:-Filtering means to select specific data from the given set of data.</p> Signup and view all the answers

    What is the difference between importing data and exporting data?

    <p>Importing data:- importing data means to access the data from other applications to ms access. Ms access allows to import data from different types of files like text file , ms Excel file , HTML file and another database Exporting Data:- Exporting data means to save the ms access table data into a different format like PDF or spreadsheet . We can export the data from an ms access table to different formats like text file , spreadsheet, PDF and e-mail</p> Signup and view all the answers

    Study Notes

    Network Terms

    • A computer connected to a network is called a node.
    • A computer network that spans across a city is called a Metropolitan Area Network (MAN).
    • A modem can convert digital data into analog signal and vice-versa.
    • In star topology, the central node acts as a hub, switch or router to which all the other nodes are connected.

    Database Terms

    • A collection of characters and symbols that has no meaning is called data.
    • A database helps to store and retrieve a large amount of data efficiently.
    • A group of related data organised into columns and rows in a database is called a table.
    • A report is a database object designed to display or print data in a formatted way.
    • Access is not a relational database.
    • The navigation pane on the left side of the Access window displays object names like tables, queries, and forms.
    • The Memo data type is used to store a large amount of text or a combination of text and numbers.
    • In Design view, records are not visible.
    • The Currency data type is used to store currency values.

    MS Access Basics

    • One way to create a table in MS Access is to use the Create Table option.
    • Press the Enter key to move between columns and insert new fields at the end.
    • Unfreezing columns is accomplished by clicking the "Freeze Panes" button in the "View" tab.
    • Records can be added in Datasheet view.
    • The Add Field command is used to insert a text field/column in a table.
    • The Calculate command is used to perform calculations in MS Access.
    • The Find command is used to locate a specific record in a table.
    • Ascending is not a sorting option.
    • The External Data tab is used to import data from other applications into MS Access.
    • The Export group within the External Data tab is used to export data from MS Access tables.

    Network Concepts

    • A Protocol is a set of rules that governs communication between computers on a network.
    • SMTP (Simple Mail Transfer Protocol) is used to send e-mail messages over the internet.
    • A router is a networking device used to connect and facilitate the transfer of information between two networks.
    • In mesh topology, every node is connected to all other nodes.
    • A Network Interface Card (NIC) is an expansion card used to provide network access to a computer.

    Database Concepts

    • A query helps retrieve information from a table based on criteria or conditions.
    • Columns in a table represent fields.
    • The Primary key is defined to ensure the uniqueness of data.
    • A relational database is a type of database that stores data in several tables.
    • Navigation buttons aid in navigating records.
    • Datasheet view is the default view of a table in MS Access.
    • The Design pane is used to define field names and data types.
    • A primary key is a field in a table that uniquely identifies each record.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Description

    Didi

    More Like This

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser