Access 2007 is the database software in the Microsoft 2007 Office Suite. It allows you to order, manage, search, and report large amounts of information.
This tutorial will show how we might plan and build a database from scratch, including how to set up tables, create and use forms to enhance data integrity, design and run meaningful queries, and produce useful and attractive reports.
These are some of videos show that how to used access :
Microsoft access can help us for managing data. So, apart from that, we need to learn more how to use this software to create a powerful system for manage our database.
A billion thanks to both of you because teach me this subject. I had learn a lots of thing form both of you in this subject. I'm very enjoy during your class session. Hope will see u soon dr..sob2...sedih la plak..sob3..Segala jasa-jasa En. Razak & Dr. Fendy akan dikenang...insyaallah...Terimalah pantun ni, dari saya..khas buat buat En. Razak & Dr. Fendy... ehem..ehem..eheeemmmmm....
Database design is the process of producing a detailed data model of a database. This logical data model contains all the needed logical and physical design choices and physical storage parameters needed to generate a design in a Data Definition Language, which can then be used to create a database. A fully attributed data model contains detailed attributes for each entity.
The design process consists of the following steps
Determine the purpose of your database - This helps prepare you for the remaining steps.
Find and organize the information required - Gather all of the types of information you might want to record in the database, such as product name and order number.
Divide the information into tables - Divide your information items into major entities or subjects, such as Products or Orders. Each subject then becomes a table.
Turn information items into columns - Decide what information you want to store in each table. Each item becomes a field, and is displayed as a column in the table. For example, an Employees table might include fields such as Last Name and Hire Date.
Specify primary keys - Choose each table’s primary key. The primary key is a column that is used to uniquely identify each row. An example might be Product ID or Order ID.
Set up the table relationships - Look at each table and decide how the data in one table is related to the data in other tables. Add fields to tables or create new tables to clarify the relationships, as necessary.
Refine your design - Analyze your design for errors. Create the tables and add a few records of sample data. See if you can get the results you want from your tables. Make adjustments to the design, as needed.
Apply the normalization rules - Apply the data normalization rules to see if your tables are structured correctly. Make adjustments to the tables
SUMMARY :
In this chapter, this is very important part before we create our own system or database. In this designing database, we choose what type of table we want to used, how we want to link it and what are the type of data which is attribute we want to keep in our database. An example of designing database, we can used Microsoft access which is provide us variety of function to save the database. For example, we can save, delete, search print report and others things.
Other than that, we also can used MySql to design our database. In this database, we can storage huge of data and its provide connection with PHP for example with our system.
Data Management is a broad field of study, but essentially is the process of managing data as a resource that is valuable to an organization or business.
Administrative process by which the required data is acquired, validated, stored, protected, and processed, and by which its accessibility, reliability, and timeliness is ensured to satisfy the needs of the data users.
Problem With Traditional Files
The traditional file system had suffered a number disadvantage as firms tended to grow day by day. The problems with traditional file environment include-
Data redundancy:
Data redundancy is the presence of duplicate data in multiple data files
Program data dependence:
Program data dependence is the tight relationship between data stored in files and the specific programs required to update and maintain those files.
Lack of flexibility:
lack of flexibility is a traditional file system can deliver routine scheduled reports after extensive programming efforts but it can not deliver ad hoc reports or respond to unanticipated information requirement in a timely fashion.
Poor security:
Because there is little control or management of data, access to information may be out of control.
Lack data sharing and availability:
Lack of control in accessing data and not easy to retrieve the information
DBMS
A software system that facilitates the creation and maintenance and use of an electronic database.
A database management system (DBMS) is a software package with computer programs that control the creation, maintenance, and use of a database. It allows organizations to conveniently develop databases for various applications by database administrators (DBAs) and other specialists.
(DBMS) is computer software designed for the purpose of managing databases. Typical examples of DBMSs include Oracle, DB2, Microsoft Access, Microsoft SQL Server, Firebird, PostgreSQL, MySQL, SQLite, FileMaker and Sybase Adaptive Server Enterprise. DBMSs are typically used by Database administrators in the creation of Database systems. (Wikipedia, 2008)
Advantages of DBMS
The advantages of DBMS are as follows: -Controlling redundancy -Providing storage structure for efficient query processing. -Restricting unauthorized users. -Providing concurrency. -Providing backup and recovery. -Enforcing integrity constraints.
Disadvantages of DMS
The disadvantages are as follows:
-Centralization:That is use of the same program at a time by many user sometimes lead to loss of some data.
-High cost of software.
technical experties are required
SUMMARY :
In this topic, I learned that the powerful of DBMS that will help us to manage a huge data. This is give us opportunity to manage the data easily and in a systematic ways.
Coventry :CTI Law Technology Centre:University of Warwick.
Three issues a year
Volume/date range Issue 1 (Jan. 31, 1996)-
Library has Vol. 4, no. 6, 1997-
ISSN 1361-4169
1.Information technology Law and legislation Periodicals
2.Data protection Law and legislation Periodicals
3.Electronic commerce Law and legislation Periodicals
4.University press publications
5.Electronic journals
International journal of education and development using information and communication technology.
Bridgetown, Barbados :University of the West Indies
Quarterly
Vol. 1, no. 1 , 2005-
Library has Vol. 2, no. 3, 2005-
ISSN1814-0556
1. Information technology Economic aspects Periodicals 2. Communication and technology Periodicals 3. Communication in economic development Periodicals 4. Educational technology Periodicals
VIDEOCASSETES
Selamat Pagi Malaysia : majlis pengisytiharan sambutan 100 tahun sejarah penglibatan UTM dalam kejuruteraan dan teknikal[Pita Video].
Johor : Universiti Teknologi Malaysia,Perpustakaan Sultanah Zanariah, 2005
3 videocassettes ; 120 min. ; : sd., col.
Menunjukkan majlis pengisytiharan sambutan 100 tahun sejarah sejauh mana penglibtan UTM dalam bidang kejuruteraan dan teknikal.
1. Universiti Teknologi Malaysia
Pipe welding/ [videocassettes]
Garden City, New York, Bergwall Video ,1998. Pages: 6 videocassettes (1 hr 22 min) : sd., col.; 12mm +
Show that what is the pipe welding and the steps need to be followwhen we want to welding.
1. Pipe welding2.weldingI.Bergwall
MACROFILM
Society of Petroleum Engineers : technical papers, 1990 supp./ [microfiches]
United States: University Microfilms International,1991.
Microfiches 10x15cm;
Series: SPE technical paper series;
Petroleum engineering I. Society of Petroleum Engineers II. Series
Chartered quantity surveyor [mikrofilem]
United States :University Microfilms International,1979.
Pages: reels (positive); 35mm;
1. Building estimateI. Ann Arbor, Mich
CD-ROOM COURSEWARE
English Language Pronouns [CD-Room]
Kuala Lumpur: Bahagian Teknologi Pendidikan, 2004.
1CD ; bwn.
System requirements :
Pentium 100 HMz or higher; 16 RAM or more; Microsoft video for window,
Microsoft window 98 or higher; at least 640 x 480 screen display with 65000 color; 8xCD-ROOM drive for faster; 16 bit sound card and speakers.
This courseware is developed in order to assist the phase 1 pupils especially year 2, to acquire and master this grammar item through a variety of meaningful activities.