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
The primary key.
Where can one find Microsoft access help?
One can find Microsoft access help when one goes to the website of Microsoft Office, Universal Tech Support, Fix Now, etc. One can get live chat on these sites.
Which tags are used to add rows to your tables?
Inset Into your_table ( fileld1, field2,.....,fieldn) values (value1,value2,.....,value n)
What is a tab order in Microsoft Access?
When navigating through a form in an Access database, you can use the Tab key to move the cursor from one field to another. The cursor jumps to the next field based on the Tab Order you define. The initial Tab Order is created as you add fields to the form.
For example, you add the following text fields to a Form:
- Name
- Address 1
- State
- City
- Address 2
- Zip/Postal Code
You want the users to press Tab and jump from Address 1 > Address 2 > City > State > Zip Code. Simply edit the Tab Order of these fields by modifying Address 2 (making it Tab Order 3), City (Tab Order 4), and State (Tab Order 5).
The purpose of a query is to extract information from a table or tables, which can be based on some criteria. It can be something simple, like list all names in a table, or something a little more complex, like list all products that are priced over certain amount. A query can be very simple or very complex, depending on your requirements.
Is a collection of tables associated with a general topic such as sales of products to customers.?
Database
In access to order the records in the answer to a query in a particular way you what the records?
I took the same quiz. The answer is "sort" (I got it wrong because I said arrange [serioussly this is rediculous!])
Why is ms access called relational database?
It has the ability to set up relational databases. In very simple terms, that means different tables can be connected together through relationships. You could have a table of members of staff and a table of the names of the departments in the company they work in. Then you could make a connection between each member of staff and the details of the department they work in. Why and how you do this and its advantages can take a lot of explanation. You can do a course on relational databases, such is the amount of detail involved, so it is not simple to give a full explanation here. It would also be important to be able to demonstrate it, which cannot be done in an answer like this.
In Access a datasheet view displays how many records at a time?
When viewing records in MS Access, a form view will display only one record at a time. In order to view more records at a time, one should use list view.
How do you carryout calculations in ms access?
Yes. This is mainly done through queries, but can also be done in forms and reports. A lot of databasing is based on doing calculations on stored data. A general rule on databases is that you do not store anything that can be calculated from existing data. So if you are storing dates of birth, there is no need to store ages, as the age of someone can always be calculated from their date of birth. Also, an age won't change if you literally type it into a database. So if you typed in someone's age into a database and did not look at it for a few years, the next time you open it, the person's age would still show the same as when you typed it in. Whereas if you have their date of birth stored, you can always calculate their age immediately with a simple calculation, on a form or a report or a query. Once you have today's date, which can be got direct from your computer, and a date of birth, it is easy to calculate an age.
The same idea would apply with things like wages or tax. All you need are the base values and once you have those you can get the database to do the calculations to find the figures you need. If you have a wage and a tax rate, or the amount of hours someone has worked and the rate per hour, you can calculate the pay from those, so the pay doesn't necessarily have to be stored. To the end user who will see the output, it will look like the data is actually there, but it isn't and doesn't need to be. So if something can be calculated using the data you already have, then do it as a calculation when a query is run, a form or report opened, rather than storing it unnecessarily. There will be times when you need to store calculated data, but more often that not, it doesn't need to be. So as you can see, calculations are very important in databases and the facilities are there to use them.
What are the different parts of MS PowerPoint?
The function of MS PowerPoint is to produce presentations or slides on a computer. The parts of MS PowerPoint include the Title Bar, System Buttons, Main Menu, Toolbars, Status Bar, Office Assistant and Internet Help.
Define wildcards in Microsoft Access?
Symbols that represent any character or combination of characters. The * and the ? are used for wildcard characters.
Similarities and dissimilarities of Microsoft Word and MS Excel?
simililarities between ms word and ms excel screen feature
Where are databases used mostly?
Databases are used to store data also providing modification & retrieval of data in an efficient manner. Databases is used everywhere like in Railways, Airports, Schools, Hospitals, Business , Shopping Malls etc. Database helps us to manage the data efficiently and in a easy manner.
The rows in tables are called in access?
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
Rows in an Access table are records.
