tbl Design 3 tables including properties for appropriate fields. Enter at least 5 records in each table. |
|
tbl Set relationships (joins) between tables | |
qry1 Create a query showing all fields from one table | |
qry2 Create a query showing fields from more than 1 table | |
qry3 Create a query using a sort (ascending or descending). | |
qry4 Create a query contain a function such as Count or Sum | |
frm1 Create a form for one table (shows one record at a time) | |
frm2 Create a form with a subform (the subform shows data from another table) | |
rpt1 Create a report using grouping (by one field), a page header, & page footer | |
Type in a separate MS Word file the following: | |
SQL Code – type out the code you would use. It is optional to include in the MS Access database file. |
|
SQL code to display all fields in one of your tables. | |
SQL code to display a few fields and use a sort on one of the fields. | |
SQL code using the COUNT function. | |
SQL code (that could be used) to create (from scratch) one of your tables. | |
SQL code to insert a new record into one of your tables. | |
Database Security Plan – explain in detail 3 ways to secure your database management system from cyberattacks or breeches. | |
List 3 future improvements (enhancements) for your system such as modifications to tables, forms, queries, and/or reports. | Using database fundamentals |