Databases: Sql and Skills Development Databases Essay

Submitted By nlg592
Words: 915
Pages: 4
Open Document
Functional Skills ICT Skills
Level 1

Database Learning Resource 2003 Version Task 1

Microsoft product screen shot(s) reprinted with permission from Microsoft Corporation.

Excellence in skills development

DATABASES LEVEL 1 TASK 1

9

9.1 Edit and sort a database table
As you work through, you will find help available in the Database Information Pack, if you need to use it. N.B. Before you begin this section, you may want to do the Level 1 IT Basics module.

Introduction
There have been many changes, to the keeping of records, since computers have entered our lives. Computers can be used to store large amounts of information. In the past all records have been stored on paper in filing cabinets. This has now changed to records and information being stored in databases on computers. Databases make keeping and viewing the stored information very easy. A database can be used to store customers’ names and addresses. A database can be set up to enter the customer’s name or a membership number and then the rest of the details for that customer will then be shown on the screen. Databases are used in many organisations. Below are some examples:        Library; Doctor’s surgery; Government departments; Shops; Hospitals; Police; Schools.

In the past, there have been written records of any visits you make to the doctors. When visiting the doctors now, all your information is recorded in a database on the computer system. All the doctors within the practice will be able to access your information from their own computers. There will be a record of any medication you have been given and when you were given it. Information can be added each time you visit. Organisations wishing to store personal details have to register under the Data Protection Act 1998. This is to protect personal details from becoming public knowledge. The Data Protection Act 1998 sets out rules for organisations. Organisations have to make sure that all data stored on a database is accurate, secure and must be deleted as soon as it is no longer needed. We are going to be using the database software called Microsoft Access. There are other database software packages available.
©West Nottinghamshire College

2

Excellence in skills development

DATABASES LEVEL 1 TASK 1

9

Open Microsoft Access
Open Microsoft Access. Maximise the window.

Open a database
Open the database called DB L1 9.1-For Sale, which is saved in your folder. When a database opens, all the objects which you may want to create are listed on the left. We are going to look at a table which has already been created. Click on Tables. The Houses For Sale table should be in the list for you to choose.

Help if you need it!
Database Information Pack Page Open a database ........................................................................................................................ 34 Open Microsoft Access ............................................................................................................. 37 Resize and move a window ....................................................................................................... 42

©West Nottinghamshire College

3

Excellence in skills development

DATABASES LEVEL 1 TASK 1

9

Open a table in datasheet view
Open the table called Houses for Sale in datasheet view. Write down the field names in the Houses for Sale table.

1

2

3

4

5

Records
Write the address of the first record in the Houses for Sale database table.

Help if you need it!
Database Information Pack Page Fields/Field names..................................................................................................................... 32 Open a database table in datasheet view .................................................................................. 35 Records
Show More

Related Documents: Databases: Sql and Skills Development Databases Essay

Pravarshi R Essay

Pravarshi R Hadoop Developer - Comcast New Jersey - Email me on Indeed: indeed.com/r/Pravarshi-R/8269aeeecb18f151 Over 5+ years of programming experience with skills in analysis, design, development, testing and deploying for large scale distributed data processing using Hadoop, Pig, Hive and Java and other various software applications with emphasis on Object oriented programming. About 5 years of work experience on Big Data Analytics. Strong hands on experience with Big Data Technologies including…

Words 1560 - Pages 7

Essay on Portfolio: Golf and Devry University

Elevator Speech - 4 - Education Background - 5 - Resume - 5 - Professional Development and Training - 7 - Awards and Accomplishments - 7 - Volunteer History - 7 - Professional Affiliation - 8 - Career Path - 8 - Work Samples - 8 - Referees - 8 - Statement of Authenticity This is to confirm that this is the portfolio of Patrick DiNicolas. It contains information detailing his education background, work experience and skills. This document should not be copied either in full or part without prior…

Words 734 - Pages 3

Job Shadowing

department is also in charge of the databases and keeping them updated. They also handle, what they call as ‘incidents’ which is just them troubleshooting problems that other employees have when they are using some of the software that the team developed. He was showing me some examples, and most of the time its just silly problems the employees encounter that could be solved with a small amount of problem solving skills. So, what the typical day looks like is a lot of database updating and querying, incident…

Words 845 - Pages 4

SQL help Essay

SQL: Introduction DH3J 34 Section 1: Create and maintain a data storage system © SQA Updated 2007 Developed by COLEG SQL: Introduction DH3J 34 Introduction to this section What this section is about In this section the students will learn the basic commands behind SQL and be able to create, insert and modify tables in a relational database. Outcomes, aims and objectives The aim of the section is to learn how to create and modify tables in a relational database and insert…

Words 7736 - Pages 31

Essay SOP CS sample

Now everything is stored in byte format. As the data increases the time required to process increases. Now- a-days most of the transactions are done by internet banking. The data needs to be saved properly in secure place. My aim is to develop a database system which is highly scalable and which will fetch the record in very little time span. To perform accurate analyses which lead to confident decision making on structured and unstructured data available. Also to secure the data from intruder and…

Words 1046 - Pages 5

Neeraj Updated Resume Essay

communication and interpersonal skills. Work Experience Key Responsibilities Highlights of work done in Shaural Infotech Pvt ltd like: To perform manual testing for different enhancement and respective release. Updating and logging the defects in bug tracking tool. Worked on different project for different client. Involved in finding defects, logging defects and verification. Skill Set: Operating System : Windows XP/NT/2000, Vista, Windows 7 Databases : SQL Server, Oracle Defect Tracking Tools…

Words 734 - Pages 3

Week 5 Assessment Essay

to the project, the timelines and the expected results. It Will also include what is out of scope The project scope of this project will be change the database to track current inventory, track sales person, and set reorder limits so inventory is never sold out. Currently out of scope is creating the Web interface front end to access the database back end 3. Create a Requirements document that ties the business requirements to the goals of the project. a. The requirements document will include…

Words 1640 - Pages 7

Software Developer Essay

SOFTWARE SPECIFICATION 22 6.3 PLATFORM SPECIFICATION 23 6.3.1 .NET FRAMEWORK 2005 23 6.3.2 SQL SERVER 2005 26 iii 7 SYSTEM DESIGN 29 7 .1 DATA FLOW…

Words 6807 - Pages 28

Assignment Berif Essays

April 2013 Submission location: Uploaded to VLE Introduction In this assignment you will consider the nature of information and how an information system can gain a business a competitive advantage. You will plan, design and implement a database solution that meets a specific business scenario. Assignment brief Read the following case study carefully. It is based upon a local estate agency which currently uses a paper based system for processing sales. -------------------------------------------------…

Words 1498 - Pages 6

Cloud Computing: What IT Professionals Need To Know

new career opportunities for IT professionals. In many cases, existing core skill sets transfer directly to cloud technologies. In other instances, IT pros need to develop new skill sets that meet the demand of emerging cloud job roles. Companies that consider moving to cloud computing will want to educate their IT professionals about the potential opportunities ahead so that they can build staff capabilities and skills ahead of the change. Chief Information Officers (CIO) who want to generate more…

Words 4132 - Pages 17