kuwait university college of business administratio …is.cba.edu.kw/240/240 tutorial 1.pdf ·...
TRANSCRIPT
KUWAIT UN IVERSITY COLLEGE OF BUSIN ESS ADMINISTRATIO
QMIS 240 Spring 2010 - 2011
Tutoriall: Creating and Using a Database
Durin g these tutorials and step-by-step yo u will learn some o f the key features in Access such as:
• Data entry and update add ing, changing. and deleting da ta • Reports prod uce so phis tica ted repo rts for presenting data us ing report creation
tools
• Forms produce att ractive and usefu l fO I111 S for view ing and upd ating data • Queries (Questions) ask co mplex quest ions con ce rning the data in the database
and then ret riev e ins tant answers (fi lters the who le da ta so you get only the data you wan t)
Overview of Some Ke v Concepts:
• Database: desc ribes a co llection a f da ta organ ized in a manner that allo ws acce: s. re trieval. an d use of that data .
• Database Ianagement Sys tem: such as acc ess is a software tool that allows you to usc a computer to :
Create a d atabase: add . change , and delete data in the d atabase Sort the data in the database Retrieve data in the database
'reate form and rep orts usin g the data in the d atabase
• Records: the rows in the table are called records. A reco rd contains in fo rmation about a g iv n person. product. or even t.
• Fields : rh co lumns in the table are ca lled fie lds. A fie ld conta in. a specific pie ce of information within a record .
• Primary Key (Unique Identifie r ): uniq uel identifie s each rec ord in the tab le
Eng . I-1iba AL-Meshari
Topics to be covered in this Tutorial
1. Starting access 2010
2. Creating and naming a blank database
3. Adding a table
• Swi tch ing between data sheet view and design view • Add ing fields + data type • Undo your changes • De lete a Jield • Change the name a f a fiIed • Insert a field • De signa te the primary key • Sa ve and ren: me a table
4. Adding records to a table
5. Closing a Table
6. Quitting Access
7. Re-Starting Access 2010 & Opening a Database -+ security warning
Eng. Hiba Al.-Meshari
(a) Client Table
Lab Project
JSP Recruiters is a recruiting firm that specializes in job placement for health care professionals. Because the recruiters at JSP have pre -ious experience in the health care industry, the finn is ble to provide quality candidates for employment in ho pitals, clinics, medical laboratories, doctors ' offices, and other health care facilities.
JSP recruiters works with clients in need of health care professiona ls. It assigns each client to a specific recruiter. The r cru iter works with the client to determine the necessary qualific ations for each job candidate. The recruiter then contac s and do sa preliminary review of the qualifications tor each candidate befor setting up a job interview between tile client and the candidate. I ti he candidat is hired, the client pays a percentage of the new employee's annual salary to the recruiting firm, which then distributes a percentage of that client fee to the recruiter.
To ensure that operations run smoothly, JSP Recruiters organizes data on it's clients and recruiters in a database, manag d by access. in this way SSP keeps it 's data current and accurate while the firm's management can analyze the data for trends and produce a variety of useful reports.
Requirements :
1. Create the Client table as shown in the figure below.
CO ,G<:os ,c.i? :e03r.~_ ._
First Tutorial
1. Starting access 2010
2. rearing and naming a blank database
3. Adding a table
Tables: T hings to be co vered (both da ta shee t and design view ):
• Sw itching be tween dat a sheet view and design view -+ ou mu st save the tabl e first then -+ vi w b utton -+ choose required view
• Addin g fields + data type • ndo yo ur changes -+ cl ick undo • Delete a fie ld -+ li gh t cl ick -+ delete • Change the name or a filed -+ right click -+ rena me • Insert a field -+ right cli ck -+ insert • Designate the pri ma ry key -+ us ing the button or right cl ick -+ primary key • Save and rename a tab le
4. Adding records to a table
You ha e to be in datasheet vie w 10 add records -+ yo u can add them all in this tuto rial o r on ly add a couple and leave the rest lor the next tutorial
5. Closing a Table
6. Quitting Access
7. Re-Starting Access 2010 & Opening a Database -+ security warning
Eng. Hiba AL-Meshari