Access 2013/Infomation Systems

Please remember that this is a professional business document and should appear as such.

Using Access 2013, demonstrate that components of your application project have the potential to work by creating at least two of the tables described in Part 3. Create a data entry screen (input form) for each of these tables. Use these data entry screens to input at least twenty‐five sample data records for each of these tables.

Using these tables, create queries to prepare the data for two of the reports you described in Part 2. This should be the result of a process that queries both of the above tables, not a simple listing of the table contents. Give each query the same name as the report it will be used to produce. Also create the two reports.

For each table,

· The definition of the table.

o For the definition of a table:

· Include for Tables ‐‐ Properties Relationships

· Include for Fields ‐‐ Names, Data Types, Sizes

· Include for Indexes ‐‐ Names, Fields, Rational

· A minimum of fifteen sample data records for each table.

· A custom input form for each table.

For each report

· The definition of the query used to select the data for the report.

· For the definition of a query:

o Include for the Query ‐‐ Properties ‐ SQL

o Include for the Fields ‐‐ Names, Data Types, Sizes

o The results of the query.

Include a written overview of what additional components such as tables, queries, forms (data / input) and reports (information / output) will be included in your final project.