Access Study

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 PowerPointDB 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

NOTE – For MacOS students, if you get a Java error, please see below guidance at the bottom of the page.

Instructions/Starter File (Libre/OpenOffice Base)LibreBase-InClass.pdf Download LibreBase-InClass.pdf

(Mac OS UsersLooneyTunes-InClass.xlsx Download LooneyTunes-InClass.xlsxDownload LooneyTunes-InClass.xlsxLooneyTunes-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 Queries

Links 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.xlsx Download 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.