CCNC/CCNC Module 5/The database application/Adjusting the application settings

From WikiEducator
Jump to: navigation, search
Tutorial.png Adjusting Settings 

View Settings | Toolbar Settings | Self Assessment | Summary & FAQs


Changing the view

Icon objectives.jpg

Outcomes

Upon completion of this tutorial the learner will be able to:
  • Describe the Tables view and the related activities
  • Describe the Forms view and the related activities
  • Describe the Queries view and the related activities
  • Describe the Reports view and the related activities


Working in Table View

Figure 1. Table View

In "Tables" view you can create a new table from nothing or use a wizard to prompt you design decisions. You can also create a view that allows you to put "filters" on existing tables.

Working in Forms View

Figure 2. Forms View

In "Forms" view you can create forms for data entry and viewing. You can also use a wizard to guide you through the process of creating a form.

Working in Queries View

Figure 3. Queries View

In "Queries" view you can create queries that filter data, join together tables and specify which fileds are to be displayed and specify the properties for sorting the data.

You can also use a wizard to guide you through the process of creating a query.

And if you feel comfortable using the Structured Query Language (SQL) you can create your queries by hand using only SQL syntax.


Working in Reports View

Figure 4. Reports View

In "Reports" view you will be guided by a wizard to create new views or you can select existing views to edit, delete or run.

Test your knowledge



Icon qmark.gif

Open Office Base Views

 

1. Open Office has five views within to work?

TRUE
Incorrect, click here to review the topic.. Open Office Base has four views.
FALSE
Absolutely Correct!

2. A form is used for data entry?

TRUE
Absolutely Correct!
FALSE
Incorrect, click here to review the topic.. A form is used for data entry.

3. In which view would you enter SQL Syntax?

(a) The Table view
Incorrect, click here to review the topic.
(b) The Form view
Incorrect, click here to review the topic.
(c) The Query view
Absolutely correct!
(d) The Report view
Incorrect, click here to review the topic.
(e) None of the above
Incorrect, click here to review the topic.

Your score is 0 / 0