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
In how many ways can a table be opened in ms-access?
Tables, as we have learnt, are the building blocks of a database. It is a complete collection of data represented or displayed in rows and colums. While a database wizard completes this job, you need to create and design tables when yor create a blank database. Tables can also be created using a Table wizard, or by importing them from other applications like Excel
How does Excel handle the user's access to online help features?
It checks for a live Internet connection whenever the Help feature is activated.
Does Access designate the first field as the primary key field?
No. It does not designate any field you put in. That is something you have to do yourself. If you don't designate one, then it will ask you if you want to or if Access can put one in for you. If you allow Access to put one in, then it will insert a nwe field which will be an Autonumber field and this will be inserted at the top and so it will be the first field. It makes sense to have the first field as a key field, which is why it inserts it at the top, before the first field you put in. If you are setting your own, you should put that field in first, though you do not have to.
Does Access automatically creates and maintains an index for a table's primary key?
Access automatically creates an index for the primary key field in a table. In addition, Access automatically creates an index for any field name that contains the following letter sequences: code, ID, key, or num.
What is the difference between Formatted Text and Comma delimited?
In a comma delimited file, data is stored as free-form text with each value separated by a comma. Text data may or may not be quoted and numbers appear with signs and decimals as appropriate. Example:
"my data", 1, 2.5, 3
A fixed format file stores each value in a fixed position in the record. There are no delimiters in the record and you must know the format of the record and fields to properly interpret the information. Numeric fields usually do not contain decimal points (decimal position is implied by the column format) and the sign may be in a leading position or trailing position, or it may be 'zoned', meaning the sign is indicated by altering the lead bit in either the leading or trailing character. Negative digits would appear as a letter.
In the above example, if it was fixed format with 4 fields with the first being text of 10 characters followed by 3 numbers with 6 digits with 2 implied decimal places (i.e. 9999.99) the data would appear as:
my data 000100000250000300
Maintaining versus generating calculated fields in rdbms?
Well difference between maintaining and generating fields is simple. Simple table
Qty Bought Price Total paid (Calculated field)
1 £3 £3
2 £4 £8
Total is calculated field so when we maintain it we use a lilttle bit of memory to save the value and it will be always there for us so anytime we need it we just look it up. This however causes some problems if say the price will change we will need to update the field or else the data would be wrong. So in a large database if you have a lot of these calculated fields besides using a lot of memory you will need to update them frequently.
If however we generate a calculted field to find out total paid it may take a little longer time for the calcultaion but it will be updated and the value will be correct. In large databases I think generating calculated fields is a much better way to get data as it will save memory and time updating them.
Just about anyone who will use access will need to use a query (interrogated the data) at some point
What does one have to do to get access to UCL webmail?
There are three main ways to gain access to UCL webmail. These ways include being a current student at UCL, a professor at UCL, or a member of the alumni.
No. MS Access is an application which uses a (sort of) DBMS. The power of the DBMS it uses is limited which is why it is not used for larger applications.
Can you use reserved words as field names in Access?
You can use them, but it is not a god idea. You should look for alternate names for the fields if you get a reserved word warning.
It means that the mailbox can not be extended and that the calculated size of
the mailbox *after* expunging is larger than its current size. The
addition of mailbox and message meta data is greater than the message data
removed in deleted messages.
How can access an interface from another interface and how to access from a class?
Interfaces are designed to do exactly that: to interface or to interact. In object-oriented programming languages such as C++, you can incorporate up to three different interfaces per class. The private interface is accessible only to the class itself and to friends of the class. The protected interface is the same as the private interface but is also accessible to derivatives of the class. The public interface is accessible to any code.
For one interface to interact with another interface, the first must have access to the second. If the first is a friend of the second or both are members of the same class, the first has unrestricted access to the private, protected and public interfaces of the second. If the first is derived from the second but is not a friend, the first only has access to the protected and public interfaces of the second. If the first is completely separate from the second, the first only has access to the public interfaces of the second.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
It is a heading put beside a field in a database on a form, to indicate to the user what the data is for. So "Date Of Birth" would be the caption beside where you put in your date of birth on the form. Without captions it would make it difficult for users to know what data has to go into the database when they are entering it.
