Creating a database table and entering records

Name:

Date:

Class:

Quick Questions

Shade in the A or B circle for each question.

1. You want to add the fields (columns) for a new table. Which view do you use?

A Datasheet view

B Design view

2. You want to type in a new record. Which view do you use?

A Datasheet view

B Design view

3. In a table for your class, what does ONE row hold?

A One field, such as every student's name

B One record, such as one student's details

4. Which order is correct when you make a new table?

A Add the fields in design view, then enter the records in datasheet view

B Enter the records in datasheet view, then add the fields in design view

5. You have finished adding your fields and records. What should you do so your data is kept?

A Save the table and give it a clear name

B Close the program without saving

Match the Pairs

Draw a line connecting each item on the left to its match on the right.

Left column		Right column
1Design view		ARecords are typed in datasheet view, not design view. Design view is only for building fields.
2Datasheet view		BField Name: Score \| Data Type: Number
3Adding a field to a new table in design view, with a name and a data type		CEach row is one record, so two students must not share a row. Put Jai in the next row.
4Saving your table so the fields and records are kept		DThe grid screen where you type each record into its own row, one value under each field
5Typing a whole new record into the field names row in design view		EThe screen where you build the table by adding fields and choosing a data type for each one
6Row 1: Mia, 13, Jai, 12 (two students in one row)		FCtrl + S, then name it Students

Definitions

Create table

Fill in the Blanks

Complete each line of code by filling in the missing parts.

Add fields to the table in ______ view

Type each record in _________ view

Each record goes in its own ___

Press Ctrl+S to ____ the table

Select a row and press ______ to remove it

Spot the Error

Shade in the letter of the line that contains an error.

Question 1

A Open Design View

B Field: Name, Short Text

C Field: Age, Number

D Close without saving

E Open Datasheet View

Question 2

A Open Design View

B Field: Pet, Short Text

C Field: Age, Yes/No

D Save table as Pets

Question 3

A Fields: Name, Age (Number)

B Row 1: Mia, twelve

C Row 2: Sam, 13

D Save table

Question 4

A Open Design View

B Add records: Mia, 12

C Open Datasheet View

D Type records in new rows

Question 5

A Open Datasheet View

B Click the cell with the error

C Delete the whole table

D Save table

Answer Key

Creating a database table and entering records

Section A: Quick Questions

B — Design view

A — Datasheet view

B — One record, such as one student's details

A — Add the fields in design view, then enter the records in datasheet view

A — Save the table and give it a clear name

Section B: Match the Pairs

Design view → The screen where you build the table by adding fields and choosing a data type for each one

Datasheet view → The grid screen where you type each record into its own row, one value under each field

Adding a field to a new table in design view, with a name and a data type → Field Name: Score | Data Type: Number

Saving your table so the fields and records are kept → Ctrl + S, then name it Students

Typing a whole new record into the field names row in design view → Records are typed in datasheet view, not design view. Design view is only for building fields.

Row 1: Mia, 13, Jai, 12 (two students in one row) → Each row is one record, so two students must not share a row. Put Jai in the next row.

Section C: Definitions

Create table — Make a new table by adding fields in design view, then type each record into its own row in datasheet view. Save the table so your data is kept.

Section D: Fill in the Blanks

Add fields to the table in Design view

Type each record in Datasheet view

Each record goes in its own row

Press Ctrl+S to save the table

Select a row and press Delete to remove it

Section E: Spot the Error

D — The table must be saved so the design and data are kept. Line 4 should be 'Save table as Students'. Closing without saving would lose the table.

C — An age is a number, so the field type should be Number. Yes/No can only store one of two answers, so it cannot hold ages like 12 or 13.

B — The Age field is a Number field, so it needs the digits 12, not the word 'twelve'. The database would reject the text.

B — Design view is for adding fields, not records. Line 2 should add the fields Name and Age. Records are typed later in datasheet view.

C — To edit a record, you click the cell and type the correct value over it. Deleting the whole table would throw away all the records.