Hannah's IGCSE Ict
Home
Lesson Notes
Theory
>
Section 1 ~ Components and Types of Computers
Section 2 ~ Input and Output Devices
Section 3 ~ Storage and Media
Section 4 ~ Networks
Section 5 ~ Database Theory
Section 6 ~ Effects of ICT
Section 7 ~ User of ICT
Section 8 ~ Systems Analysis and Design
Practical
>
Section 9 ~ Communication
Section 10 ~ Document Production
Section 11 ~ Databases
Section 12 and 13 ~ Integration and Outputting Data
Section 14 ~ Spreadsheets
Section 15 ~ Websites
Section 16 ~ Presentations
Exam Questions
Useful websites
Assessment Results
Year 9
>
Feedback log
Year 10
Year 11
Database Theory
3/18/2015
0 Comments
0 Comments
Importing data
3/12/2015
0 Comments
0 Comments
Questions
3/12/2015
0 Comments
0 Comments
Importing Data
3/5/2015
0 Comments
Steps
close the blank table
select external data
click textfile in import and link
import text file
click next
select 'first row contains field name'
next
choose text for forename, surname, address line 1, address line 2, post code,phone number
choose yes/no for allergy, deposit paid
choose currency for amount paid
choose date for date paid
next
let access add primary key if no unique field
next then finished
press home-view-design view
format- click and scroll and chose correct one
save
0 Comments
Data
2/24/2015
0 Comments
Data is raw facts and figures
Data on it's own has no meaning e.g
674
or
wig
0 Comments
database theory
Archives
No Archives
Categories
All
RSS Feed