skip to Main Content
The smarter way
to do assignments.

Please note that this is just a preview of a school assignment posted on our website by one of our clients. If you need assistance with this question too, please click on the Order button at the bottom of the page to get started.

Project 1: Create a Microsoft Access database
Using Microsoft Access, create a new database, named youraccountname_Demographics.accdb
where youraccountname is your UWO username, based on the ERD you created in Assignment Two.
A solution to Assignment Two will be posted to OWL on Monday Oct. 5th that you can use as
reference if you have any doubts that your ERD from Assignment Two was correct.
You are to create the tables in Access based on the following specifications.
(Project 1) PART 1:
a) For the “EMPLOYEE” information use the following specifications:
1) Unique Employee ID that is automatically created when a new item is entered
note: this ID must start with YOUR initials:
so – if your name is Dolly Madision – every supply ID would start with DM
example: DM0001, where “DM” are YOUR initials
DM0002, where “DM” are YOUR initials
DM0004, where “DM” are YOUR initials
DM0007, where “DM” are YOUR initials
hint: MUST be 2 initials and four digits (see examples above)
use Autonumber (Long Integer)
NOTE: – very important:
if the Employee ID is used as a Foreign Key in another table:
– that key must be of type Long Integer
– the value entered will just be the number:
example: the foreign key is 1 where the Employee ID is DM0001
the foreign key is 2 where the Employee ID is DM0002
the foreign key is 4 where the Employee ID is DM0004
the foreign key is 7 where the Employee ID is DM0007

GET HELP WITH THIS ASSIGNMENT TODAY

Clicking on this button will take you to our custom assignment page. Here you can fill out all the additional details for this particular paper (grading rubric, academic style, number of sources etc), after which your paper will get assigned to a course-specific writer. If you have any issues/concerns, please don’t hesitate to contact our live support team or email us right away.

How It Works        |        About Us       |       Contact Us

© 2018 | Intelli Essays Homework Service®