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 can you do in Excel that you cannot do in Access?
There are lots of differences as they are two applications designed for different tasks. Access is mainly for storing lists of data of different kinds. Excel is for Numerical Analysis and Manipulation. So its focus is on working with numbers. As such it provides a much wider range of functions than Access does.
Access stores data in tables, but with Excel it is easier to lay out tables visually and put all sorts of calculations around them, like totals and averages, together with the original data. Access can store the data in tables and do calculations, but they are not done together.
Excel provides a wide variety of charts, many very specialised, which Access does not. Excel has the power of doing extensive pivot tables and gives other ways of analysing data, which Access does not.
There are a lot of things both can do, but Excel is more versatile in what it does and it can be used in many creative and imaginative ways. Access is good at what it does, but it is designed for different kinds of tasks than Excel is. There are many other differences. When it comes to processing numeric data of any kind, Excel does far more.
I think this is what you are wanting. Really wonderful information. Try it yourself on one you password protect if you are not sure about it. But, you will be pleased.
To unprotect a Word document that has been locked, read on:
1) With the document open press F11 while holding down shift and alt (Alt-Shift-F11). This should launch the script editor in Word;
2) Next select the find option (or hit ctl-f), and run a find for the word "password." This should highlight something liket his"32943208";
3) Delete the letters and numbers between the tags (in the above example this would be the 32943208);
4) Save the document in the script editor and close the window. You should now be back in your Word document;
5) From the "Tools" pulldown menu, select "unprotect." Your document should now be unprotected.
-------------------------
Abbreviated version:
1. Click "Tools" in the menu bar.
2. Click "Unprotect Document"
3. If there is a password enter it.
4. Click "Ok"
What query will delete all the records satisfying the criteria enter in the query?
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
A delete query.
How do you retrieve a date field from MS Access through PHP?
Use this class: http://www.phpclasses.org/browse/package/2036.html Or if you have trouble with that, look through some of the other classes under the "database" category on that site. -DJ Craig
True
How do you concatenate a field in Access?
You use the & operator. So you could have something like a field for a firstname and a field for a surname that you want to bring together with a space between them. You could do it like this:
Firstname & " " & Surname
When designing a table why is it important to place field properties within each field?
Fields specify how a field can work, what kinds of data can be put in to a field size and other things. You need to specify formats for numbers and dates. You need to specify the size of text fields. There are many optional properties which can prove useful in different situations. Doing validation on a field can be useful to reduce errors. You can ensure data is entered into a field. There are so many other things that properties do. So they are an essential part of designing a field in a database.
Different types of supplier relationship strategies?
the different type of supplier relationship strategy includes:
1. Adversarial or 'Arm Length' relationship
2. Collaborative relationship
3. Partnership
4. Integration
5. codestiny
What is intellisense in Microsoft access?
Intellisense in Microsoft access is built-in to many standard VBA functions.
What is a descriptive word for each item in a record called in Microsoft access?
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
It could be called a data item, or a field or attribute.
You have probably been infected with the W32/Rungbu virus. Its recommended to run the Trend online scan (free) to remove this virus.
W32/Rungbu-A infects Microsoft Word DOC files by copying itself to the same filename but with an SCR extension, appending the DOC file to the SCR copy, and then hiding the original DOC file.
W32/Rungbu-A then sets the computer not to show hidden files (in order to hide the DOC file), to give SCR files a Word icon (so the SCR file looks like a Word file), and to hide file extensions (so the SCR file just displays the filename, not the SCR extension). When the SCR file is run, the Word document is displayed as normal. W32/Rungbu-A is a companion virus for the Windows platform.
W32/Rungbu-A infects Microsoft Word DOC files by copying itself to the same filename but with an SCR extension, appending the DOC file to the SCR copy, and then hiding the original DOC file.
W32/Rungbu-A then sets the computer not to show hidden files (in order to hide the DOC file), to give SCR files a Word icon (so the SCR file looks like a Word file), and to hide file extensions (so the SCR file just displays the filename, not the SCR extension). When the SCR file is run, the Word document is displayed as normal.
Excerpt taken from http://www.sophos.com/security/analyses/viruses-and-spyware/w32rungbua.HTML
A simple query would do something like just list of data in the table, without any other elements such as conditions or sub-queries or being a parameter query or using functions or formulas. So if all you wanted to do was list of all the names of people in a table, that would be a simple query.
Where assignments will be stored in pega rules database?
Workbasket assignments are stored in pc_assign_workbasket. Worklists assignments are stored in p_assgn_worklist.
How do you you change the name of a field in Access?
Go into Design View. Then click on the field you want and type in a new name for it. Then save the table.
The field properties area is displayed in datasheet view true or false?
The Field Properties area is displayed in Datasheet view. true or false
What are the different number field types in access?
In Microsoft Access, there are several number field types, including Byte, Integer, Long Integer, Single, and Double. The Byte type stores small integers (0 to 255), while Integer can hold values from -32,768 to 32,767. The Long Integer type accommodates larger whole numbers, ranging from -2,147,483,648 to 2,147,483,647. For decimal numbers, Single and Double types are used, with Single having less precision than Double.
