I need help finding out the answers on the study guide so I can have a general idea of whats on the exam. Its all on Microsoft Access and normalization
ACG 306 Final Exam Review Name_______________________________ Assume that Credit Limit is a field in a table. Make changes in the properties to reflect the question below. Enter your response on the property form. 1. If the user tries to enter a credit limit is excess of $50,000 the entry is prevented and the user sees an explanation of his error. Page 1 of 5 ACG 306 Final Exam Review Where is data stored in Access? What is a primary key? Foreign key? Entity integrity, Referential Integrity How are many to many relationships represented in a relational database? Draw an ERD Normalize a table to 3rd normal form. Indicate how to create a query given a QBE screen. Advantages of using a form for data entry instead of a table Can you update table data through a form? Can you update table data through a report? Can you update table data through an action query? Inner join, outer join Referential integrity Null query Grouping query (aggregate) Calculations in queries Parameter Query Forms: Bound and unbound controls, combo boxes, list boxes, query behind the form. Update query Append Query Make Table Query A table contains fields for CITY, STATE, and ZIPCODE. You wish to view this information in a single field in a query, such as Wilmington, NC 28403 How would you enter the instructions on the QBE grid? What does enforcing referential integrity on the foreign key link from tblSales to tblCustomer on CustomerNumber do? A company may sell many items in one transaction and any item can be on many sales invoices. A Sales Table and a Sales/Inventory Table and an Inventory Table are used. What fields would be in the sales table? What fields would be in the sales/inventory table? What would be the primary key in each of the tables? What does the ENABLED property do? Locked property? How does the \"form wizard\" feature of Access know that both a form and subform should be generated? Page 2 of 5 ACG 306 Final Exam Review Can reports be based on forms? Queries? Tables? Query Problem: Indicate below the information that would appear on the grid above for a query that would show for each order, the order ID, Date, Company Name) and the employee name concatenated. The data should be sorted by Order ID. Show how the tables would be connected. Page 3 of 5 ACG 306 Final Exam Review Field Table Sort Criteria Or: Which tables are updated when this form is closed or the user goes to a new form? Page 4 of 5 ACG 306 Final Exam Review Proj No. 1 2 3 Ace Construction Company manages several building projects. Each project has its own project number, name, and employees assigned to the project. Each employee has an employee number, name , and a job classification such as engineer, computer technician, etc. The company charges its clients by billing the hours spent on each project. The hourly billing rate is dependent on the employee's position. Periodically, a report is generated similar to the one below: Proj Employee Employee Job Charge Hours Total Name Number Name Class per hour Billed Charges Hurricane 101 John Elect 65 11 845 News Engineer 102 David Comp. 60 16 960 Senior Tech 104 Ann Comp 60 19 1140 Ramoras Tech. Subtotal 2945 Coast 101 John Elect 65 15 975 News Engineer 103 June Biol. 55 17 935 Arbouth Engineer Subtotal 1910 Satelite 104 Ann Comp 60 18 1080 Ramoras Tech. 102 David Comp. 60 14 840 Senior Tech Subtotal 1320 Total 6775 Design tables in 3NF to generate the above report. For each table, indicate all fields. Underline the primary key(s). Show relationships between tables. Page 5 of 5
