IDP 1 – Voter Form 2

1. Download your database here: 2014 Voters Access Database
2. Create a form with logo and design like the one shown below.

-glenoid

SAS 2 – Text Orientation

• Prepare the 2 sheets shown below.

SHEET 1 – EXCEL QUIZ

SHEET 2 – PAYMENTS

• Format the sheets to look like the ones shown below.
  • Highlight the cells to be edited.
  • Click ‘Orientation’.
  • Select the orientation needed for each sheet.

-glenoid

IDP 1 – Importing (Access to Access)

Follow the instructions on how to import data from MS Access to another MS Access. This will be checked so in case of a glitch, ask for assistance.

• Open the previous Access file created from the previous activity. Then open another blank Access database. You should Database1 in order to complete the import.

Database1

Database2

• On Database2, click External Data.

• Click Access.

• Click Browse. Find your Database1 or your first database. Click OK.

• Click the table that you want to import. In this example tblDebian. Then click OK.

• This window will appear upon successful import. Click Close to dismiss.

• Check if the table was successfully imported to the new Access database.

-glenoid

IDP 1 – Importing (Excel to Access)

Follow the instructions on how to import data from MS Excel to MS Access. This will be checked so in case of a glitch, ask for assistance.

• Create a simple sheet in excel as shown in the figure below. Save it and close, then open MS Access.

• Click EXTERNAL DATA.

• Click Excel.

• Browse your saved Excel file you saved earlier. Follow the setup below then click OK.

• Choose the first sheet. Then click Next.

• No checks should be made in this step. Just click Next.

• Click the first column and rename it to s_no. Set type to Integer.

• Click the next column and rename it to s_name. Set type to Short Text or Text. Click Next.

• Choose s_no as the primary key value. Click Next.

• Rename the table to tblDebian. Check the checkbox to analyze. Then click Finish.

• Click Yes to analyze.

• Click Cancel to exit the tutorial.

• Click Close to Finish the setup.

• Open your tblDebian to check if data was successfully imported.

-glenoid

IDP 1 – Creating and Formatting a New Table

When creating a database, the next best thing to do is to create table to put some data in. Here’s how:

• Right-click on Table1 and click Design View.

• Change the name of the table to tblFriends.

• Type in the Field name and its data type. After encoding, press CTRL+S to save the configuration. Then close the table Design View.

• Double-click on tblFriends now.

• Encode at least 10 rows of data to your new table.

• Congratulations, you have a new table with data in it.

 

– glenoid

Setting Up Connection between MS Access and Netbeans

This is the Java version for managing the same database used in Visual Studio for VB.Net. Follow the procedures to properly compile and run the program.

1. Click here to download rs2xml.jar.
2. Click here for the complete instructions.

– glenoid

Setting Up Connection Between MS Access and Netbeans (for Mint and Debian)

Follow the following procedures carefully. In order to make a connection, you will download the following file first.

1. Click to download ucanaccess files here.
   1. Extract the zip file.
   2. Copy ucanaccess-3.0.1.jar
   3. Copy from lib folder commons-lang-2.6.jar, commons-logging-1.1.1.jar, hsqldb.jar, jackcess-2.1.2.jar
   4. Paste all 5 jar files to C:\Program Files\Java\jdk1.8.0_40\jre\lib\ext
2. Create a new Project named Basic Databasing. Then a new jFrame named SampleConnector.java.
3. Create or download your previous Access Database files from your sent email or you can recreate a new one.
4. Make sure your Access file is saved inside your Basic Databasing folder.
5. Code the connection.

– glenoid

Comeback Sample for Java (Mint) – August 25, 2015

Project Name: ProgressLoader
Class Name for Frame 1: ProgressPage

Instruction 1: Create 2 forms (ProgressPage.java & mainMenu.java).

Instruction 2: Put the imports for timer and timertask. Then type the loader function to run the progress bar.

Instruction 3: Right-click ProgressPage and have the windowopened event coded.

– glenoid

C++ Comeback Sample (for Jellybean & Froyo) – August 24, 2015

Save this sample as multiple-if.cpp…

– glenoid

The 1987 Constitution (for July 6 Froyo & July 7 Jellybean)

Look up for a source online for The 1987 Constitution of the Republic of the Philippines. Format it in Word (until Article 5 only) as dictated during class briefing. Send your Word document via email with the subject, The Constitution.

Here’s a sample:

– glenoid