Coursework.Info - Inspiration in an Instant

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

Tables - the main place where data is stored. Information in different tables may be linked together in Microsoft Access. Queries - allow the user to select chosen information from the table or tables. Forms - can be designed to allow easier data entry. Reports - allow for presentation of printed information based on tables or queries. Validation techniques Setting the data type When you set up the database fields you have to say what type of data is to be entered. If you enter the wrong type of data the database rejects the data entry. This is a method of data validation. Validation rules Rules that limit the information to be put into the tables. You can have an error message that comes up if you enter the wrong data. This is known as validation text. Input masks These are templates for the information to be put into the table. You can say of if you want the data...

Get instant access

• Instant, unlimited access to our documents in full
• Swap your work for free access, or pay £4.99
• To see the full version of this document and 149,410 others