Computer - 4th Quarter

• Database - data structure that stores and organizes information, container for data
• Microsoft Access - database creating and management tool from Microsoft
• Ribbon - multiple tabs with several groups of commands
• Quick Access Tool Bar - located above the ribbon, lets the user access common commands
• Backstage View - gives various options for opening, saving, printing, and viewing more information about a database
• Objects -used to help the user list and organize information
• Tables - holds and organizes information and data, composed of rows and columns (cells)
• Field - organizing information by type
• Record - One unit of information
• Creating a Database

  1. From the Microsoft Access 2016 welcome screen, click blank desktop database.
  2. Enter a name for the database and choose a path where to save the database then click create.
  3. A blank database is now created and active. The database is now ready to be configured.
• Query - allows the user to request for data results and for action on data
• Forms - allow the user to enter the right data at the right location and format
• Design View - provides more detailed vision of the form’s structure, allows modification of the form without displaying any data from the table
• Form View - where the user can use the form, enables the user to test all the controls and properties in the form
• Layout View - provides a more visual layout for editing the form
• Creating a Form

  1. In the Navigation Pane, select the table you want to use for the form
  2. In Create tab, Forms group, click the Form command
• Saving a Form

  1. Click the Save command on the Quick Access Tool Bar. You can save your created form in File -> Save, or simply pressing Ctrl + S on the keyboard.
  2. Save As dialog box will appear, type a name for the form, then click OK.
• Saving Data - when the user binds a data from the DataGridView control in a database, all the changes made to the DataGridView control are not automatically updated on the database
• In Saving Data, it is important to use an Update () method.
• Dataset - in-memory copy of data
• Three Ways on How to Save Data:

  1. Update
  2. DBDirect
  3. UpdateAll
• Saving Data

  
  

  Private Sub Button4_Click(By Val sender As System. Object,

  By Val e As System.EventArgs) Handles Button4.Click

  'save data

  Me. Validate()

  Me.Table1BindingSource. EndEdit()

  Me .Table1AdapterManager.UpdateAll(Me.Database1DataSet)

  rs. Update()

  End Sub
• Editing Data - to edit an existing row in a DataTable, it is important to locate the DataRow that needs to be edited
• 1. Assign a specific DataRow to a variable using the generated FindBy method
• Select method - to located a specific row and assign new values to the desired columns
• Editing Data

  
  

  Private Sub Button2_Click(By Val sender As System. Object,

  By Val e As System.EventArgs) Handles Button2.Click

  'edit data Me.Table1BindingSource.EndEdit ()

  rs. Update()

  End Sub
• Deleting Data - to programmatically delete a row in the Data GridView control, the user can use the Remove () method.
• To delete data using the keyboard, the user can press the Delete key.
• By default, the deletion is done automatically without any prompting.
• Deleting Data

  
  

  Private Sub Button3 _Click(By Val sender As System. Object,

  By Val e As System.EventArgs) Handles Button3.Click

  'delete data

  If MessageBox .Show("'Are you sure?", "Delete Record", MessageBoxButtons.YesNo,

  MessageBoxIcon.Question, MessageBoxDefaultButton.Button1) - =Windows.Forms.DialogResult.Yes Then

  connectDB()

  Me.Table1BindingSource. Remove Current()

  End If

  rs.Update()

  End Sub