Chapter 8, Problem 2AYK

5.16 LAB - Delete rows from Horse table The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Delete the following rows: Horse with ID 5. All horses with breed Holsteiner or Paint. All horses born before March 13, 2013. ***Please ensure your answer is correct and that you keep a look out for any comments that I might write back to your answer if your question gives me errors***

Creating tablesWhen creating the fields, make sure you select the correct data type and add enough characters per field.  Field names do not contain a space. Create a table named course with the following fields; course id (primary key), course num, course name Create a table named student with the following fields; student id (primary key), first name, last name, major, phone, semester, year, age. Create a table named professor with the following fields; professor id (primary key), first name, last name, department, hire date (date field). Create a table named semester with the following fields; semester, year Create a table named teach with the following fields; teach id (primary key), course id (foreign key, based on course id in course table), professor id (foreign key, based on professor id in professor table), semester, building, class room number Create a table named take with the following fields; teach id (primary key, foreign key based on teach id in the teach table),…

why is my qryLevelParameter  query coming up blank?? Create a new parameter query in Design View based on the tblStates table and the tblSessions table as described below: Add the StateName field from the tblStates table to the query. After the StateName field, add the SessionName, SessionLocation, and Level fields (in that order) from the tblSessions table to the query. Enter a parameter criterion associated with the Level field that uses the following prompt text: “Type Primary, Intermediate, or Senior” Run the query, enter Primary when prompted, and then confirm that 17 records are returned.