RDB1_s11

Input Mask: >LL00_0?LL ... will give the result

• CFT2 3RT

• CF31 3RD

• cf31 33rd

• CF00 01RD

A __________ Database will feature interconnected tables

Which of the following is a suitable input mask for a mobile phone number format (think of the length of the field!)

• >???????????

• 0000000000

• 00000000000

• (+004) 775521

Why is data integrity important to the design of a database table structure?

Evaluate responses using AI:

OFF

A foreign key is a primary key in another table

• True

• False

• Unique in the table

• Second primary key

An example of a short date format is ...

• Monday 21st November 2022

• 21/11/2022

• 21-nov-22

• 21/11/22

What is the file extension for an Access database?

• .msaccess

• .mdb

• .accdb

• db3

Microsoft Access is ...

• Operating Application

• Utlity software

• Application software

• Project Programme

Where should you save your Database files?

• Desktop

• Google Chrome

• C:Drive

• Google Drive for Desktop

The MS Access navigation pane contains all the objects

• True

• False