{"id":108158,"date":"2022-12-05T03:25:22","date_gmt":"2022-12-05T03:25:22","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/ms-access-is-preferable-to-open-office-which\/"},"modified":"2022-12-05T03:25:22","modified_gmt":"2022-12-05T03:25:22","slug":"ms-access-is-preferable-to-open-office-which","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/ms-access-is-preferable-to-open-office-which\/","title":{"rendered":"Ms access is preferable to open office which"},"content":{"rendered":"
\n

\u00a0\u00a0<\/p>\n

\u00b7 Projects <\/p>\n

\u00a0<\/p>\n

\u00a0
\u00a0<\/p>\n

o MS Access<\/strong> is preferable to Open Office which is a viable option for those without Access<\/p>\n

\u00a0
\u00a0<\/p>\n

o Use your own data. Don\u2019t look to download anything from the site.<\/p>\n

\u00a0
\u00a0<\/p>\n

o Make the data realistic. It does not have to be real, but don\u2019t do things like using A, B, C, etc. for names or just whole numbers for GPA. Use 2 decimal position GPAs.<\/p>\n

\u00a0
\u00a0<\/p>\n

o Use enough data to test all conditions. Make sure the data proves the queries worked<\/p>\n

\u00a0
\u00a0<\/p>\n

o Pay attention to format, spelling, etc. on the report<\/p>\n

Part 1:<\/p>\n

Course Project Part 1<\/strong><\/p>\n

You are required to use OpenOffice<\/a> software to build tables, write, and execute queries.<\/p>\n

\u00a0
\u00a0<\/p>\n

1. Build a Database named DBMS Course Project. The database should include following tables. <\/p>\n

\u00a0<\/p>\n

\u00a0
\u00a0<\/p>\n

o First Table \u2013 Students <\/p>\n

\u00a0<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 ID<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 First Name<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Last Name<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Address<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 City<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 State<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Zip Code<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Phone Number with area code<\/p>\n

\u00a0<\/p>\n

o Second Table \u2013 GPA <\/p>\n

\u00a0<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 ID<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Current GPA<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Class <\/p>\n

\u00a0<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 1 (Freshman)<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 2 (Sophomore)<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 3 (Junior)<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 4 (Senior)<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 5 (Graduate Student)<\/p>\n

\u00a0<\/p>\n

o Third Table \u2013 Scholarships <\/p>\n

\u00a0<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 ID<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Major course of study<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Academic Scholarship (Yes or No)<\/p>\n

\u00a0
\u00a0<\/p>\n

\u00a7 Athletic Scholarship (Yes or No)<\/p>\n

\u00a0<\/p>\n

2. Extract the First and Last Name, Address, City, State, Zip Code and Phone Number of each senior on the database. Sort by Last Name, then First Name (1 sort).<\/p>\n

\u00a0<\/p>\n

3. Extract the First and Last Name, and GPA of each student who qualifies for the Dean\u2019s List. Sort by GPA, then Last Name, then First Name (1 sort). A GPA of 3.25 is required to make the Dean\u2019s List.<\/p>\n

Part 2:<\/p>\n

Course Project Part 2<\/strong><\/p>\n

You are required to use OpenOffice<\/a> software to write and execute queries with tables you created in project part 1.<\/p>\n

\u00a0
\u00a0<\/p>\n

1. Extract the First and Last Name, Student ID, Course Major and GPA of any students on athletic scholarship. Sort by Student ID.<\/p>\n

\u00a0<\/p>\n

2. Produce a report with the data from Step #1 and Use good headings.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

\u00a0\u00a0 \u00b7 Projects \u00a0 \u00a0\u00a0 o MS Access is preferable to Open Office which is a viable option for those without Access \u00a0\u00a0 o Use your own data. Don\u2019t look to download anything from the site. \u00a0\u00a0 o Make the data realistic. It does not have to be real, but don\u2019t do things like using […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-108158","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108158","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=108158"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/108158\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=108158"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=108158"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=108158"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}