Access Database

... Identify Problem: Create a computerised relational database using Microsoft Access for a library close by because the library has too many papers and lose many of them, so they want a database that solves all their problems. Users: The Librarian will be going to use the database, and the assistance will also use it, the assistance might not be an expert so the assistance must take classes on how to use the database because it has to be used carefully. I will also make it user friendly Objectives: * Must have more than one table (entity) to create relationships * Each table has a primary key to uniquely identify each record * Each table is linked through primary/foreign keys * The database will be 'normalised' so each table has its 'appropriate' data * Create Forms to gather data/reduce mistakes * Create Queries to search for data * Create Reports to show the output from your queries * Make

want to read more? →