Give the names of five data types used in MS_Access. -Technology

Give the names of five data types used in MS_Access. -Technology
by

1 Answer

Answer :

Text, Memo, Date/Time, Yes/No and Currency.
by

Related questions

Give five names of database templates used in MS_Access 2007. -Technology

Description : Give five names of database templates used in MS_Access 2007. -Technology

Last Answer : Assets, Contacts, Events, Faculty and Issues.

What is the default extension of a MS_Access database? -Technology

Description : What is the default extension of a MS_Access database? -Technology

Last Answer : The default extension of an MS-Access database is .accdb.

Is it necessary to define a field type for a field in MS_Access? -Technology

Description : Is it necessary to define a field type for a field in MS_Access? -Technology

Last Answer : Yes, it is necessary to define a type of a field while entering data into a field.

What is the use of AutoNumber type field used in MS_Access? -Technology

Description : What is the use of AutoNumber type field used in MS_Access? -Technology

Last Answer : AutoNumber data type starts with a number for the first record and it automatically increases the number by a set of amount for each record.

What are the views in which fields can be deleted in MS_Access? -Technology

Description : What are the views in which fields can be deleted in MS_Access? -Technology

Last Answer : Datasheet View and Design View.

How will you create a blank database in MS_Access 2007? -Technology

Description : How will you create a blank database in MS_Access 2007? -Technology

Last Answer : Creating a Blank DatabaseTo create a new blank database, you need to perform the steps which are as follows:Step 1 Start Microsoft Access 2007, then Getting Started with Microsoft Office Access page will ... in the first empty cell in the Add New Field column as shown in the following figure:

A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Description : A text field is initially 40 characters long and one record has an entry in this field in MS_Access database. -Technology

Last Answer : Since the new field length is 20 characters long. So, this field will contain only left 20 characters including spaces and the remaining data will be discarded. Thus, the data from the right side of the field will be lost.

Explain MS_Access Ribbon. -Technology

Description : Explain MS_Access Ribbon. -Technology

Last Answer : The Ribbon contains a series of command tabs. In MS-Access 2007, the main command tabs are as follows: Home Create External Data Database Tools DatasheetCommand TabCommon Things You ... columns of the table.Set the data type and formatting.Create table relationships and object dependencies.

Define primary key. How do you set it in MS_Access? -Technology

Description : Define primary key. How do you set it in MS_Access? -Technology

Last Answer : Primary key is the key which is used to uniquely identify the records into the table. To set the primary key you have to follow the steps given below:Step 1 Select the field that you want ... 2 Click Primary Key button from the Design tab.orRight click on the selected field and select Primary Key.

In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Description : In a MS_Access database, which component is not present? (a) Formula Bar (b) Tables -Technology

Last Answer : (a) MS-Access contains various components, i.e. Tables, Queries, Forms, Reports, Macros and Modules.

Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Description : Which of the following is not a part of a table structure in MS_Access? (a) Field Name (b) Field Type -Technology

Last Answer : (d) From the given options Field Name, Field Type Primary Key are the part of a table.

The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Description : The different objects supported by MS_Access are tables, queries, ………… and reports. -Technology

Last Answer : The different objects supported by MS-Access are tables, queries, forms, and reports.

When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Description : When you open a database, the Ribbon appears on the left side of the MS_Access 2007 window. -Technology

Last Answer : False Because ribbon appears on the top of the window.

Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Description : Saurabh wants to insert graphics object in his presentation. Give him names of two graphic objects, which he can insert in his presentation? -Technology

Last Answer : Two graphic objectsare Picture and AutoShapes

Give the name of five Websites for locating someone online. -Technology

Description : Give the name of five Websites for locating someone online. -Technology

Last Answer : Facebook, WhitePages, SuperPages, Bing and Yahoo search.

Give the name of five Websites for locating someone online. -Technology

Description : Give the name of five Websites for locating someone online. -Technology

Last Answer : Facebook, WhitePages, SuperPages, Bing and Yahoo search.

What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Description : What is database template? Give the description of five templates, used in Microsoft Access 2007. -Technology

Last Answer : A template is a complete tracking application with predefined tables, forms, reports, queries, macros, and relationships. Each template creates a complete end-to-end solution that you can use ... to create a projects tracking database to track multiple projects and assign tasks to different people.

Domain names always have two or more parts, separated by (a) commas (b) periods (called dots) -Technology

Description : Domain names always have two or more parts, separated by (a) commas (b) periods (called dots) -Technology

Last Answer : (b) A domain name is a hierarchical series of character strings representing different levels of domains separated by dot/period.

Write down the names of the components of multimedia. -Technology

Description : Write down the names of the components of multimedia. -Technology

Last Answer : Components of multimedia are text, audio, video, images and animation.

For internal linking, the section names are provided by attribute of <a> tag. (a) title (b) href -Technology

Description : For internal linking, the section names are provided by attribute of tag. (a) title (b) href -Technology

Last Answer : (c) For internal linking, section names are provided by name attribute.

Write names of two attributes each for the following tags: 1. <hr> 2. <body> -Technology

Description : Write names of two attributes each for the following tags: 1. 2. -Technology

Last Answer : TagAttributesalign, widthbgcolor, textsrc, altborder, ruleshref, name

Names in XML document must start either with a letter, number or underscore. -Technology

Description : Names in XML document must start either with a letter, number or underscore. -Technology

Last Answer : False Names in XML must start either with a letter or underscore character.

In XML, tag names cannot contain spaces but can uses underscores. -Technology

Description : In XML, tag names cannot contain spaces but can uses underscores. -Technology

Last Answer : True Tag name must start either with a letter or underscore (_) character.

What will be the column names of the below statement? -Technology

Description : What will be the column names of the below statement? -Technology

Last Answer : 1. 26th column: Z2. 28th column: AB

(i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Description : (i) To display names of stores along with Sales Amount of those stores that have ‘fashion’ anywhere -Technology

Last Answer : mysql> Select Name,SalesAmt from Store order by noOfEmp;mysql> Select city, sum(SalesAmt) from store group by City;mysql> Select count(*),City from store group by City having count(*)>2; ... ;Min(DateOpen)2015-02-06mysql> Select Count(StoreId), NoOfEmp from Store group byNoOfemp having max(SalesAmt)

Identify the invalid variable names. State the reason if invalid. -Technology

Description : Identify the invalid variable names. State the reason if invalid. -Technology

Last Answer : Marks Unit is an invalid variable name because variable name does not allow spacing.

1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Description : 1. To display Names of Patients, TESTID and Test names for those Patients who were admitted -Technology

Last Answer : SQL commands for the given statements :(i) SELECT NAME, TESTID, TESTNAME FROM PATIENT, TESTWHERE PATIENT. TESTID = TEST. TESTID AND DTADMIT BETWEEN 01-DEC-2017' AND '15-DEC-2017' ;(ii) SELECT NAME, TESTNAME, COST ... NAME LIKE '% Sharma %' ;(iii) UPDATE TEST SET COST = COST +50 WHERE COST < 200 ;

Distinguish between Text and Memo data types. -Technology

Description : Distinguish between Text and Memo data types. -Technology

Last Answer : Distinguishing between Text and Memo are as follows:TextMemoIt is used for relatively short entries.It is used for long text paragraphs.It can store upto 255 characters only.It can store upto 65536 ... the number of characters.It does not use field size property.e.g. Emp_namee.g. Emp_description

Single and double are the types of (a) Integer data type (b) Decimal numbers -Technology

Description : Single and double are the types of (a) Integer data type (b) Decimal numbers -Technology

Last Answer : (d) Date/Time will be the data type because it allows storing date and time format.

What are the types of data backup? -Technology

Description : What are the types of data backup? -Technology

Last Answer : There are two types of data backup:1. Full backup2. Differential backup

Explain in detail about Data types in C Language. -Technology

Description : Explain in detail about Data types in C Language. -Technology

Last Answer : Data types in C LanguageData types specify how we enter data into our programs and what type of data we enter. C language has some predefined set of data types to handle various kinds of data that we ... values. Every variable which is used in the program must be declared as what data-type it is.

Name two data types that require data to be enclosed in quotes. -Technology

Description : Name two data types that require data to be enclosed in quotes. -Technology

Last Answer : char and date data types require data to be enclosed in quotes.

Name two Data types that require data to be enclosed in quotes. -Technology

Description : Name two Data types that require data to be enclosed in quotes. -Technology

Last Answer : char and date data types

The ……… offers more than five times the storage capacity of traditional DVDs. (a) Compact disc (b) Pen drive (c) Blu_ray disc (d) Ext_DVD -Technology

Description : The ……… offers more than five times the storage capacity of traditional DVDs. (a) Compact disc (b) Pen drive (c) Blu_ray disc (d) Ext_DVD -Technology

Last Answer : c) Blu-ray disc can hold almost 5 times more data than a single layer DVD.

Explain any five specific purpose application softwares. -Technology

Description : Explain any five specific purpose application softwares. -Technology

Last Answer : 1. Hotel Management SystemIt refers to the management techniques used in the hotel sector. It includes hotel administration, accounts, billing marketing, housekeeping, front office or front desk, e.g. ... delivered to acustomer or set of customers.e.g. Billing Manager, BillingTracker, kBilling etc..

Explain any five functions that can be used in a worksheet. -Technology

Description : Explain any five functions that can be used in a worksheet. -Technology

Last Answer : 1. SUM FunctionThis function, as clear from the name, is used to add all the values provided as an argument and to display the result in the cell containing the function.Argument Type All ... 0 (zero).Arguments that are error values or text that cannot be translated into numbers cause errors.

Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Description : Discuss the five fundamental categories, PMEST, with the help of suitable example. -Technology

Last Answer : P: Personality-the facet indicates the core point of the subject at handM: Matter-reflects substance or material of the subjectE: covers problem, action including methods, functioning, and other ... their subdivisions, continent, etc.Time: represents periods, like, years, decades, centuries, etc.

Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Description : Distinguish between Number and AutoNumber data type field. Give example of each. -Technology

Last Answer : Distinguishing between Number and AutoNumber dataNumberAutoNumberIt holds numeric values whichare used for calculations.It allows to store numbers thatare automatically generatedfor each record.The field ... for every newcustomer, this field willautomatically increase and willprovide a new number.

What is the significance of icons? Give the example of any three types of icons. -Technology

Description : What is the significance of icons? Give the example of any three types of icons. -Technology

Last Answer : Icons refer to graphic symbols that represent window elements. The three types of icons are as follows- the application icon, the shortcut icon and the document icon.

………… refers to the amount of data that a signal or a circuit can carry. -Technology

Description : ………… refers to the amount of data that a signal or a circuit can carry. -Technology

Last Answer : Bandwidthrefers to the amount of data that a signal or a circuit can carry.

Which of the following storage device can be used for storing large backup data? (a) Floppy disks (b) Hard disk (c) Magnetic tapes (d) None of these -Technology

Description : Which of the following storage device can be used for storing large backup data? (a) Floppy disks (b) Hard disk (c) Magnetic tapes (d) None of these -Technology

Last Answer : "B) Hard Disk.

Pen drive is also known as (a) Flash drive (b) Data stick (c) Thumb drive (d) All of the above -Technology

Description : Pen drive is also known as (a) Flash drive (b) Data stick (c) Thumb drive (d) All of the above -Technology

Last Answer : (d) A USB flash drive, data stick, thumb drive or pen drive is a portable drive that connects to a computer’s USB port.

……. is an electronic device that manipulates information or data according to the set of instructions called program. -Technology

Description : ……. is an electronic device that manipulates information or data according to the set of instructions called program. -Technology

Last Answer : Computeris an electronic device that manipulates information or data according to the set of instructions called program.

………. printers are based on electrophotography technology to print the data. -Technology

Description : ………. printers are based on electrophotography technology to print the data. -Technology

Last Answer : Laser printers are based on electrophotography technology to print the data.

………… memory is a special memory used for speeding up the transfer of data and instructions in CPU. -Technology

Description : ………… memory is a special memory used for speeding up the transfer of data and instructions in CPU. -Technology

Last Answer : Cache memory is a special memory used for speeding up the transfer of data and instructions in CPU.

A ……… is a thumb sized gadget that can be used to read, write or erase data as many times. -Technology

Description : A ……… is a thumb sized gadget that can be used to read, write or erase data as many times. -Technology

Last Answer : .A pen driveis a thumb sized gadget that can be used to read, write or erase data as many times.

…….. is the meaningful content that is extracted from the data after processing. -Technology

Description : …….. is the meaningful content that is extracted from the data after processing. -Technology

Last Answer : Information is the meaningful content that is extracted from the data after processing.

In CPU, control unit performs the actual processing on the data. -Technology

Description : In CPU, control unit performs the actual processing on the data. -Technology

Last Answer : FalseIn CPU, control unit does not perform am actual processing instead it controls and guides the operations like a supervisor.

In Random Access Memory if current will be interrupted, data will not lost. -Technology

Description : In Random Access Memory if current will be interrupted, data will not lost. -Technology

Last Answer : FalseRandom Access Memory (RAM) is a volatile memory, if current is interrupted, data will lost.

The data on a. CD_ROM is written at the time of its manufacture. -Technology

Description : The data on a. CD_ROM is written at the time of its manufacture. -Technology

Last Answer : FalseCD-ROM is a blank storage device which can be written when user wants.