Database Creation Quiz

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