Back to Course

JSS3: COMPUTER STUDIES - 1ST TERM

0% Complete
0/0 Steps
  1. Computer Career Opportunities | Week 1
    5 Topics
    |
    1 Quiz
  2. Computer Viruses I | Week 2
    7 Topics
    |
    1 Quiz
  3. Computer Viruses II | Week 3
    7 Topics
    |
    1 Quiz
  4. Introduction To The Internet | Week 4
    4 Topics
    |
    1 Quiz
  5. Internet Terminologies | Week 5
    4 Topics
    |
    1 Quiz
  6. The Concept of Digital Divide | Week 6
    5 Topics
    |
    1 Quiz
  7. Database Concept, Definition And Terminologies | Week 7
    4 Topics
    |
    1 Quiz
  8. Database II | Week 8
    3 Topics
    |
    1 Quiz
  9. Database III | Week 9
    13 Topics
    |
    1 Quiz



Lesson Progress
0% Complete

Tables: In Access, data are stored in tables. A table is a set of columns and rows, with each column referred to as a field. Each value in a field represents a single type of data. Each row of a table is referred to as a record.

Queries: You use queries to retrieve specific data from your database and to answer questions about your data. For example, you can use a query to find the names of the employees in your Database who live in a particular state.

Forms: Forms give you the ability to choose the format and arrangement of fields. You can use a form to enter, edit, and display data.

Reports: Reports organize or summarize your data so you can print it or view it on screen. You often use reports when you want to analyze your data or present your data to others.

Macros: Macros give you the ability to automate tasks. You can use a macro to add functionality to a form, report, or control.

Modules: Like macros, modules give you the ability to automate tasks and add functionality to a form, report, or control. Macros are created by choosing from a list of macro actions, whereas modules are written in Visual Basic for Applications.

You double-click an object to open the object. You right-click an object to view a menu of options. You can use the menu to do such things as open objects, rename objects, and delete objects. Objects that are open appear on tabs. Right‐click a tab to view a menu of options you can perform, such as save the object, close the object, or change the view.

Changing Views

Screen Shot 2021 03 17 at 6.23.04 PM

A view is a way of looking at an object. For example, in Access, data is stored in tables. Two of the possible ways you can view a table are Datasheet view and Design view. You can see the data contained in a table in Datasheet view. You can see the design of a table in Design view.

When you open an object, buttons appear in the lower–‐right corner of the Access window.

You can use the View button on the Home tab to change views, or you can click the proper button in the lower-right corner of the window.

Responses

Your email address will not be published. Required fields are marked *

error: Alert: Content selection is disabled!!