Microsoft Access

facts about microsoft acsses

Row Selector

It must be access database corrupted, make use software below it supports ms access databases starting with MS Access 97 version program

In access you use a "Format"

true

The query wizard can only do a limited set of types of queries. There are some kinds of queries that it cannot create. Some kinds of queries can only be done in SQL. Union queries and data definition queries for example. It is more complicated to do queries in SQL, but you can do more powerful ones. The query wizard is just for simple queries or for getting a basic query which you can then enhance using the design grid or SQL.

Vague question, but if you are talking about a database field, the simple way is to create a unique index on the field (if the database supports it). The index will not allow duplicate values to be added to the database for that field and will generate an error if somebody tries.

A report is a way of presenting your data in a way that's more readable and is usually used for printing.

either you want to hack the system I use or you have missed the point of your instructors question.

If it is a hacker, go away

If you are trying to answer an instructor, it is easy to figure out for your self.

The form can present the layout of data much better than a datasheet. Without a form you have a single row of data, stretching off the end of the screen. You have to scroll over to see the other fields. If it is on a form, the individual fields can be positioned around the screen, so that everything can be seen. Similar elements, like different lines of an address, can be positioned close together. Forms also enable you to do other things, like put buttons on them, or put calculations on them. A datasheet just lets you see the data. A form can do far more than that. A datasheet can let you see more than one record at a time, which can be useful at times. Forms are usually designed to show one record at a time, though it is possible to get them to show more than one record.

In datasheet view, all fields are always presented. Forms can be designed with just some fields shown, when others are not particularly relevant. So you could have a form that just shows the name, address, date of birth and other details about a person, and on another form just have their name and other details instead, like their job, department, salary etc. So you can design different forms to show different parts of your overall data, which can't be done on a datasheet normally. So forms are far more user friendly than working in a datasheet view and give you much more flexibility and many special features.

The number one advantage of MS Word is that is widely used and will support a number of different types of files. One disadvantage is that you have to pay to use it.

There are many thousands of companies that use encrypted databases. All banks use them.

Query

8

In Access, when creating field, first set it to be a text type. Then in the Properties window there is an option to set a default value. Type MED in there.

Reports are normally created for the purpose of printing.

For the Microsoft Access software package you can expect to pay from $80-120 online for the 2013 version. The version of Microsoft Access software package from 2010 is around $40 online.

Computers do EXACTLY what they are told to do by people. If your Access database is not behaving as you expect it is because you have made a mistake with your design.

The short answer is that the WHERE clause is used for comparing values in the base table, whereas the HAVING clause can be used for filtering the results of aggregate functions in the result set of the query. SELECT * FROM tablename WHERE ID > 100 ...is an example of a WHERE clause. Here's a simple example of a HAVING clause that returns the count of workers with the same last names... SELECT WorkerLastName, COUNT(WorkerLastName) AS WorkerCount FROM tblWorker GROUP BY WorkerLastName HAVING COUNT(WorkerLastName) > 1 The HAVING clause allows you to filter the results of aggregate functions, such as COUNT() or AVG() or SUM(), or MAX() or MIN(), just to name a few. HAVING provides you a means to filter these results in the same query, as opposed to saving the results of a WHERE clause SQL statement to a temporary table and running another query on the temporary table results to extract the same results. To do the HAVING SQL above without the HAVING clause would require the following SQL: SELECT WorkerLastName, COUNT(WorkerLastName) AS WorkerCount INTO TempTable FROM tblWorker GROUP BY WorkerLastName SELECT * FROM TempTable WHERE WorkerCount > 1 DROP TABLE TempTable

Join Line

It is the details to be put on each letter. So it could be a list of names and addresses. One name and one address would then go onto each version of the letter you are merging. The data source can come from a table in Word, or can come from another application that stores the data, like a database.

This is a statement, not a question.

The field can contain any characters. A maximum number of 255 characters is allowed in a field whose data type is Text.

Searching allows you to find data that meets specific criteria. Sorting allows you to organize that data, based upon the rules you choose (most common is alphabetical).