Create and Use a Query, Form, Report & Printing a document from access

A query is a database object that retrieves specific data from one or more tables and then, in a single datasheet, displays only the data you specified. Because the word query means to ask a question, you can think of a query as a question formed in a manner that access can interpret.

A form is an Access object with which you can enter data, edit data, or display data from a table or a query. Thinks of a form as a window through which you and others can view and work with the data.

A database table is similar in structure to a worksheet, in that data is stored in rows and columns. As a result, it is usually easy to import a worksheet into a database table. The main difference between storing your data in a worksheet and storing it in a database is in how the data is organized. Simply importing your entire worksheet as a new table in a database will not solve the problems associated with organizing and updating your data, particularly if your worksheet contains redundant data. To solve those problems, you must split the spreadsheet data into separate tables, each one containing related data. For more information about how to arrange the data in your tables, see the article Database design basics.

Access features the Table Analyzer Wizard, which can help you to complete this process. After importing your data into a table, the wizard helps you to split the table into separate tables, each of which contains data that is not duplicated in any of the other tables. The wizard also creates the necessary relationships between the tables. For more information about relationships, see the section Relationships in a database in this article. 

Jamb exam information

The JAMB exam begins on 14th March. We will let you know once printing of exam slips

Make use of Jamb CAPS for Admission, Jamb tells institutions

The Central Admissions Processing System (CAPS) is an automated platform
for all institutions to conduct their admissions. This system engenders
transparency, accountability and inclusiveness devoid of human
interference. Institutions are the major actors with the sole authority to
recommend candidates for admission while the board supervises by ensuring
that all candidates are fairly, equitably and transparently treated....


For candidates who participated in last year's admission exercise, you can
find official procedures used to check if you have now been offered
admission.

Lean how to cartoon yourself with Coreldraw

WHAT IS MICROSOFT ACCESS

Mandavo student 

Microsoft Access is a database application design and deployment tool that you can use to keep track of important information. You can keep your data on your computer, or you can publish to the Web — so others can use your database with a web browser.

Access is a tool that you can use to quickly and easily develop relational database applications that help you manage information.

You can create a database to help you keep track of any kind of information, such as inventory, professional contacts, or business processes.

NYSC REGISTRATION CLOSES SOON

National Youth Service Corps set to close it batch A 2020 registration on 2nd of March, 2020. for your registration locate us at 42, Ojora Street, Ajegunle Apapa Lagos. don't be cut in fake registration center. Call 08086135961

1,949,983 Candidates to Write 2020 UTME

The exact figure of 1,949,983 candidates have registered to write the 2020 UTME, which begins from 14th March. Also, the exact figure of 160,640 candidates applied for Direct Entry. This final report is coming as JAMB
closed registration for the 2020 UTME on 17th February. Everyone is now focused on the main exam, following the successful conduct of the mock exams on 18th February, where 155,156 candidates participated in.

CONTROL UNIT

This unit controls the operations of all parts of the computer but does not carry out any actual data processing operations.

Functions of this unit are −

·        It is responsible for controlling the transfer of data and instructions among other units of a computer.

·        It manages and coordinates all the units of the computer.

·        It obtains the instructions from the memory, interprets them, and directs the operation of the computer.

·        It communicates with Input/output devices for transfer of data or results from storage.

·        It does not process or store data.

COMPUTER - GENERATIONS

Generation in computer terminology is a change in technology a computer is/was being used. Initially, the generation term was used to distinguish between varying hardware technologies. Nowadays, generation includes both hardware and software, which together make up an entire computer system.

There are five computer generations known till date. In the following table, an approximate date against each generation has been mentioned, which are normally accepted.

Following are the main five generations of computers.

First Generation: The period of first generation: 1946-1959. Vacuum tube based. language are done in machine languages e.g. 010101

Second Generation The period of second generation: 1959-1965. Transistor based. Programming are done in symbolic language. E.g. * # @! > < : “ ‘ ? / $

Third Generation: The period of third generation: 1965-1971. Integrated Circuit based. High Level Language. 

Fourth Generation: The period of fourth generation: 1971-1980. VLSI microprocessor based.

Fifth Generation The period of fifth generation: 1980-onwards. VLSI microprocessor based. read more

Why do we need spreadsheet for payroll management system?

         1.   We need spreadsheet for proper recording

         2.    To eliminate Ghost worker

        3.    To have accurate data on how much being               spend on payment of worker

        4.       It help to plan worker welfare

        5.       It bring transparency in the accounting                   system Learn More

Discuss the importance of spreadsheet and database to educational system in Nigeria

Spreadsheet and Database

Spreadsheet and Database is very vital in today world, were data is growing every day. Spreadsheet and Database is highly important in our educational system for the keeping and storing of Data, student record, Staff record, Academic and Non Academic Staff need to properly document there Data.

Our educational system is one of the largest employer of labor, there is need to capture every staff electronically which we reduce paper work, and bureaucracy in implementation of policy and staff welfare , the use of spreadsheet and database we help in reducing poverty which have eating deep into the fabric of our nation.

Spreadsheet and database is so important for planning and budgeting in the education sector

Write out the steps involved in the following A to close a spreadsheet

Steps to Close a Spreadsheet

Click on File

Click on Close

Ctrl + W is use to close a Worksheet

Alt + F4 is used to close the entire Work Book

Jamb Reprint & Exam Info

Jamb reprint commence 11th to 13th of March 2020.

2020 computer-based test examination will begin on Saturday, March 14 and end on April 4.

What is Excel?

What is Excel?

Excel is a spreadsheet program in the Microsoft Office system. You can use Excel to create and format workbooks (a collection of spreadsheets) in order to analyze data and make more informed business decisions.

USES OF EXCEL

You can use                                        

ü    Excel to track data

ü    build models for analyzing data

ü    write formulas to perform calculations on that data

ü    pivot the data in numerous ways

ü    and present data in a variety of professional looking chart

COMMON SCENARIOS FOR USING EXCEL INCLUDE:

Accounting You can use the powerful calculation features of Excel in many financial accounting statements—for example, a cash flow statement, income statement, or profit and loss statement.

Budgeting  Whether your needs are personal or business related, you can create any type of budget in Excel—for example, a marketing budget plan, an event budget, or a retirement budget.

Billing and sales  Excel is also useful for managing billing and sales data, and you can easily create the forms that you need—for example, sales invoices, packing slips, or purchase orders.

Reporting You can create various types of reports in Excel that reflect your data analysis or summarize your data—for example, reports that measure project performance, show variance between projected and actual results, or reports that you can use to forecast data.

                                                                                                                                                       

Planning Excel is a great tool for creating professional plans or useful planners—for example, a weekly class plan, a marketing research plan, a year-end tax plan, or planners that help you organize weekly meals, parties, or vacations.

Tracking You can use Excel to keep track of data in a time sheet or list—for example, a time sheet for tracking work, or an inventory list that keeps track of equipment.

Using calendars   Because of its grid-like workspace, Excel lends itself well to creating any type of calendar—for example, an academic calendar to keep track of activities during the school year, or a fiscal year calendar to track business events and milestones. 

With the use of a word processing package write short notes on the five generation of programming language

With the use of a word processing package write short notes on the five generation of programming language

Use of a word processing package

• Word Processing Package such as Microsoft Word can be use to Creating, editing, saving and printing
• Letters
• Resume
• Cover Letters
• Brochures
• Reports
• Calendars
• Certificate
• Invoices
• Receipts
• Newsletters
• Copying
• Pasting
• moving and deleting text within a document.
• Formatting text, such as font type, bolding, underlining or italicizing.
• Creating and editing tables.
• Inserting elements from other software, such as illustrations or photographs.
• Correcting spelling and grammar.
• Creating, Editing and formatting Table

Write what you know about how word processor is different from the text editor and desktop publishing system with practical examples

WORD PROCESSOR & TEXT EDITOR

A word processor is an application or a device that allows users to create, edit, and print documents. It enables you to write text, store it electronically, display it on a screen, modify it by entering commands and characters from the keyboard, and print it. Examples of Word Processor Package is MICROSOFT OFFICE

A TEXT EDITOR is a type of computer program that edits plain text. Such programs are sometimes known as "NOTEPAD"

EXAMPLE OF TEXT EDITOR IS NOTEPAD OR WORD PAD

Name and explain the various windows in Microsoft Word application package

1. Window XP

2. window Vista 

3. Window 7

4. Window 8

5. Window 8.1

6. Window 10

Microsoft created the Windows operating system in the mid-1980s. Over the years, there have been many different versions of Windows, but the most popular ones are Windows 7 (released in 2009), Windows Vista (2007), and Windows XP (2001). Windows comes preloaded on most new PCs, which helps to make it the most popular operating system in the world.

If you're buying a new computer or upgrading to a new version of Windows, you can choose from several different editions of Windows, including Home Premium, Professional, and Ultimate. For most users, Home Premium offers enough features, but many people choose one of the more expensive editions.

List 5 features of spreadsheet

Spreadsheet Features  

1. Row: these run from left to right across the window and their position is designated by a number
2. Columns: Columns run from top to bottom to the windw and f course their position is designed by a letter.
3. Cells: Cells are formed by the intersection of row and column. Each cell in the spreadsheet is identified by cell referred to as cell address. 
4. Value: A value or number is a piece of data that can be used in a calculation 
5. Formula: This is an instruction that tells the computer to work out the answer for the values entered. A formula is like a mathematical equation. All formulae in Excel must start with an equal sign (=) 

How to send documents from browser on phone to PC?

You can send the documents on your phone to the computer in different way in this article I’m going to show you three ways

Using Your Bluetooth

If you are you a PC with Bluetooth enable

Select the document from your phone, click on send via Bluetooth

On your PC click on the Bluetooth, click on Received file.

Using Xender

1.   Open the Xender app on your phone

2.   Click on Connect PC

3.   Click on Hot Spot

4.   Click on Create Hotspot

5.   On your PC click on your wifi  

6.   Click on Xender_Apa285 this may varies from yours

7.   Open your browser

8.   Enter the following web address:

9.   192.168.43.1:33455

10. Enter

11. It will prompt you to click ACCEPT ON YOUR PHONE

You can use Cable

Connect your phone with a USB cable to your PC

Click on my computer or This PC

Your pone will appear

Click on it and fine your document

How to check transfer approval on jamb caps on phone using Chrome browser?

How to check transfer approval on jamb caps on phone using Chrome browser?

For you to transfer approval on Jamb caps through your phone

1.   Open your browser either google chrome or any other

2.   On your url types this or Click on https://www.jamb.org.ng/eFacility

3.   Login with your user name and password

4.   The jamb page will load

5.   Click on admission stutus

6.     A dialog box with pop up for you to choose between

7.   Click on Access my Cap

8.   Rotate your phone to landscape

9.   By your left side you will find the transfer approval

1. http://caps.jamb.gov.ng/  

What are the resources that are needed to improve efficiency in word processing?

If you are willing to improve your word processing skills, there are few things to do

1. Google online to search for materials on word processing 
2. Go to YouTube and type word processing tutorial 
3. you can get a text book 
4. But the most effective way is to enroll in computer training school 

5. You can get a personal instructor on word processing  
let improve your word processing skills today

What are the reasons for studying typing and word processing in the higher institution?

Typing and word processing go hand in hand, due to the information age we are today is a great thing to have the knowledge of typing and word processing.

Reasons for studying typing and word processing in the higher institution

1. It enable you to use the right fingering 
2. It makes you a fast typist
3. You don't have to look the keyboard when typing
4. You can create great works with word processing 
5. It make you smart
6. It pave way for you to a good job  

A+

Get our three in one package at a discount price today. Computer technician is highly sought after skills in today world. Enrol with us today

Explain the term spreadsheet and state any four applications on it

Spreadsheet has been in existence for a very long time. Originally, it has been seen  as a program that emulated an accountant’s spreadsheet.

Spreadsheet is a grid of rows and columns that display all the number data for a business or other organization on a sheet of paper.

Electronic spreadsheet may be defined as a program which organizes information into row and columns so that it can be operated on easily.

Applications under spreadsheet

1.    Excel

2.    Lotus 123

3.    Stat View

4.    Quarto Pro etc.

Google up other uses of spreadsheet package and explain them

The spreadsheet packages are used to do the following

 

1. Preparation of daily sales

2. Budget 

3. Examination results

4. It can be used in any job that involves reetitive numerical calculation 

5. It is used to generate and analyze data

6. To analyze mathematical and statistical operations

7. It used for effective and efficient data presentation 

8. It is used to generate inventory report  

Is address bar a terminology in spreadsheet?

Address bar is not a terminology in spreadsheet

List 5 features of spreadsheet

Spreadsheet Features  


1. Row: these run from left to right across the window and their position is designated by a number
2. Columns: Columns run from top to bottom to the window and f course their position is designed by a letter.
3. Cells: Cells are formed by the intersection of row and column. Each cell in the spreadsheet is identified by cell referred to as cell address. 
4. Value: A value or number is a piece of data that can be used in a calculation 
5. Formula: This is an instruction that tells the computer to work out the answer for the values entered. A formula is like a mathematical equation. All formulae in Excel must start with an equal sign (=) 

Name and explain the various windows in Microsoft Word application package

1. Window XP

2. window Vista 

3. Window 7

4. Window 8

5. Window 8.1

6. Window 10

Microsoft created the Windows operating system in the mid-1980s. Over the years, there have been many different versions of Windows, but the most popular ones are Windows 7 (released in 2009), Windows Vista (2007), and Windows XP (2001). Windows comes preloaded on most new PCs, which helps to make it the most popular operating system in the world.

If you're buying a new computer or upgrading to a new version of Windows, you can choose from several different editions of Windows, including Home Premium, Professional, and Ultimate. For most users, Home Premium offers enough features, but many people choose one of the more expensive editions.

WEB DEVELOPMENT & GRAPHIC DESIGN

Become a professional Web developer & graphic designer, create great illustrators, cartoons @ affordable prices #Mandavo #computer #creative #computernear #computertraing #computerschooln Ajegunle #illustration #illustrator #cartoon #avengers #avengersendgame #christianoronaldo #football #cronaldo7