Search Tutorials

About 104 results found.

1.Advanced Formatting and Protection

Foss : LibreOffice Suite Calc - English

Advanced Formatting and Protection Password protect a spreadsheet Password protect a single sheet Define Ranges for a database Use the Subtotal option Validate cells Database range Protect S..

Intermediate

2.Basic Data Manipulation

Foss : LibreOffice Suite Calc - English

Basic Data Manipulation Introduction to basics of Formula Sorting by Columns Basics of Filtering Data is equal to SUM Sort data AutoFilter Sorting in Descending order Sorting in Ascending orde..

Basic

3.Formatting Data

Foss : LibreOffice Suite Calc - English

Formatting Data Learn about Formatting borders Learn about background colors Formatting multiple lines Automatic Wrapping Merging Cell Shrinking text to fit the cell Merge cell

Basic

4.Modify a simple form

Foss : LibreOffice Suite Base - English

Modify a simple form How to Traverse the records Adding a new record in a form How to Modify a form Ungroup the labels and text boxes Adding a tool tip to the Title text-box.

Basic

5.Enter and update data in a form

Foss : LibreOffice Suite Base - English

Enter and update data in a form Decreasing the height and length of form window Changing the font of the heading of form. Activation order Tab Order of the form controls.

Basic

6.Indexes Table Filter SQL Command window

Foss : LibreOffice Suite Base - English

Indexes Table Filter SQL Command window How to open index window Firing query of mysql insert,update,delete Firing query of mysql create table,drop table and alter statements

Advanced

7.Modify a Report

Foss : LibreOffice Suite Base - English

Modify a report by customizing the layout Look and feel of the report. Insert Report Header/Footer Use the Text Labels in different styles Use the font size How to use the background colour Use ..

Basic

8.Design Refine Database Design and Normalization Rules

Foss : LibreOffice Suite Base - English

Refine the database design Apply the normalization rules First Normal Form Second Normal Form Third Normal Form Test the database design

Advanced

9.Create tables

Foss : LibreOffice Suite Base - English

Create view Create a table by copying an existing table. Using copy method How to do the sorting Rename the table

Intermediate

10.Database Design Primary Key and Relationships

Foss : LibreOffice Suite Base - English

Turn information items into columns What is primary keys ? How to setup Primary keys What is Foreign Keys Set up the table relationships - One-to-One Relationship - One-to-Many Relationship ..

Advanced

11.Database Design Purpose OrganizeTables

Foss : LibreOffice Suite Base - English

What is Database Design Process of database design Dividing the information into tables. Determining the purpose of our database Finding and organizing the information required Dividing the inf..

Advanced

12.Database Maintenance

Foss : LibreOffice Suite Base - English

Modify data structures. Database Maintenance De-fragment database. CHECKPOINT DEFRAG SHUTDOWN COMPACT. Backups How to take Backups

Advanced

13.Create Subforms

Foss : LibreOffice Suite Base - English

Create Subforms How to Create a Subform Change the size of font and style Change the background colour

Intermediate

14.Create queries using Design View

Foss : LibreOffice Suite Base - English

Create a query by using the Design View Add tables to the Query Design window Select fields Set up aliases, Set up sorting order Set up visibility of the fields Provide search criteria Firing Q..

Basic

15.Create queries using Query Wizard

Foss : LibreOffice Suite Base - English

What is Query Create simple queries using the Query wizard Select fields Set the sorting order of the fields Provide search criteria or conditions for a query Setting aliases (friendly and desc..

Basic

16.Create reports

Foss : LibreOffice Suite Base - English

Create a Report Select, Label and Sort the report fields Select report layout choose report type: static or dynamic Find Selection Labelling fields Grouping Sorting options Choose Layout

Basic

17.Create simple queries in SQL View

Foss : LibreOffice Suite Base - English

About SQL Create Simple Queries in SQL View, HSQL Tips and Notes Write simple SQL Use SELECT, FROM , and WHERE clauses Choose upper, lower, or mixed cases for naming fields and tables

Intermediate

18.Create simple queries in SQL View II

Foss : LibreOffice Suite Base - English

Create simple queries in SQL View II Write Queries in SQL View Use ORDER BY clause Use JOINS Use Aggregate functions Use the GROUP BY clause Use b..

Intermediate

19.Using search replace auto correct

Foss : LibreOffice Suite Writer - English

Using search replace auto correct Find,Search,replace for select text Auto-correct feature Spell check Language Settings

Intermediate

20.Using track changes

Foss : LibreOffice Suite Writer - English

Using track changes as a peer review / collaborative constructivist tool, accepting and rejecting changes How to use record changes to peer review documents, accept/reject these

Advanced