Microsoft Access 2010 Fundamentals
SmartStyle
Duration: 2 Days
£250
(Exc VAT per head on a public scheduled course)
Detailed information
| Type: | Training |
|---|---|
| Method: | In a classroom |
| Accreditation: | N/A |
| Prepares for: | Practical work based Microsoft Access skills |
| Geared towards: | Users who need to design and create basic databases in Microsoft Access |
| Requirements: | Users must be proficient with a mouse and keyboard and be able to confidently work within a Windows environment - minimise, maximise, open, close. Familiarity of either Word or Excel is useful, but not essential. |
| Internship: | N/A |
| Students per class: | 10 |
Do you need further information?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course program
Database Basics
The Access Objects
What is a Relational Database?
Database Design Techniques
Navigating the Database Window
Navigation & Data Entry
Opening Tables
Navigating in Datasheet View
Adding & Deleting Records
Selecting in a Table
Creating Databases & Defining Tables
Creating & Saving a Database
Creating Tables
Inserting, Deleting & Moving a Field
Changing the Data Type
Modifying Field Properties
Relationships & Look-Ups
Relationships Explained
Setting a Primary Key
Creating a Relationship
About Look-Ups
Referential Integrity
Working with Data in Tables
Changing the Look of Data
Sorting in Tables
Formatting Datasheet View
Filtering Data
Searching Tables
Queries
Creating & Running Queries
Adding Criteria to Queries
Saving the Query – Creating a Dynaset
Multi-Table Queries
Setting Field Properties
Forms
Creating Forms Using the Form Wizard
Multi-Table Forms
Designing Forms
Formatting Controls
Control Properties
Reports
Creating Reports using Report Wizard
Creating Mailing Labels
Report Sections
Form Design vs Report Design
White Space
Summary Reports
Printing in Access
Printing from Tables & Queries
Printing a Form
Printing Reports
The Access Objects
What is a Relational Database?
Database Design Techniques
Navigating the Database Window
Navigation & Data Entry
Opening Tables
Navigating in Datasheet View
Adding & Deleting Records
Selecting in a Table
Creating Databases & Defining Tables
Creating & Saving a Database
Creating Tables
Inserting, Deleting & Moving a Field
Changing the Data Type
Modifying Field Properties
Relationships & Look-Ups
Relationships Explained
Setting a Primary Key
Creating a Relationship
About Look-Ups
Referential Integrity
Working with Data in Tables
Changing the Look of Data
Sorting in Tables
Formatting Datasheet View
Filtering Data
Searching Tables
Queries
Creating & Running Queries
Adding Criteria to Queries
Saving the Query – Creating a Dynaset
Multi-Table Queries
Setting Field Properties
Forms
Creating Forms Using the Form Wizard
Multi-Table Forms
Designing Forms
Formatting Controls
Control Properties
Reports
Creating Reports using Report Wizard
Creating Mailing Labels
Report Sections
Form Design vs Report Design
White Space
Summary Reports
Printing in Access
Printing from Tables & Queries
Printing a Form
Printing Reports
Do you need clarification regarding the course program?
Contact the person in charge , free and at no obligation, for information on how to enroll, enrollment limit/availability and more.
Course location
- 2nd Floor Orleans House, Edmund Street - L3 9NGCity and Borough of Liverpool (England)
SmartStyle
Recognised as one of the UK’s leading providers in the field of learning and development, SmartStyle ensure that organisations get the most from their people, their technology and their investment in both.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
Delivering bespoke and “off-the-shelf” IT, business skills and professional development training, SmartStyle provide organisations across all sectors, a one stop solution for their learning and development needs, from our centres in Bradford and Liverpool.
Working in partnership with our clients, we identify real needs, aligned with organisational objectives and match innovative learning interventions to those needs - getting the right skills to the right people and delivering maximum return on investment.
