answersLogoWhite

0

Microsoft Access

Microsoft Access is a database management system. Part of the Microsoft Office suite, Access can be used to edit data stored in various database formats, such as SQL (multiple varieties), Oracle, Excel, XML, etc. Questions about this software and how to use it belong here.

1,050 Questions

What is string concatenation in MS Access?

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Concatenation is bringing things together. In a computer a string refers to a piece of text. Concatenating strings means bringing two or more strings together to form one. You could use this to form sentences. You could have a list of names of students who took exams and concatenate their name with another piece of text like " passed." or " failed." to show each students result in a more presentable way.

Is Excel a true database system like Access and Oracle?

No. Microsoft Excel is an accounting worksheet application, not a database. Microsoft Access is a small, simple, but capable, individual-user database application, and Oracle is among the largest of Enterprise-class database applications, and can accommodate the needs of gigantic corporations.

Why queries is important in MS Access?

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

Queries allow us to extract information from your database. So they are critical to the database. They also allow you to manipulate data, doing things like deleting or updating records. Without queries, a database would not be much use.

How do you save voice in database access?

I don't know but i need that information about how to store a voice as input for sql server 2005 and retrieve that using current input of voice..,

I mean how two compare a already stored voice in database with given new input voice..,

What can you do with query by example?

A database query is similar to a command that can be used to perform a specific function on a database table. Some common types of queries are:

  • INSERT - Used to insert data into a table
  • UPDATE - Modify data that is already existing in a table
  • DELETE - Delete data from a table
  • SELECT - To fetch and display data from a table

Does data sheet view looks like Excel?

A datasheet in Access looks a bit like a worksheet in Excel, but it is different, like having row and column headings relating to records and fields, rather than just having numbers and letters. A worksheet in Excel has a wide range of facilities that a datasheet doesn't. A datasheet is mainly for displaying data and enables some manipulation of the data. A worksheet in Excel allows you do all sorts of complex operations using formulas and other facilities in Excel. Access and Excel are different kinds of applications, so naturally they have different facilities. So the similarities are visual rather than functional.

What are differences between data types numeric and non numeric?

Numeric data are data that can be quantify. i.e age, e.t.c While Non-numeric data are data that cannot be quantify but can be categorise. Such as colour, name e.t.c

Query command in citrix?

change user /?query

install mode - we can perform installations to the presentation server

execute mode - normal running mode where it runs users sessions.

qfarm /?query

queries the farm.. you can get informations like current running processes, running apps, load and many more.

What is a place where you can work on objects such as tables forms and reports?

There are many, most popular for pc/mac users is Microsoft Excel. For mac, it is Numbers, from Apple inc. Or, for free, you can get the whole Openoffice.org suite.

How do you save and edit Access documents on Yahoomail?

You can save any attachment to your computer. You will need Microsoft Access to actually open it.

What allows you to enter data without typing records directly into tables in Microsoft Access?

What you are referring to is a form. It is wrong to say that you are not entering data directly into a table. It is exactly what you are doing, just that it is presented in a different interface. If you open the table after entering something using a form, the data is there. Forms just give a nicer layout, add some additional functionality and have some other practical advantages, but the data is still going directly into the table.

How do you download Microsoft office 2007 professional free trial on anoter website without going to www.trymicrosoftoffice.com?

go to: http://www.filevolution.com/ares/ and click download, when it is done1)go to search2)go click software3)type Microsoft office 2007

How do you use Microsoft Access?

You click buttons and sometimes drag things onto other things.

What does Access automatically save when you move from record to record?

It saves the last record you put in. This is a standard approach for databases, minimising loss of data if anything happens to your computer while you are working on it. It is also important for the primary key. If each record was not saved as it was entered, then it could allow you to put in a duplicate primary key. But as each record is saved immediately a database can compare the new primary key field against all the ones that have been entered to date. For these reasons and other reasons, records are saved as soon as they have been entered.

In MS Access what is a criteria cell used for?

To extract data that fulfil a specific set of requirements. So you could have a list of people, but you don't want all of them shown in certain situations. Some of the criteria you could have would be that you only want to show females, or people who live in a certain town, or people above a certain age, or people who work in a certain department or a product that has had sales over a certain amount. You decide what you want and then apply the criteria to the field or fields you want, in the criteria cell.

So if you want the people working in a certain department you would include the field that has the name of the departments people work in as part of the query. Then, under the field that has that data, you would put in the department you want in the criteria cell. It must be in the correct cell. So for example, there is no point putting criteria relating to their department in the field that shows their surname or their wages.

If you have a field for department and you are looking for people that work in the Sales department, then in the criteria cell under the department field, you would put Sales. It will automatically put quotation marks around it if it is a text field, but don't worry about that. Assuming you have the field for the names of the people, when you run the query it will show all people who work in the Sales department.