Define the AutoNumber data type in MS_ Access. -Technology

Define the AutoNumber data type in MS_ Access. -Technology
by

1 Answer

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.
by

Related questions

When is AutoNumber data type preferred over Number data type? -Technology

Description : When is AutoNumber data type preferred over Number data type? -Technology

Last Answer : When you want to increment the number automatically as you add or delete the records. AutoNumber data type is preferred. Also, if the table does not have a primary key, then AutoNumber uniquely identifies the record.

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.

The default data type for a field is (a) Number (b) AutoNumber -Technology

Description : The default data type for a field is (a) Number (b) AutoNumber -Technology

Last Answer : (d) The default data type for a field is Text.

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.

When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Description : When you define a field for a table, which of the following parameters do Access always consider optional? -Technology

Last Answer : (d) Description field of the table is optional, as it depends on the databasedesigner that he/she wants to describe a field or not.

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.

Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Description : Making backups, keeping passwords and having access control are used for ………….. (a) Data security -Technology

Last Answer : (a) Backups, access authorised are the techniques to secure data from damage and getting lost.

How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Description : How NUMBER and DATE/TIME type fields are different in Access? Give any one difference. -Technology

Last Answer : NUMBER data type contains numeric values, while DATE/TIME type field contains date and time values.

Define prolog and data instance. -Technology

Description : Define prolog and data instance. -Technology

Last Answer : The prolog is a preface or introduction to XML document. It can contain upto five optional components. The grammar structure of the XML document is defined under prolog. The data instance consists of real data and its description through elements. It is also known as body of XML document.

When camping how much civilization or technology should one have access to before it is no longer camping?

Description : When camping how much civilization or technology should one have access to before it is no longer camping?

Last Answer : I swear I was at a campground once where a pizza was delivered to one of the campsites.

A magnetic tape is a direct access storage device. -Technology

Description : A magnetic tape is a direct access storage device. -Technology

Last Answer : FalseIt is a non-volatile memory hence, it is not direcdy accessible by the CPU.

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.

Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Description : Which field properties are used in Office Access 2007? Give the purpose of each field property. -Technology

Last Answer : Field PropertiesAfter you create a field and set its data types, you can also set additional field properties. Setting field properties can give the database extra flexibility and functionality.Some ... control.Text, Memo, Number,Date/Time, Currency,AutoNumber, Yes/No, OLEObject, Hyperlink.

Microsoft Access is an example of (a) Computer -Technology

Description : Microsoft Access is an example of (a) Computer -Technology

Last Answer : (b) MS-Access is the DataBase Management System (DBMS) found in the Microsoft Office suite.

Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Description : Microsoft Office Access 2007 includes a set of database ………… which are designed for specific business needs. -Technology

Last Answer : Microsoft Office Access 2007 includes a set of database templates which are designed for specific business needs.

Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Description : Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Last Answer : (c) From the given options, Notepad is useful program to write HTML code.

……… is not covered under file management. (a) Secure files (b) Easy access to files (c) Schedule processes (d) Keep backup of files -Technology

Description : ……… is not covered under file management. (a) Secure files (b) Easy access to files (c) Schedule processes (d) Keep backup of files -Technology

Last Answer : (c) Because schedule processes comes under processor management.

………….. is a visual desktop experience which provides an easy way to access desktop. -Technology

Description : ………….. is a visual desktop experience which provides an easy way to access desktop. -Technology

Last Answer : Aero is a visual desktop experience which provides an easy way to access desktop.

A good way to safeguard access to your computer is to protect it. (a) Deadbolt -Technology

Description : A good way to safeguard access to your computer is to protect it. (a) Deadbolt -Technology

Last Answer : (d) Password is a good way to safeguard access to your computer to protect it.

A good way to safeguard access to your computer is to _________ protect it. -Technology

Description : A good way to safeguard access to your computer is to _________ protect it. -Technology

Last Answer : A good way to safeguard access to your computer isPasswordto protect it.

Random Access Memory and Read Only Memory are examples of ____________. -Technology

Description : Random Access Memory and Read Only Memory are examples of ____________. -Technology

Last Answer : Random Access Memory and Read Only Memory are examples ofPrimary Memory.

To prevent unauthorized access to and / or from the network, a system known as ......., can be implemented -Technology

Description : To prevent unauthorized access to and / or from the network, a system known as ......., can be implemented -Technology

Last Answer : To prevent unauthorized access to and / or from the network, a system known as Firewall, can be implemented by hardware and / or software.

What is the next database upgrade after MS Access cannot handle the amount of data you have to process?

Description : What is the next database upgrade after MS Access cannot handle the amount of data you have to process?

Last Answer : SQL Express I heard was a good option and it is free.

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.

Define How do you search for data in a data file using the random access method?

Description : Define How do you search for data in a data file using the random access method?

Last Answer : Use the fseek() function to perform random access input/output on a file. After the file was opened by the fopen() function, the fseek would require three parameters to work: a file pointer to the file, the number of bytes to search, and the point of origin in the file.

What happens when you enter numbers in a Text data type field? -Technology

Description : What happens when you enter numbers in a Text data type field? -Technology

Last Answer : Numbers are accepted as a text value.

Name the data type that should be used to store Student’s Admission numbers. -Technology

Description : Name the data type that should be used to store Student’s Admission numbers. -Technology

Last Answer : Data type should be Text.

Write one example of data for which Memo data type is used. -Technology

Description : Write one example of data for which Memo data type is used. -Technology

Last Answer : To store resume of an employee in Employee table is an example of Memo data type.

If the data type of a field is set to Text, what will be its number range? -Technology

Description : If the data type of a field is set to Text, what will be its number range? -Technology

Last Answer : Its range will be 0 to 255.

When Memo data type is preferred over Text type for a field? -Technology

Description : When Memo data type is preferred over Text type for a field? -Technology

Last Answer : When the length of the field is more than 255 characters. Text data type is not capable to store the project description because its length cannot be more than 255 characters so, Memo data type is preferred over the Text data type.

Write one example of each field, for which you would use 1. Text data type -Technology

Description : Write one example of each field, for which you would use 1. Text data type -Technology

Last Answer : 1. Text data type It allows to store text or combination of text and numbers as well as numbers that don't require calculations such as phone number. This data type allows maximum 255 characters ... Description will be of Memo data type, because the length of description of employee may be large.

Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

Description : Which of the following is not a data type? (a) Picture/Graphic (b) Date/Time -Technology

Last Answer : (a) From the given options Date/Time, Text and Number are the data types.

What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Description : What data type should you choose for a zipcode field in a table? (a) Text (b) Number -Technology

Last Answer : (b) Number data type should be chosen for a zip code field in a table.

For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Description : For what, Memo data type is used? (a) To add table (b) To store objects created in other programs -Technology

Last Answer : (c) As we know, Memo provides character upto 65536 so, it is used for long text entries.

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.

Which data type helps you to handle input that is in boolean format? -Technology

Description : Which data type helps you to handle input that is in boolean format? -Technology

Last Answer : (c) Yes/No will allow boolean value.

For storing lengthy information in a field ………….. data type is used. -Technology

Description : For storing lengthy information in a field ………….. data type is used. -Technology

Last Answer : For storing lengthy information in a field Memodata type is used.

In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Description : In a Text type data field, we can enter a maximum of ………….. characters. -Technology

Last Answer : In a Text type data field, we can enter a maximum of 255characters.

A Text data type cannot allow number entry. -Technology

Description : A Text data type cannot allow number entry. -Technology

Last Answer : False As, it can include both text as well as numbers.

Memo data type allows you to store character type values in a table. -Technology

Description : Memo data type allows you to store character type values in a table. -Technology

Last Answer : True Memo data type allows upto 65536 characters.

Memo data type allows you to store only 255 characters in the table. -Technology

Description : Memo data type allows you to store only 255 characters in the table. -Technology

Last Answer : False Memo data type is used when character size is more than 255.

……. is a type of backup in which only the data that changed, since last backup is saved. -Technology

Description : ……. is a type of backup in which only the data that changed, since last backup is saved. -Technology

Last Answer : Differential backup is a type of backup in which only the data that changed since the last backup is saved.

Suggest the suitable data type for Issue_Date column. -Technology

Description : Suggest the suitable data type for Issue_Date column. -Technology

Last Answer : (i)Date(ii) alter table library modify name varchar(50);(iii) Bid column will always have a unique value which will help uniquely identify each record of Library table.(iv) Select name from library order by status desc;

Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Description : Help Ramesh in identifying any two columns for a table named student along with their suitable data type. -Technology

Last Answer : Column NameData TypeRollNoIntegerNameVarchar(20)

While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Description : While creating a table named “Employee”, Mr. Rishi got confused as which data type he should chose for the column “EName” out of char and varchar. -Technology

Last Answer : Varchar would be the suitable data type for EName column as char data type is a fixed length data type while varchar is a variable length data type.Any employee‟s name will be of variable length so it‟s advisable to choose varchar over char data type.

Write the data type of variables that should be used to store : 1. Marks of students 2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’) -Technology

Description : Write the data type of variables that should be used to store : 1. Marks of students 2. Grades of students (Grade can be ‘A or ‘B’ or ‘C’) -Technology

Last Answer : (i) int data type(ii) char data type

Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology

Description : Name the data type that should be used to store AccountCodes liko “A1001” of Customers -Technology

Last Answer : varchar data type should be used to store AccountCodes like ”A100111 of customers.

16. Fourth generation mobile technology provides enhanced capabilities allowing the transfer of both _____ data, including full-motion video, high-speed internet access, and video conferencing. a) video data and information b) voice and non-voice c) music and video d) video and audio e) None of these

Description : 16. Fourth generation mobile technology provides enhanced capabilities allowing the transfer of both _____ data, including full-motion video, high-speed internet access, and video conferencing. a) video data and ... voice and non-voice c) music and video d) video and audio e) None of these

Last Answer : b) voice and non-voice

Which of the following is true of cloud computing? A. It’s always going to be less expensive and more secure than local computing. B. You can access your data from any computer in the world, as long as you have an Internet connection. C. Only a few small companies are investing in the technology, making it a risky venture.

Description : Which of the following is true of cloud computing? A. It's always going to be less expensive and more secure than local computing. B. You can access your data from any computer in the world, ... connection. C. Only a few small companies are investing in the technology, making it a risky venture.

Last Answer : You can access your data from any computer in the world, as long as you have an Internet connection.

Define a utility software. -Technology

Description : Define a utility software. -Technology

Last Answer : A utility software is a system software designed to help in the management and tuning of operating systems, computer hardwares and different application softwares.