Covers the following areas:
describe the three types of relationships
create and interpret an entity relationship diagram
evaluate difference between flat file & relational database
create a relational database
analyse the function of key fields (including: primary key, compound key, foreign key)
validate and verify data entry
use validation rules
test validation applied to a database
complex queries using multiple criteria
using text, numeric, date, time, wildcard, Boolean operators (AND, OR, NOT), ., ,, =, .=, ,=
create and evaluate an appropriate data entry form
describe the three types of relationships
create and interpret an entity relationship diagram
evaluate difference between flat file & relational database
create a relational database
analyse the function of key fields (including: primary key, compound key, foreign key)
validate and verify data entry
use validation rules
test validation applied to a database
complex queries using multiple criteria
using text, numeric, date, time, wildcard, Boolean operators (AND, OR, NOT), ., ,, =, .=, ,=
create and evaluate an appropriate data entry form
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£3.00