Page 44 - ModularV1.1 _c8_flipbook
P. 44
Recap
The Totals command allows you to perform different types of calculations like sum,
average, maximum, minimum, standard deviation and covariance.
MS Access allows you to search a particular record in a table easily by using the Find
command.
Sorting is the process of arranging data alphabetically either in ascending or descending
order.
Filtering means to select specific data from the given set of data.
Importing data means to access the data from other applications like MS Excel to
MS Access.
Exporting data means to save an MS Access table data into different formats like PDF or
spreadsheet.
Exercise
A. Tick ( ) the correct option.
ü
1. Which of the following command is used to perform calculation in MS Access?
a. Totals b. Filter c. Sort
2. Which of the following command is used to find a record in a table?
a. Replace b. Sort c. Find
3. Which of the following is not a sorting option?
a. Sort A to Z b. Sort A to B c. Sort Z to A
4. Which of the following tab is used to import data from other applications to MS Access?
a. External Data b. Database Tools c. Fields
5. Which of the following group of the External Data tab is used to export data from
MS Access table?
a. Sort & Filter b. Import & Link c. Export
B. Fill in the blanks using the words given below.
excel, find, PDF or XPS, sorting
1. ................................ is the process of arranging data alphabetically either in ascending or descending
order.
2. The ................................ command is used to import data from an MS Excel file.
3. The Find command is present under the ................................ group of the Home tab.
4. The ................................ command is used to export the data in PDF form.
42 Modular (Ver. 1.1)-VIII

