Acces Database Software Flashcards
(14 cards)
Text
Letters and numbers allowed eg employee name
Numeric
Numbers only
Date and time
Data as a calendar date and time
Boolean
Data type that has one of two possible values eg yes or no
A primary key
a field in a database which is unique to each record in a database or file.
A foreign key
is a primary key from one table that appears in another table to link the two together.
One to one relationship
In a one-to-one relationship each record in one table has at most one related record in another table
One to many relationships
In a one-to-many relationship, a record in Table A can have many matching records in Table B, but a record in Table B has only one matching record in Table A.
Data validation
Data validation refers to the process of ensuring the accuracy and quality of data.
Used to:
analysis
The primary aim of data validation is to uphold accuracy and ensure an error-free dataset for further
Range check
ensures that data is between an upper and lower acceptable value, within a certain range. Range checks are useful for dates, numbers etc. eg Competitors must be aged between 11 and 16
Presence check
makes sure that a critical field cannot be left blank, it must be filled in. If someone tries to leave the field blank then an error message will appear and you won’t be able to progress to another record or save any other data which you have entered.
Data type check
confirms that the data entered has the correct data type. For example, a field might only accept numeric data. If this is the case, then any data containing other characters such as letters or special symbols should be rejected by the system
Sorting
puts data in order so that data rows which share common values for the sort field are next to each other.
Grouping
takes those common values, pulls them out of the rows, and makes sections for each group of rows which share that value.
