REVIEW M2_2024 GR6

A word or phrase used to describe the contents of a field in a database.

• Field heading

• Integer    

• Data type

• Primary key

Used to store data that is a mixture of text and number. Normally used to store data that is not used as part of a calculation.

• Currency 

• Text

• Date/Time  

• Number

A method of viewing content in MS Access where the layout of the database can be changed.

• Data sheet view

• Data type

• Short text

• Design view

Can be used to assign a number to each record in a database. The computer creates a new sequential number for each record added to the data table. Once a number has been assigned to a record, it cannot be used again, even if that record is deleted.

• Text    

• Autonumber

• Yes/No       

• Currency

A value that is unique for every record in a database.

• Field heading 

• Primary key   

• Data type

• OLE object

Store data that may be used as part of a calculation. Different number types are available, e.g. integer or decimal number.

• Number   

• Date/Time

• Text

• Hyperlink

The different ways in which data can be stored, e.g. integer, string, decimal number.

• Data type

• Primary key  

• Field heading

• Data sheet view

A method of viewing content in MS Access that allows the user to edit data.

• Simulation   

• Data sheet view

• Date/Time   

• Hyperlink

Data entered into a field can have only one of two value, such as YES/NO or TRUE/FALSE.

• Number   

• Currency   

• Text

• Yes/No

A table used to identify key data items and their key features (such as data type and field length) when designing a database.

• Data capture form

• Data type 

• Data dictionary

• Data view