FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -In general, Access is better for managing data: helping you keep it organized, easy to search, and available to multiple simultaneous users. Excel is generally better for analyzing data: performing complex calculations, exploring possible outcomes, and producing high quality charts.

Detailed explanation-2: -On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. A new document tab appears, containing a design grid and a window in which you can select a field on which to sort. In the window, double-click the field that you want to use to sort.

Detailed explanation-3: -In Microsoft Access, data is stored in tables. In simple terms, tables are mini-spreadsheets, which store only one kind of thing. A table can contain numerous fields, which are similar to columns in the spreadsheet. Every field in a table can be easily set up to prevent or allow users from entering some information.

Detailed explanation-4: -Let Excel learn your patterns, organize your data, and save you time. Easily create spreadsheets from templates or on your own and use modern formulas to perform calculations.

Detailed explanation-5: -The SORT function sorts the contents of a range or array.