OMIS Schedule. Assignments and Quizzes due by end of day Sunday at the end of the week listed. While you may work ahead, quizzes will only be available during the week listed, which ends each Sunday. Monday, January 11, View the two-minute video click. OMIS Class procedures and logistics.
Access Chapter 2 Grader* Project [Assessment 1]
COMP - ACCESS Chapter 2 Grader Project Video 2
Office — myitlab:grader — Instructions GO! In this project, you will use a database to answer questions about concerts in the local college area. You will create a relationship between two tables, create a query from an existing query, and create queries using text, numeric, compound, and wildcard criteria based using the fields in one or both tables. You will create calculated fields, group data when calculating statistics, create a crosstab query, and create a parameter query. Start Access. Using Sponsor ID as the common field, create a one-to-many relationship between the Sponsors table and the Concerts table.
The Metropolitan Zoo tracks its animals in Excel. The organization decides to use a database to organize the data about the animals, their trainers, and the animal exhibits. In this project, you open an existing database and create a new table. You import an Excel file containing information about the animals, and you query the database to determine which animals need a checkup. You also create a query to obtain a listing of the animals in each exhibit.
Morris Arboretum. Project Description:. The Morris Arboretum tracks donors to their organization in Microsoft Excel. The Arboretum also uses Excel to store a list of plants in stock. The organization has grown and the files are too inefficient to handle in Excel, however, so you decide to use Microsoft Access for future Arboretum records.