WorksheetsINTE 20013_Integrated Software Application
Total questions: 20
Worksheet time: 15mins
MS Word
Holds all of the information in previous versions of Microsoft Office in a more visual stream line manner through a series of tabs that include an immense variety of program features.
(a)
This tab has commands to adjust page elements such as margins, orientation, inserting columns, page backgrounds and themes.
(a)
This is the most used tab; it incorporates all text formatting features such as font and paragraph changes.
(a)
This tab allows you to insert a variety of items into a document from pictures, clip art, tables and headers and footers.
(a)
This tab allows you to change the view of your document to a different two page document or zoom.
(a)
MS Access
This tab holds an immense function library which can assist when creating any formula or function in your spreadsheet.
(a)
This tab allows you to modifying worksheets with large amounts of data by sorting and filtering as well as analyzing and grouping data.
(a)
This tab allows you to correct spelling and grammar issues as well as set up security protections. It also provides the track changes and notes feature providing the ability to make notes and changes someone’s document.
(a)
In Excel, the format of a cell is separate from the data that is stored in the cell. This display difference can have a significant effect when the data is numeric.
(a)
By using predefined border styles, you can quickly add a border around cells or ranges of cells. If predefined cell borders do not meet your needs, you can create a custom border.
(a)
MS PowerPoint
Click the ____ button in the Quick Access Toolbar – we recommend using this button often
New
Save
Open
Click ____, Choose type of Presentation then click Create.
Open
Save
New
Save a duplicate of the file with a new name
New
Save As
Open
Preview appears on the right side of the screen
Close
Print Preview
New
If you want to exit PowerPoint, you can click the x in the top right corner.
Close
Open
New
MS Access
Queries are questions you ask of your database. They allow you to select certain fields out of a table, or pull together data from various related tables and display it together.
Notes on Query Results
Understanding Queries
Sort query results
In Design View, click the Sort row in the column you wish to sort by. A dropdown arrow appears; choose Ascending or Descending. If you sort by more than one column, the sorts will be done left-to-right.
Notes on Query Results
Create a concatenated field in a query
Sort query results
If a query contains fields from two or more related tables, the results will only include records that have related records in all the tables.
Notes on Query Results
Sort query results
Create a concatenated field in a query
You can type criteria in more than one field.
Create a parameter query
Using Multiple Criteria
Criteria Ranges
Criteria ranges broaden and customize a search.
Criteria Ranges
Using Multiple Criteria
Create a parameter query
