Excel Question

Those with a PC with MS Office with Access complete this section.  MacOS users or PC Users without MS Access see below.  

Background Resources(PC or Mac)
Database Overview PowerPoint
DB Normalization Mini Lecture Video

Instructions/Starter File (MS Access)
AccessCS-InClass.pdf
LooneyTunes-InClass.xlsx (Right click and Save As to download the starter Excel file)

Instructional/Helper Videos (MS Access)
Normalizing Excel for import into Access video
Importing into Access, Relationships, Queries, Form, Report video

Submit the following files (MS Access)
(1) Completed Excel file
(2) Access Database (.accdb) file.  NOTE – Close Access before uploading
(3) PDF export of the report

Rubric (MS Access)
LooneyTunes-GradeSheet.xlsx

MacOS users or PC Users without MS Access complete per below

Instructions/Starter File (Libre/OpenOffice Base)
LibreBase-InClass.pdf  Download LibreBase-InClass.pdf Download LibreBase-InClass.pdf (Mac OS Users – There are workarounds on steps 15 and 17)
LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsx
LooneyTunes-GradeSheet-Libre.xlsx Download LooneyTunes-GradeSheet.xlsx Download LooneyTunes-GradeSheet-Libre.xlsx Download LooneyTunes-GradeSheet.xlsx

Instructional/Helper Videos (Libre/OpenOffice Base)
Normalizing Excel for import into LibreOffice Base
Relationships and QueriesLinks to an external site.
Creating Reports and Exporting

Submit the following files (Libre/OpenOffice Base)
(1) Excel file
(2) LibreOffice or OpenOffice Base file (close LibreOfficeBase/OpenOfficeBase before uploading)
(3) PDF export of the report

Rubric (Libre/OpenOffice Base)
LooneyTunes-GradeSheet-Libre.xlsxDownload LooneyTunes-GradeSheet-Libre.xlsx
Links to an external site.

MAC OS Users Troubleshooting – Do these in the following order

1. Go to this siteLinks to an external site. to download Java for Mac OS and then run LibreOffice.
2. Launch LibreOffice. Navigate to the preferences window (“LibreOffice” menu in the top left corner of the screen, then ‘Preferences’). Select ‘Advanced’ from the list of options on the left hand side. This should display the preference options for Java. If the installation of the JDK has gone well, it should already have a tick in the option for ‘Use a Java runtime environment’. In the pane below that, a radio button should indicate that the vendor is Oracle Corporation 
3. If there is no Java package selected, you can add it manually. Click on the ‘Add’ button on the right hand side of the preference window. A normal Mac OS file dialogue box will open. Using that, navigate to the top of your Mac’s hard disk. This should list the following folders: Applications, Library, System, Users. Select ‘Library’. In the Library folder select ‘Java’, then ‘JavaVirtualMachines’. Within that, select the most recent (probably only) version of the JRE. Then, within that ‘Contents’, then ‘Home’. Then press the ‘Open’ button on the MacOS dialogue box to select that as the location.
4. If this does not work, please try OpenOffice in lieu of LibreOffice.  You can download hereLinks to an external site..  Since OpenOffice is not digitally signed, you will need to right click, then select Open.  The instructions for the table imports have a few notes for Mac OS (steps 15 and 17), but otherwise the instructions are the same for LibreOffice and OpenOffice.  NOTE – The screens are slightly different between LIbreOffice and OpenOffice.

Collepals.com Plagiarism Free Papers

Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.

Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS

Why Hire Collepals.com writers to do your paper?

Quality- We are experienced and have access to ample research materials.

We write plagiarism Free Content

Confidential- We never share or sell your personal information to third parties.

Support-Chat with us today! We are always waiting to answer all your questions.