Database

1
(No Transcript)
2
Database

• Learning Objective
• To be able to understand how to construct a
  simple database table and how to add forms
• Extended Learning Objective
• To be able to show an advanced understanding of
  how to create a simple database and forms

3
We need to do this because

• The skills you will gain will help you on your
  mock SPB and are essential for your real SPB
• You will be marked on this piece of work.

4
Database?

• Base for all your data.
• Lots of spreadsheets into one document.

5
1
Start / Core Programs / Microsoft Access
6
1
2
Click New or / Blank database
7
1
Give your Database file a name / Save in the
correct folder (Gathering information)
8
1
2
Select Tables / Open / Create table in Design View
9
1
2
Using the Database Table / Enter Field Name /
Then select Data Type
10
1
2
1st entry Code Number (select from drop down
field)
11
1
Complete each Field. (3rd row requires 4
choices). Select Lookup Wizard
12
1
Select I will type in the values. / Click next
13
1
2
Number of columns 2 / Col1 Add each coded
letter / Col2 Full name
14
1
The Date Type label? / Leave this as Type /
Click finish
15
1
Continue to add Field Names / Gluten-free
select Yes/No for the Data Type
16
1
Continue to Average Cost / Select Currency
17
1
2
Change the Decimal Places value / Choose 2 from
the drop down field
18
1
Add a Primary Key reference point or Unique ID
/ Click Key at top / Highlight Code column
19
1
2
Save As / Save the Database file / Click OK
20
1
Your table is shown (saved) / Now we have to
import data for your table
21
1
2
3
File Get External Data / Select Import YOU
MUST SAVE THE DATABASE TABLE 1st
22
1
3
2
Find the Database table to import / Click on the
file / Make sure you change to Text Files (type
of file) / Then Import
23
1
2
Select Delimited / Click Next
24
1
2
Select Comma / Click Next
25
2
3
1
Select In an Existing Table / Choose your file
from the drop down field
26
Your Database information is then Imported into
your table
27
Well done!

• You now need to
• Test the data to see if it rejects un-required
  information
• Add 3 new types of meals

28
WHAT HAVE YOU LEARNT?

• Learning Objective
• To be able to understand how to construct a
  simple database table and how to add forms
• Extended Learning Objective
• To be able to show an advanced understanding of
  how to create a simple database and forms