Font size
WorksheetsDatabase Creation Quiz
Total questions: 20
Worksheet time: 13mins
What is the first step in creating a database according to the Rock Bands tutorial?
Design the table
Load Access
Enter table name
Click VIEW
What should you name the blank desktop database in the tutorial?
Bands.accdb
Music.accdb
RockBands.accdb
Database.accdb
What is the table name you need to enter in the design step?
tblMusic
tblBands
tblArtists
tblSongs
What is the ID known as in a relational database?
Foreign Key
Secondary Key
Primary Key
Composite Key
Which field type is used for the 'BandName' in the database?
Long Text
Short Text
Number
Currency
What field type is used for 'YearFormed' in the database?
Currency
Short Text
Date/Time
Number
What is the first step in creating a second table called tblBandMembers?
Click VIEW
Click CREATE
Click SAVE
Click DELETE
What data type should be used for the BandID in the tblBandMembers table?
Text
Date
Number
Currency
What must the BandID match in the tblBandMembers table?
The name of the band
The ID used in the first table
The position of the member
The date of creation
What is the ID known as in a relational database?
Foreign Key
Primary Key
Secondary Key
Composite Key
Which tool do you use to add a relationship between two tables in a database?
DATABASE TOOLS > Relationships
FILE > New
HOME > View
CREATE > Table
What action should you take to see related records in another table after double-clicking tblBands?
Click the minus sign (-)
Click the plus sign (+)
Click the refresh button
Click the delete button
What is the purpose of SQL in a database?
To create graphics
To write, search or edit the contents of the database
To design web pages
To write emails
What is the first step to create a new query in the document?
Click on FILE
Click on CREATE>QUERY WIZARD
Click on VIEW>SQL VIEW
Click on DATABASE TOOLS
What SQL command is used to select the ID and BandName from tblBands?
SELECT ID, BandName from tblBands;
INSERT INTO tblBands (ID, BandName);
DELETE FROM tblBands WHERE ID = 1;
UPDATE tblBands SET BandName = 'NewName';
What is the purpose of clicking the 'Run' button in the query tab?
To delete the query
To execute the query and generate output
To save the query
To close the query tab
Which SQL command is used to add a new band named "Black Crows"?
UPDATE tblBands SET BandName = "Black Crows"
DELETE FROM tblBands WHERE BandName = "Black Crows"
INSERT INTO tblBands (BandName) values ("Black Crows")
SELECT * FROM tblBands WHERE BandName = "Black Crows"
What SQL command is used to delete a record from a table?
INSERT INTO
UPDATE
DELETE FROM
SELECT
Which option should be selected to ensure changes in one table affect the other?
Enforce referential integrity
Add a new relationship
Delete the existing relationship
Change the table structure
Draw how a database is represented in a network diagram. (a barrel)
