Tables
Identify the tables contained in your database and describe the contents of each table(need 6 tables), including the data fields in each table, the primary key, and any foreign key(s). Please also include a relationships diagram, using Access’s Documentor tool for this. A minimum is twenty (20) records per table. Projects with at least ten data fields for each table will receive more credit than those with less than these amounts. Need one-to-many relationships within tables.Queries
Document the twelve (12) separate queries you created, as identified above. For each query, indicate in your report why you created the query, what information it selects, and how it helps your business. It is not necessary to screen capture the outputs from each query, but a screen capture of each query in design view with full formulas showing would be helpful. Also, please create a two-column table that lists the special requirements by number, and which one of your queries satisfies it.Forms
Document the six (6) forms you created as identified above. Each form should contain a separate title (e.g., “Employee Intake Form”), your company’s name and logo, and colors that are consistent with the other forms in your project. Please describe each form in your report and how it would help your company. Projects with forms that are well formatted—for example, with city, state, and zip code appearing on the same line of the form instead of in a single, default column—and with logical tab orders will receive more credit than those forms without such formatting. Finally, please create a table similar to the one indicated above with a list of requirements and which of your forms satisfies them.Get Project Solution by contacting us
- via WhatsApp: +92-324-7042178- via email: codelogixstudio@gmail.com