Either all the rows can be updated or a subset may be chosen using a condition

Either all the rows can be updated or a subset may be

This preview shows page 16 - 20 out of 239 pages.

Either all the rows can be updated, or a subset may be chosen using a condition. 11
Image of page 16
Code: IET 06105 Syntax: UPDATE table_name SET column1=value1, column2= value2 WHERE some_column=some_value; Example of update UPDATE Customers SET ContactName='Alfred Schmidt', City='Hamburg' WHERE Customer Name='Alfreds Futterkiste'; DELETE statement is used to delete records in a table Syntax: DELETE FROM Table_name WHERE some_colum= some_value Example of delete DELETE FROM mytable WHERE id IN (SELECT id FROM mytable2); Microsoft Access : Access is an interactive, relational database management system. A database is an organized collection of data stored in categories that are accessible in a logical or practical manner. Relational databases enable data to be stored in multiple tables Linked together via data indexes The database component of MS Office is designed to act as an "intelligent" Electronic filing cabinet. Like a manual filing cabinet, it enables you to Collect sets of related data and keep the data organized 12
Image of page 17
Code: IET 06105 Update the data once you've collected them by adding or deleting records and by changing existing records; An electronic filing cabinet such as a database allows you also to easily and quickly use the data-sort them, create reports, merge the data with other documents, and so forth. How is a database organized? Access is an object-oriented relational database Management system.The objects that make up any particular database that you create using Access are illustrated in fig. below The access database objects The word "intelligent" is enclosed in quotes so as not to create a false impression. With regard to computers, the word is overused, and strictly speaking inappropriate. It also can be misleading. 13
Image of page 18
Code: IET 06105 The only "intelligence" exhibited by these otherwise "dumb “machines has been programmed in to them by intelligent human beings. A table is an object which represents the data in rows and columns, rather like a spreadsheet. For this reason, when you view a table in an Access database, you are in what access refers to as a datasheet view you will learn about Tables in this lesson A query is an object which makes a request to the database to find some set of data that is stored in the database A form is an object which gives the user another view of the data in the database. Whereas a Table allows the user to view multiples records at once, a Form displays the contents of just one record at a time. A report is an object which is designed based on the data in the database and which is used to inform the user of the selected contents of the database. A Macro is a sequence of instructions which can be carried out with a single click of the mouse button on a button in a toolbar or by pressing a key or combination of keys on the keyboard.
Image of page 19
Image of page 20

You've reached the end of your free preview.

Want to read all 239 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture