The Center of Higher Learning and Pearl River Community College are pleased to announce Microsoft software training at the NASA John C. Stennis Space Center. These classes are scheduled for the CHL Computer Training Lab in Bldg. 1103, Room 1005.
To reserve a seat, at least one week prior, please contact Troy Teadt at 228-688-3113 (office), 985-788-3257 (cell) or firstname.lastname@example.org (email).
Microsoft Access: Advanced (Level 3 of 3)
Upon successful completion of this course, students will be able to:
- put existing data into correctly designed tables and compact your database.
- use a variety of techniques to summarize data.
- create and revise basic Access macros.
- create macros that require data entry in certain fields and automatic data entry in others.
- use advanced features to enhance forms.
- use advanced features to enhance reports and distribute a report to non-Access users.
- use Office Links to use Access data in other Office programs.
Lesson 1: Structuring Existing Data
Topic 1A: Use the Table Analyzer Wizard for Help
Topic 1B: Decide on Your Own Design
Topic 1C: Create a Junction Table
Topic 1D: Modify the Original Tables and Complete the Design
Topic 1E: Compact and Repair a Database
Lesson 2: Summarizing Data
Topic 2A: Group and Summarize Records in Different Ways
Topic 2B: Summarize with a Crosstab Query
Topic 2C: Pivot Query Results
Topic 2D: Display a Graphical Summary on a Form
Lesson 3: Simplifying Tasks with Macros
Topic 3A: Create a Macro
Topic 3B: Attach a Macro to a Command Button
Topic 3C: Restrict Records
Lesson 4: Adding Interaction and Automation with Macros
Topic 4A: Require Data Entry with a Macro
Topic 4B: Display a Message Box with a Macro
Topic 4C: Automate Data Entry
Lesson 5: Making Forms More Usable
Topic 5A: Change the Display of Data Under Certain Conditions
Topic 5B: Display a Calendar on a Form
Topic 5C: Organize Information with Tab Pages
Lesson 6: Making Reports More Powerful
Topic 6A: Cancel Printing of a Blank Report
Topic 6B: Include a Chart
Topic 6C: Arrange Data in Columns
Topic 6D: Distribute Reports as a Snapshot
Lesson 7: Expanding the Reach of Your Data
Topic 7A: Merge Access Data with a Word Document
Topic 7B: Publish Access Data as a Word Document
Topic 7C: Analyze Access Data in Excel