Emuriasoft Uganda Ltd

Loading

MS ACCESS

Ordinary Microsoft Office Access Training

Get Started

1. Starting Access
2. Identifying parts of the Access screen
3. Working with the Ribbon & backstage view
4. Using the quick access toolbar
5. Creating a new blank database

1. Determining current & future needs
2. Organizing data & selecting fields names
3. Deciding data types for fields

1. Opening & closing an existing database
2. Using the navigation Pane
3. Working with database objects
4. Exiting Access

Tables

1. What is a table?
2. Creating a new table in datasheet view
3. Defining table fields
4. Assigning field names & data types
5. Using the quick add feature
6. Entering, editing, or deleting records
7. Setting field sizes & using best fit
8. Navigating through records
9. Saving a table

1. Switching between design & datasheet view

1. Adding fields
2. Selecting data types & entering description
3. Defining a field as a primary key
4. Renaming, rearranging, or deleting fields
5. Using the lookup wizard

1. Setting field size & formatting
2. Using the input mask

1. Sorting records in ascending or descending order
2. Sorting records using multiple criteria

1. Finding & replacing records

1. Printing & previewing a table
2. Printing records
3. Changing margins & page orientation

Table Relationships

1. Understanding relationships
2. Setting primary keys & foreign keys
3. Creating table relationships
4. Types of relationships
5. Viewing related tables
6. Specifying referential integrity
7. Printing database relationships
8. Editing or deleting relationships
9. Displaying related records in a sub-datasheet

Spelling Check and Help

1. Using the spelling check

1. Searching help or using content help

Queries

1. What is a Query?
2. Using the simple query wizard
3. Selecting the table source
4. Selecting fields
5. Saving the query

1. Adding tables to the design query window
2. Selecting fields & establishing query criteria
3. Creating a multiple related tables query
4. Sorting fields in a query
5. Saving the query

1. Opening & switching queries to design view
2. Adding, rearranging or deleting fields
3. Sorting the query output
4. Filtering the query output with one or multiple criteria
5. Hiding fields
6. Changing column headings in a query

1. Filtering records by selection or by form

Forms

1. What is a form?
2. Creating a form using the form wizard
3. Saving or renaming a form
4. Sorting records using a form
5. Entering, editing or deleting records using a form
6. Creating a form from related tables
7. Moving within or between records
8. Printing forms

1. Switching views: Form, layout, & design view
2. Showing or hiding the field list
3. Adding or deleting controls
4. Resizing, formatting, or aligning controls
5. Moving controls & labels
6. Displaying form properties
7. Using fields to add controls
8. Adding a form header & footer

Reports

1. Report view
2. Print preview
3. Layout view
4. Design view

1. What is a report?
2. Creating reports based on queries
3. Preparing a report based on two or more tables
4. Modifying reports

1. Using fields to add controls
2. Moving & Resizing controls
3. Adding & formatting controls
4. Changing the report theme
5. Adding headers & footers

1. Setting page margins & changing page orientation
2. Printing & previewing reports

MS ACCESS

Advanced Microsoft Office Access Training

Advanced Table Design

1. Formatting tables
2. Controlling table data entry
3. Moving fields
4. Adding or deleting fields

1. Specifying field size
2. Displaying different text formats
3. Displaying different number or currency formats
4. Customizing date/time display
5. Entering input masks
6. Controlling a field name display with caption
7. Setting validation rules
8. Specifying default values & required fields
9. Creating lookup fields
10. Indexing fields

1. Creating a single envelope
2. Creating an envelope using the recipient letter as source
3. Setting a default return address
4. Working with envelope options
5. Arranging & formatting the content of envelopes
6. Printing envelopes

Multiple Table Relationship

1. Understanding relationships
2. One-to-one relationships
3. One-to-many
4. Many-to-many relationships

1. Enforcing referential integrity relationships
2. Using the cascade updates related fields
3. Using the cascade delete related records
4. Editing relationships

External Data

1. Importing data to a new table
2. Importing data as a linked table

1. Using the Office clipboard

Database Maintenance

1. Backing up & restoring a database
2. Compacting & repairing a database
3. Viewing object dependencies

Advanced Forms

1. Detail forms
2. Datasheet forms
3. Split forms
4. Multiple items forms

1. Customizing sections
2. Sorting in a form
3. Selecting multiple controls
4. Adding a calculated control
5. Working with a form in layout view
6. Working with a form in design view
7. Adding controls in layout & design views
8. Aligning & sizing controls
9. Reposition controls & labels
10. Separate controls & labels
11. Inserting a picture to a form
12. Changing form properties

1. Working with themes, fonts, & colours
2. Applying background images to forms

1. Create a form with two tables
2. Creating & modifying subforms
3. Adding a subform control
4. Changing subform size

Advanced Queries

1. Adjusting fields
2. Sorting or hiding query fields
3. Adding calculated fields
4. Adding comparison operators
5. Displaying totals
6. Designing queries with aggregate functions
7. Refining a query using filter by selection
8. Refining a query using filter by form
9. Creating advanced filters
10. Grouping & summarizing records

1. Parameter queries
2. Duplicate queries
3. Unique queries
4. Unmatched queries

1. Total Queries
2. Crosstab queries

1. Make-table queries
2. Delete queries
3. Append queries
4. Update queries

Advanced Reports

1. Selecting & formatting Controls
2. Reorganizing labels & controls
3. Adding controls from the ribbon
4. Grouping & sorting
5. Adding calculated controls

1. Adding controls from the ribbon
2. Selecting controls
3. Aligning & sizing controls
4. Spacing controls
5. Inserting header & footer
6. Modifying properties

1. Applying conditional formatting
2. Applying themes

1. Mailing Label

Need help?