Home

Unit 10

Student Learning Outcomes:

1. Define the terms field, record, table, relational database, primary key, and foreign key
2. Open an existing database
3. Identify the components of the Access and Database windows
4. Open and navigate a table
5. Learn how Access saves a database
6. Open an existing query, and create, sort, and navigate a new query
7. Create and navigate a form
8. Create, preview, and navigate a report
9. Learn how to manage a database by backing up, restoring, compacting, and converting a database.

Important Points.

1. Access must be opened first then open the database file. If you click on the database file first (docucentric approach) the database file will open but a number of the wizards will be disabled in Access making it impossible to complete your assignments.
2. When you enter data into a record and proceed to the next record the data is automatically saved to disk.
3. When you save the database, the structure of the database is being saved.
4. When you compact the database, records that have been marked for deletion are removed from the database.
5. A field is a single characteristic or attribute of a person, place, object, event, or idea.
6. A table is a collection of fields that describe a person, place, object, event, or idea.
7. The specific value of a field is called the field value.
8. A collection of related tables is called a relational database.
9. A relationship can be established between tables that have a common field that is of the same data type.
10. A primary key is a field, or a collection of fields, whose values are unique for every record in a table, cannot be null and is the first index of the table. These are the entity integrity restraints of a primary key.
11. When you join the primary key from one table to a common field in another table, the common field in the related table is called a foreign key.
12. A Database Management System (DBMS) is a software program that lets you create databases and then manipulate data in them.
13. A query is a question you ask about the data stored in a database. There are two types of queries. Select queries in which data is selected based on the contents of the fields and do not change the contents of the table. Action queries which change the the contents of the table in some way.
14. When a query is saved the Sequential Query Language (SQL) is saved not the dynamic data set created by the query.
15. A form is a graphic user interface into the table.
16. A Form Wizard is an Access tool that asks you a series of questions, and then creates a form based on your answers.
17. A report is a formatted printout (or screen display) of one or more tables in a database.
18. Compacting a database rearranges the data and objects in a database to decrease its file size.
 

Best Practice:

1. Make a backup copy of your database on a daily basic while you are working on it.
a. Right Click on Start button.
b. Select explorer from the pop up menu.
c. Select the drive/folder where your database file is located.
d. Right Click the database file and select copy from the pop up menu.
e. Select the drive/folder where you want to place the copy of your database file.
f. Right click on the drive/folder and select paste from the pop up menu.

Unit 11

The student learning outcomes:

1. Learn the guidelines for designing databases and setting field properties
2. Create a new database
3. Create and save a table
4. Define fields and specify a table's primary key
5. Add records to a table
6. Modify the structure of a table
7. Delete, move, and add fields
8. Change field properties and update
9. Copy records and import tables from another Access database
10. Delete and change records

Important Points.
1. Rules of Data Normalization: 1st Rule - Eliminate Repeating Groups - Make a separate table for each set of related attributes(fields), and give each table a primary key.
2. When creating a database the first question to ask is what is the output going to be.
3. Identify all of the fields needed to produce the required information.
4. Group related fields into tables.
5. Determine each table's primary key.
6. When more than one field is used as a primary key it is called a composite key.
7. Include a common field in related tables.
8. Avoid data redundancy.
9. Rules for naming fields.

a. A name can be up to 64 characters.
b. A name can contain letters, numbers, spaces, and special characters.
c. A name cannot start with a space.
d. A table or query name must be unique with a database. A field name must be unique with a table, but can be used in other tables.
e. Capitalize the first letter of each word in the name.
f. Avoid extremely long names.
g. Use standard abbreviations.
h. Do not use spaces in field names or object names.

10. The data type determines what field value you can enter for the field and what other properties the field will have.
11. The Field Size property defines a field value's maximum storage size for test, number, and AutoNumber field only.

 

Table 1
Access Field Types

 

Field Types
Auto Number A number that is assigned automatically and never changes again.
Currency Dollar amounts
Date/Time Dates and times
Hyper Link Hyper Link address HTTP, FTP, E-mail, .doc, .etc..
Lookup Values that come from another table, a query, or a list of values you supply.
Memo Can contain numbers or letters up to 64,000 including spaces
Number Byte , Integer, Long Integer, Single precision, Double precision. Decimal,Replication ID.
OLE - object Picture, sound, or video
Text Can contain numbers or characters up to 255 bytes including spaces.
Yes/NO Can contain Boolean values (yes/no, true/false, on/off) Can contain only one of two values

12. The structure of the table can be modified at any time. Fields can be added, deleted, and properties changed.
13. You can copy and paste records from a table in the same database or in a different database only if the tables have the same structure.
14. When you import a table from one Access database to another, you place a copy of the table in the database into which you import it.
15. Updating, or maintaining, a database is the process of adding, changing, and deleting records in database tables.

 

Best Practice: When setting up a database in a company, make sure that you discuss the project with everyone who will be using the database. The executive director will request different data then will one of his subordinates. The key person is the data input clerk. Data integrity must be insured and the data input clerk is the one putting the data into the program. If they are unclear as to their data entry requirements data error will be the rule.
 

Unit 12

The student learning outcomes:


1. Learn how to use the Query window in Design view
2. Create, run, and save queries
3. Update data using a query
4. Define a relationship between two tables
5. Sort data in a query
6. Filter data in a query
7. Specify an exact match condition in a query
8. Change a datasheet's appearance
9. Use a comparison operator to match a range of values
10, Use the And and Or logical operators
11. Use multiple undo and redo
12. Perform calculations in a query using calculated fields, aggregate functions, and record group calculations

Important Points.
1. There are two types of Queries: Select Queries and Action Queries
2. Rules of Data Normalization - 2sd Rule - Eliminate Redundant Data - If an attribute (field) depends on only part of a multivalued key, remove it to a separate table.
3. When you use query by example (QBE), you give Access an example of the information you are requesting.
4. The field list contains the fields for the table you are querying.
5. In the design grid, you include the fields and record selection criteria for the information you want to see.
6. The process of relating table is often called performing a join.
7. A one-to-many relationship
exists between two tables when one record in the first table matches zero, one, or many records in the second table, and one record in the second table matches exactly one record in the first table.
8. The primary table is the "one" table in a one to many relationship.
9. The related table is the "many" table.
10. Referential integrity rules:

a. When you add a record to a related table, a matching record must already exist in the primary table.
b. If you attempt to change the value of the primary key in the primary table, Access prevents this change if matching records exist in a related table.
c. Cascade update permits the change in value to the primary key and changes the appropriate foreign key values in the related table.
d. Cascade deletes - deletes the record in the primary table and also deletes all records in the related tables that have matching foreign key values.

11. The Relationship Window is used to define relationships (create joins) between tables.
12. Sorting is the process of rearranging records in a specified order or sequence.
13. The sort key is the field used to determine the order of records in the datasheet.
14. Ascending Sort - A to Z, Lowest to Highest.
15. Descending Sort - Z to A, Highest to Lowest
16. A sort key is unique if the value of the sort key for each record is different.
17. A sort key is nonunique if more than one record can have the same value for the sort key field.
18. A filter is a set of restrictions you place on the records in an open datasheet or form to temporarily isolate a subset of the records.
19. Filter by Selection lets you select all or part of a field value in a datasheet or form, and then display only those records that contain the select value in a field.
20. Filter by Form, allows you to select a value from the list arrow that appears when you click any blank field to apply a filter that selects only those records containing that value.
21. A comparison operator asks Access to compare the value in the database field to the condition value and to select all the records for which the relationship is true.

 

 

> greater than A > B
< less than A < B
>= greater than or equal to A >= B
<= less that or equal to A <= B
= equal to A = B
<> not <> A
Between..And between two values (inclusive) Between 50 and 325
In( ) in a list of values In("Hall","Seeger")
 
Like matches a pattern that includes wildcards *, ? like "707*"
 

22. An exact match occurs when the value in the specified field must match the condition exactly in order for the record to be included in the query results.
23. Logical Operators are used to combine two or more conditions.

 

Logical Operators
AND, OR, XOR, NOT

AND

 

A B C Result
True True True True
False True True False
False False True False
False False False False
 

OR

 

A B C Result
True True True True
False True True True
False False True True
False False False False
 


XOR

 

A

B C Result
True True True False
False True True True
False False True True
False False False False
 


Not

 

A Result
True False
False True

24. A calculated field is a field that displays the results of an expression and can be used in a query, form or report. The calculate field does not appear in the database.
25. An expression can contain a combination database fields, constants, numeric and logical operators.  

Operator Precedence used in evaluating expressions

 

High ^ Arithmetic
  Unary + or -  
  * / \ mod  
  + -  
  <, >, <=, >=, =, <> Relational
  NOT Logical
  AND  
Low OR and XOR  

26. Parentheses () can be used to change operator precedence.
27. The Zoom box is a large text box for entering text.
28. The Expression Builder is an Access tool that contains an expression box for entering the expression, buttons for common operators, and one or more lists of expression elements, such as table and field names.
29. Aggregate functions perform arithmetic operations on selected records in a database.

 
Aggregate Function Determines Data Type Supported
AVG Average of field values Autonumber,Currency, Date/Time, Number
Count Number of records selected Autonumber,Currency, Date/Time, Number, Memo, OLE,Text, Yes/No
Max Highest field value Autonumber,Currency, Date/Time, Number,Text
Min Lowest field value Autonumber, Currency, Date/Time, Number, Text
Sum Total of field values Autonumber, Currency, Date/Time, Number
StDev Standard Deviation of Variance Number, Currency
Var Variance of Data Number, Currency

30. The Group By operator divides the selected records into groups based on the values in the specified field. 

Best Practice:

Access2003 will let you convert to Access2000 or Access97.  Remember that when you convert the database from 2003 to 2000 or 97,  features supported by the 2003 version will not be available in the 2000 or 97 version.

Unit 13

The Student Learning Outcomes:

1. Create a form using the Form Wizard
2. Change a form's AutoFormat
3. Find data using a form
4. Preview and print selected form records
5. Maintain table data using a form
6. Check the spelling of table data using a form
7. Create a form with a main form and a subform
7a. Create a report using the Report Wizard
7b. Check errors in a report
8. Insert a picture in a report
9. Preview and print a report
 

Important Point:
1. When creating a form make sure the form is structured exactly like the source document from which the data is being taken.

2. Rules of Data Normalization 3rd Rule - Eliminate Columns not dependent of key. - If attributes do not contribute to a description of the key, remove them to a separate table.
3. The Form Wizard allows you to choose some or all of the fields in the selected tale or query, choose fields from other tables and queries, and display the selected fields in any order on the form.
4. The Find command lets you search for data in a form or data sheet so you can display only those records you wasn't to view.
5. The Find and Replace dialog box allows you to find data and replace it with other data.
6. Wildcard Characters used with find.

 

Wildcard Character Purpose Example
* Match any number of characters th* or *ent or be*ter
? Match any single character a?t find art or ant or apt
[] Match any single character within brackets a[fr]t find aft and art
! Match any character not within brackets a[!fr]t finds act,ant, but not aft or art
- Match any of a range of characters must be A to Z. a[d-p]t finds aft,ant apt, but not act or art.
# Match any single numeric character #72 finds 072,172,272, etc.

7. You can check the spelling of table data using a table or query data sheet or a form that displays the table data.
8. To create a form based on two tables, you must first define a relationship between the tow tables.
9. Based upon a one to many relationship between two tables, the main form will be used for the primary table and the sub form for the related table.
10. The Report Wizard ask you a series of questions then creates the report.
11. The set of field values for each position is called a detail record.
12. Each item on a report in Design view is called a control.
13. A bound control is derived from the table directly or through a query.
14. A unbound control is not connected to the underlying table directly or through a query.
15. When printing selected records, select the record's), file, print, selected records.
16. When printing a selected page of a report, file, print, page 1 to page 5 .
17. In the form or report design view the Error Checking Options button appears any time access identifies a possible error.

 

Unit 14

 

Student Learning Outcomes:

1. Open and view an existing PowerPoint presentation.
2. Switch views and navigate a presentation.
3. View a presentation in Slide Show View.
4. Create a presentation using the AutoContent wizard.
5. Add, move, and delete slides.
6. Promote and demote text in the outline tab.
7. Create speaker notes for slides.
8. Check the spelling and style in a presentation
9. Preview and print slides
10. Print outlines, handouts, and speaker notes.

Important Points:

1. PowerPoint is a presentation graphics program that provides structure to produce an effective presentation of on-screen slides, slide presentation on a web site, black-and-white or color overheads, or 35MM.
2. Slide pane view shows the current slide as it will look during slide show.
3. Notes pane contains notes for the presenter.
4. Slides tab is on top when you first start PP. which display a column of numbered slid thumbnails.
5. Outline tab show an outline of the titles and text of each slide.
6. Slide transitions is the manner in which an new slide appears on the screen.
7. Animation can be added to the elements on the slide.
8. Progressive disclosure is a technique in which each element on a slide appears one at a time.
9. Footer is a word or phrase that appears at the bottom of each slide.
10. Planning a presentation
11. purpose of the presentation
12. Type of presentation
13. Audience for the presentation.
14. Audience needs:
15. Location of the presentation:
16. Format:
17. Design template is a file that contains the colors and format of the background, font styles, accents, etc.
18. Layout is a predetermined way of organizing the objects on a slide.
19. Create presentation with AutoContent Wizard. File, new, Form Auto content wizard, nest, General, Training, next, on-screen presentation, next, presentation title (type in), Footer (type in), clear date last update check box, slide number checked, next, finish.
20. Save and name presentation. Save, Save in filename, save.
21. Modifying a Presentation.
22. Placeholder is a region of a slide or location in an outline reserved for inserting text or graphics.
23. Text box is a container for text.
24. Object is something that can be manipulated or resizes as a unit.
25. Sizing handles are used to make a text box or object smaller or bigger.
26. Bulleted list is a list of paragraphs with special characters to the left of each paragraph.
27. Bulleted items is one paragraph in a bulleted list.
28. First level bullet is a main paragraph in a bulleted list.
29. Second level bullet is a bullet beneath and indented from first lever bullet.
30. Numbered list is a list of paragraphs that are numbered.
31. Title text is a text box at the top of the slide.
32. Body text is a large text box in which you type a bulleted or numbered list.
33. Delete slide- right click slide in slide pane, click delete slide. or mark multiple slide and delete.
34. Text layouts: Title Slide - Title Only, Title and Text, Title and 2 column text.
35. Content layouts: charts, diagrams, images, tales, movie clips.
36. Text and content layouts.
37. Insert new slide - Click new slide button, pick the slide layout you want.
38. Promoting, Demoting and Moving outline text.
39. To promote an item means to increase the outline lever of that item. Decrease indent
40. To demote an item means to decrease the outline level. increase indent
41. Moving slide in slide sorter view. - click on slide then drag it to the new position.
42. Spell Checker - click spelling button on standard toolbar.
43. Style checker checks your presentation for consistency in grammar and visual elements.
44. Turn on style checker - tools, options, spelling and style tab, check style, style options, slide title style, uppercase, body text style, sentence case, Ok, Ok.
45. Light bulb appears next to problems in the slides, click the light bulb and select the option that applies.
46. Research task pane used for online services and help for creating presentation.
47. Thesaurus contains a list of words and their synonyms, antonyms, and other related words.
48. Use Thesaurus:-Highlight word, Click research button, click all reference books, click thesaurus: English US), click green arrow button, scroll down list and select appropriate word, click list arrow on side of box, click insert, close task pane.
49. Creating speaker notes: Go to slide, click on notes pane, enter text.
50. Notes are printed pages that contain a picture of and notes abut each slide.
51. Handouts are printouts of the slides; can be multiple slides per page.
52. Preview presentation: click print preview,
53. For grayscale: click options, point to color/grayscale, click grayscale.
54. Remove background from slide: Format, background, click omit background graphics from master check box, click apply to all.
55. Print Handouts: print preview, click print what list arrow, click handouts (4 slides per page), click print, click ok.
56. Print notes pages: print preview, click print what list arrow, click notes pages, click print, click ok,

 

Unit 15

 

Student Learning Outcomes:

1. Create presentation from a template.
2. Apply a new template.
3. Insert, resize, and recolor a clip-art image.
4. Modify the design using the slide master.
5. Insert a bitmap image on a slide.
6. Reformat text and resize text boxes.
7. Apply a second design template
8. Insert tab stops to align text
9. Change the layouts of existing slides.
10. Reposition text boxes.
11. Create and modify a table.
12. Crate a diagram using the diagram Gallery
13. Draw a simple graphic using auto shapes.
14. Modify and rotate an Auto shape graphic.
15. Insert and rotate text boxes.
16. Create a summary slide.

Important Points:

1. Planning a presentation: Purpose of the presentation: Type of presentation: Audience: Location of the presentation: audience needs: Format:
2. Create presentation from design template.
3. Design template is a file that contain the color scheme, text formats, background colors, objects, and graphics.
4. Color scheme is the eight colors used in a design template.
5. Graphic is a picture, clip art, photograph, shape, design, graph, chart, or diagram that you can add. Graphics are objects.
6. Click Crate a new presentation link at the bottom of the task pane, ckucj frin design template, scroll down through thumbnail view of design templates, click your selection.
7. To change a design template - click design button, scroll down and select the new design template you want, click it.
8. clip art refers specifically to images in the media gallery or online.
9. Change layout of a slide and add clip art.- select slide, format, slide layout, scroll down click title, text, and content layout, click close, click insert clip art on the content place holder, type in search text, click go, double click image.
10. Resize the clip art.-drag sizing handles.
11. Recolor clip art. - click object, click recolor picture button on picture toolbar, select colors, click preview, click ok.
12. Modifying the design template in the slide master- A master slide contain the elements and styles of the design template include text and other objects.
13. Four type of Masters:
14. Title Master-contains the objects that appear on the title slide.
15. Slide master contains the objects that appar on all the slides except the title master.
16. Handout master contains the objects that appear on all the printed handouts.
17. Notes master contains the objects that appear on the notes pages.
18. To switch to slide master view - click view, point to master, click slide master or title master or handout master or notes master.- click close master.
19. Inserting graphic on slide - click insert picture button on drawing toolbar, navigate to graphic, click on graphic, click insert button.
20. Transparent set on image - select image, click set transparent color button on picture toolbar.
21. Change order of objects on slide - select image, click draw button on drawing toolbar, point to order, click sent to back or bring foreword.
22. Font is the design of a set of characters.
23. Points is font size.
24. Font style referred  to special attributes applied.
25. Apply second design template: - select slide, click design button, scroll to select desired design template, apply to selected slides, close.
26. Tab stop is the location where the insertion point moves when you press tab key. View, Ruler, click the left tab, or right tab or center tab or decimal tab. click on the location you want the tab.
27. Insert footer - click view, click header and footer, click slide tab, click footer check box, insert text into footer area, click apply to all.
28. Table is information arranged in horizontal rows and vertical columns. The intersection of row and column is called cell.
29. Insert table - click format, click slide layout, select a contents layout, click insert table button, specify desired table size, click ok.
30. Draw border - click table, click draw table button on the table and border toolbar, click border width and select desired width, click border color button and select color, drag pencil where you want border to appear.
31. Diagram on a slide
32. Cycle diagrams - show process that has a continuous cycle
33. Organizational charts - show the relationship between individuals or unit within an organization.
34. Radial diagrams- show the relationships of a core element.
35. Pyramid diagrams -show foundation based relationships.
36. Venn diagrams - shows areas of overlap between elements
37. Target diagrams - show steps toward a goal.
38.  Insert Shape - select slide, click auto shapes button on drawing toolbar, point to basic shapes, click selected shape, position cursor where you want it on slide, hold down shift key (for proportional draw), click and drag.
39. Change fill color - with object selected, click fill color list arrow on drawing toolbar.
40. To flip object - select object, click draw bottom drawing toolbar, point to rotate or flip and select option desired.
41. Insert text box.  Click text box button on drawing toolbar, position cursor, click.
42. Summary slide - click slide sorter view, select the slides you want in summary slide, click summary slide button.
 

Unit 16

Student Learning Outcomes:

1. be able to share office files on line.
2. be able to create web page in Word.
3. Insert a hyperlink
4. Preview a Web page in a browser.
5. Create web pages in Excel.
6. Create Web Pages in Access
7. Create web pages in PowerPoint
8. Publish web page to the internet.

Important Points:

1. HTML is the code use to create web pages.
2. Web page editor is software program designed for task. Frontpage2003.
3. Single file web page is one file that contain the HTML documents along with supporting files. Can send as e-mail.
4. Filtered Web page- HTML documents with office related tags removed.
5. Creating web pages in word - Can be created from template ( already existing html document)
6. Open existing document, click files, click save as web page, identify location to save to, put in new file name, click save as type list arrow, click web page. click change title button, type a page title, click Ok, click save.
7. Type in the text and any formatting you want applied.
8. To apply theme (predefine formats for web page), format, theme, select the theme desired, Ok, save work.
9. Save existing word document as webpage- Click file, click save as web page. select location, type in file name, save as type web page, change title, Ok, save.
10. Insert Hyperlink- select text, click insert hyperlink button, look in list arrow, select fie, Ok, save.
11. Preview web page- File, web Page Preview.
12. Creating Web Page in Excel
13. Noninteractive web  page allows users to scroll through and view but no changes.
14. Interactive web page provides tool for users to modify and format the values displayed.
15. Publish - save workbook or portions of workbook as a web page.
16. Open workbook, File, save as web  page, type in new name, find location, save as type, choose type, change page title, OK, check the add interactivity check box to create interactive web page or leave it unchecked  click publish button, click choose list arrow, click what you want to include in web page, check the auto republish every time this workbook is saved. check the open published webpage in browser, click publish button.
17. To test open in IE. change values in interactive web page.
18. Creating web pages in Access.
19. Static HTML page base on table, query, form, or report that show data at the time the page was published. Right click object, click export, location to save, save as type, HTML document, click save formatted check box, click export button, click default encoding option, click OK.
20. Dynamic HTML page base on table, query, or form that is created each time the page is viewed.
21. Data access page- web page that is linked to data in table, view, update, manipulate, or delete records. Click Pages module, click new button, click autopage: columar or other, elect the table or query, click OK, click save.
22. Creating Web Page in PowerPoint- when you create a web page in PowerPoint it is saved as a frames page with links to each slide.
23. Click file, click save as web  page, type in new file name, identify location, save a type( choose one of the two options), click publish button, click complete presentation option button, select option in browser support area, click change title button and type in new title, click ok, check open published web page in browser, click publish.
22. If you have a web server you can publish to the server also called uploading using FTP(file transfer protocol) into a web folder on the server.