100%(1)1 out of 1 people found this document helpful
This preview shows page 16 - 20 out of 239 pages.
Either all the rows can be updated, or a subset may be chosen using acondition.11
Code: IET 06105Syntax:UPDATE table_name SET column1=value1, column2= value2WHERE some_column=some_value; Example of updateUPDATE CustomersSETContactName='Alfred Schmidt', City='Hamburg'WHERECustomer Name='Alfreds Futterkiste';DELETEstatement is used to delete records in a tableSyntax:DELETE FROM Table_nameWHERE some_colum= some_valueExample of deleteDELETE FROM mytable WHERE id IN (SELECT id FROMmytable2);Microsoft Access: Access is an interactive, relational databasemanagement system. A database is an organized collection of data storedin categories that are accessible in a logical or practical manner.Relational databases enable data to be stored in multiple tablesLinked together via data indexesThe 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 organized12
Code: IET 06105Update the data once you've collected them by adding or deletingrecords and by changing existing records; An electronic filing cabinet such as a database allows you also to easilyand quickly use the data-sort them, create reports, merge the data withother documents, and so forth. How is a database organized? Access is an object-oriented relationaldatabase Management system.The objects that make up any particulardatabase that you create using Access are illustrated in fig. belowThe access database objectsThe word "intelligent" is enclosed in quotes so as not to create a falseimpression. With regard to computers, the word is overused, and strictlyspeaking inappropriate. It also can be misleading.13
Code: IET 06105The only "intelligence" exhibited by these otherwise "dumb “machineshas been programmed in to them by intelligent human beings.A tableis an object which represents the data in rows and columns,rather like a spreadsheet. For this reason, when you view a table in anAccess database, you are in what access refers to as a datasheet viewyou will learn about Tables in this lessonAqueryis an object which makes a request to the database to find someset of data that is stored in the databaseA form is an object which gives the user another view of the data in thedatabase. Whereas a Table allows the user to view multiples records atonce, a Form displays the contents of just one record at a time. Areportis an object which is designed based on the data in the databaseand which is used to inform the user of the selected contents of thedatabase.AMacrois a sequence of instructions which can be carried out with asingle click of the mouse button on a button in a toolbar or by pressing akey or combination of keys on the keyboard.