DBM 280 ENTIRE COURSE(2018)

DBM 280  ENTIRE COURSE(2018)
 

WEEK  1

 
DBM 280  Week 1 Individual Assignment Create a New Access® Database
 
Instructions:

For the individual assignments in the class, you will be creating a

database to support an online store. Suggestions for online stores

include an online book store and online music store.

Complete the following to create your database:

• Create a new Access® database by selecting the 'Blank desktop

database'.

• Name your database "OnlineStore".
• Save the database.

Submit your Access® database file, as your deliverable for this

assignment, to the Assignment Files tab above.

 WEEK 2

DBM 280 Week 2 Individual Assignment Visual Aid Project, Part I

 
Instructions:

Based on this week's collaboration discussion, create a visual aid that

explains the obstacles associated with creating tables, modifying fields,

establishing primary keys and relationships, and importing data into a

table. Include solutions to overcome them.

Address the following:

• Choose two obstacles and their solutions that you personally want to

remember and believe will help you going forward working with

Microsoft® Access® databases.

• Use a software that allows you to create a visual description of your

obstacles and solutions. Examples of software you may use include

Microsoft® PowerPoint® or Piktochart. You may choose any software

that creates an electronic file you will be able to submit.

• Create at least one slide or page per obstacle/solution.
• Describe the obstacle and provide at least one solution. In total, your

file should have at least two slides or pages when this week's

assignment is complete.

Save your file in a format you can submit. Examples include the original

software file format such as PowerPoint® or PDF file format.

Submit your Visual Aid file, as your deliverable for this assignment, to

the Assignment Files tab above. 

DBM 280 Week 2 Individual Assignment Creating Tables
 
Instructions:

Using the database you created in Week One, complete the following:

• Create the tables that will support an invoicing system for the online

store.

• Include the following tables:
• "Orders"
• "OrderItems"
• "Items"
• Note: Make sure you have the following fields associated to the

correct table. These will be used in the following weeks (Order ID,

Order Date, Ship Date, Item Name, Item Price, Quantity, Customer First

and Last Name, Address, City, State, and Zip).

• Import the data for "Customers", using a Microsoft® Excel®

document (Customer_Data).

• Import the data for "Items", using a Microsoft® Excel® document

(Item_Data).

• Create the necessary fields with the appropriate data types, select

primary keys, and establish the relationships between tables.

• Include a description for each field, relevant validation rules,

formatting, and other properties.

• Add data for at least five orders. Each order should contain at least

three items.

• "Customers"

Submit your Access® database file, as your deliverable for this

assignment, to the Assignment Files tab above.

SupportingMaterial:Customer Data FileItem Data FileIndividual: Create

a New Access® Database

WEEK 3

 
DBM 280 Week 3 Individual Assignment  Visual Aid Project, Part II

 
Instructions:

Based on this week's collaboration discussion, create a visual aid that

explains the obstacles associated with creating forms, controls,

headers, and footers. Include solutions to overcome them.

Address the following:

• Add to the file you created in Week Two's visual aid by choosing two

obstacles and their solutions that you personally want to remember and

believe will help you going forward working with Microsoft® Access®

databases.

• Use a software that allows you to create a visual description of your

obstacles and solutions. Examples of software you may use include

Microsoft® PowerPoint® or Piktochart. You may choose any software

that creates an electronic file you will be able to submit.

• Create at least one slide or page per obstacle/solution.
• Describe the obstacle and provide at least one solution. In total, your

file should have at least four slides or pages when this week's

assignment is complete.

Save your file in a format you can submit. Examples include the original

software file format such as PowerPoint® or PDF file format.

Submit your Visual Aid file, as your deliverable for this assignment, to

the Assignment Files tab above. 

DBM 280 Week 3 Individual Assignment Creating Forms

 
Instructions:

Using the database you created in Week One, complete the following:

• Create a customer invoice form that allows the user to create or edit

previously entered orders (from the Week Two assignment).

• Address the following:
• Ensure that within the customer invoice, the user is able to pick a

customer from a drop-down menu and select multiple items from the

inventory database to include on the invoice.

• Use a subform for the items portion of the invoice. It is

recommended that you use at least one item form as the subform.

• Ensure that the form allows the user to specify the quantity and use

the price from the Items table to calculate a pre-tax invoice price.

• Include a header and footer within one of the forms you create.
• Ensure the form links to at least one valid customer and item.

Submit your Access® database file, as your deliverable for this

assignment, to the Assignment Files tab above.

WEEK 4

 
DBM 280 Week 4 Individual Assignment Visual Aid Project, Part III

Instructions:

Based on this week's collaboration discussion, create a visual aid that

explains the obstacles associated with building a simple query,

managing source tables and relationships, manipulating fields,

calculating totals, and generating calculated fields. Include solutions to

overcome them.

Address the following:

• Add to the file you created in Week Two's visual aid, by choosing two

obstacles and their solutions that you personally want to remember and

believe will help you going forward working with Microsoft® Access®

databases.

• Use a software that allows you to create a visual description of your

obstacles and solutions. Examples of software you may use include

Microsoft® PowerPoint® or Piktochart. You may choose any software

that creates an electronic file you will be able to submit.

• Create at least one slide or page per obstacle/solution.
• Describe the obstacle and at least one solution. In total, your file

should have at least six slides or pages when this week's assignment is

complete.

Save your file in a format you can submit. Examples include the original

software file format such as PowerPoint® or PDF file format.

Submit your Visual Aid file, as your deliverable for this assignment, to

the Assignment Files tab above.

DBM 280 Week 4 Individual Assignment Creating Queries
 
 
Instructions:

Before completing this assignment you will need to have:

• Imported the Custom and Item data
• Created entries in the Orders and Order Items tables
• Verified the tables have proper ID values to ensure they are joined

properly

Using the database you created in Week One, create the following

queries:

• A query showing all customers. Name the query, 'All Customers'.

Include all customer columns in the query.

• A query showing all customers whose last name is 'Miller'. Include

all customer columns in the query. Name the query, 'Customers by

Name'.

• A query showing all Items with a price less than $5.00. Name the

query, 'Less Expensive Items'. Include all columns in the query.

• A query showing all orders for a particular customer (you may

choose the customer and use the name or ID to select the customer).

Address the following:

• Display only the order ID, the order date, and the customer name.
• Name the query, 'Customer Orders'. Note: You will only return

orders for a single customer.

Make a copy of the 'Customer Orders' query you created. Name it,

'Customer Invoice', and include the items for the order.

Address the following:

• Include the following for the items: Item Name, Quantity, and Price.
• Display the columns: Order ID, Order Date, Ship Date, Item Name,

Item Price, Quantity, Customer First and Last Name, Address, City,

State, and Zip.

• Add a calculated field called, 'Total', for the item total (the number of

items (Quantity) multiplied by the ItemPrice). The field in the design

view should look like the following: Total: [Quantity]*[ItemPrice]

Submit your Access® database file, as your deliverable for this

assignment, to the Assignment Files tab above.

WEEK 5

DBM 280 Week 5 Individual Assignment  Visual Aid Final Project

Instructions:

Based on this week's collaboration discussion, create a visual aid that

explains the obstacles associated with creating reports using the report

wizard, using groupings and totals, and applying, sorting and filtering

within a report. Include solutions to overcome them.

Address the following:

• Add to the file you created in Week Two's visual aid, by choosing two

obstacles and their solutions that you personally want to remember and

believe will help you going forward working with Microsoft® Access®

databases.

• Use a software that allows you to create a visual description of your

obstacles and solutions. Examples of software you may use include

Microsoft® PowerPoint® or Piktochart. You may choose any software

that creates an electronic file you will be able to submit.

• Create at least one slide or page per obstacle/solution.
• Describe the obstacle and at least one solution. In total, your file

should have at least eight slides or pages when this week's assignment

is complete.

Save your file in a format you can submit. Examples include the original

software file format such as PowerPoint® or PDF file format.

Submit your Visual Aid file, as your deliverable for this assignment, to

the Assignment Files Tab above..

DBM 280 Week 5 Individual Assignment Final Database Project with Reports

 
This assignment reflects an accumulation of the individual assignments

from Weeks One through Four, which included building tables and

fields, relationships, forms, and queries, combined with the additional

task of creating reports.

Using the database you created in Week One, create the following

reports using the queries created in Week Four.

• Use the Report Wizard to create a report named, 'Average Price',

using the 'Less Expensive Items' query, that shows the items and the

average price of all items when executed.

• Display the items in descending price order (most expensive first).
• Create an invoice report named, 'Customer Invoice Report', using

the Customer Invoice query.

• Calculate and display the total for each order for the selected

customer.

• Group this report by OrderID and then by all the Customer

Information.

• Add sorting to the report so that the order items sort by quantity.

Note: If you don't have multiple items in your order you will need to add

them along with different quantities.

Review the Access® database that you have created in Weeks One

through Five, along with any feedback you received from your

instructor, and ensureyou have successfully completed the following:

• Created a functional relational Access® database
• Created tables, with both the tables and fields described accurately
• Modified, as appropriate, the fields in the tables
• Created primary keys and established relationships with properly

joined tables

• Created forms with the proper controls using the form wizard
• Created queries that manage tables, relationships, manipulated

fields, calculated totals, and generated calculated fields

• Created reports using the report wizard that use groupings, totals,

and appliedsorting, and filtering within the reports

Submit your Access® database file, as your final database project, to

the Assignment Files tab above.