Description:
This Microsoft Office 2007 Access Beginners will allow you to get started quickly with prebuilt applications that can modify or adapt to changing business needs. Collect information through form in e-mail or import data from external applications. Create and edit detailed reports that display sorted, filtered, and grouped information in a way that helps you make sense of the data for informed decision-making. Sharing information by moving your Office Access 2007 files to a Windows SharePoint Services Web site, where you can audit revision history, recover deleted information, set data access permission, and back up your information at regular intervals.
This series will provide you an overview of the features and functions of Microsoft Office Access 2007. If you are interested to learn all the basics of Microsoft Access 2007, then you should join this course now.
So, if you want to learn beginning level Access 2007 Skills.
Who is this Course for?
Microsoft Office 2007 Access Beginners is perfect for anyone trying to learn potential professional skills.As there is no experience and qualification required for this course, it is available for all students from any academic background.
Entry Requirement:
- This course is available to all learners, of all academic backgrounds.
- Learners should be aged 16 or over to undertake the qualification.
- Good understanding of the English language, numeracy and ICT are required to attend this course.
Certification:
After completing the course successfully, you will be able to obtain an Accredited Certificate of Achievement. Certificates can be obtained either in hard copy or in PDF format.
Course Curriculum
Getting Started | |||
Database Concepts | 00:05:00 | ||
Indentifying Database Components | 00:04:00 | ||
Exploring the Access Environment | 00:03:00 | ||
Starting Access and Examining the Access Window | 00:06:00 | ||
Opening a Database | 00:04:00 | ||
Getting Help | 00:01:00 | ||
Using Help | 00:03:00 | ||
Databases and Tables | |||
Planning and Designing Databases | 00:05:00 | ||
Creating a Database from a Template | 00:01:00 | ||
Creating a Blank Database | 00:01:00 | ||
Exploring Table | 00:01:00 | ||
Navigating in a Table in Datasheet View | 00:05:00 | ||
Examining a Table in Design View | 00:04:00 | ||
Creating Tables | 00:05:00 | ||
Creating a Table by Using the Table Templates | 00:06:00 | ||
Creating a Table in Design View | 00:02:00 | ||
Adding Fields and Descriptions to a Table | 00:05:00 | ||
Setting the Primary Key | 00:01:00 | ||
Saving the Table | 00:01:00 | ||
dding a Record | 00:02:00 | ||
Copying, Modifying, and Deleting a Table | 00:03:00 | ||
Creating a Composite Key | 00:03:00 | ||
Fields and Records | |||
Changing the Design of a Table | 00:05:00 | ||
Modifying Field Names | 00:01:00 | ||
Deleting and Inserting Fields | 00:02:00 | ||
Moving a Field | 00:01:00 | ||
Using the Attachment Data Type | 00:04:00 | ||
Adding a Total Row | 00:03:00 | ||
Finding and Editing Records | 00:02:00 | ||
Finding and Replacing a Value | 00:03:00 | ||
Undoing Changes | 00:01:00 | ||
Organizing Records | 00:04:00 | ||
Sorting Records by a Single Field | 00:01:00 | ||
Sorting Records by Multiple Fields | 00:02:00 | ||
Using Filter by Selection | 00:02:00 | ||
Using Filter by Form | 00:02:00 | ||
Using Filter Excluding Selection | 00:01:00 | ||
Using Advanced FilterSort | 00:02:00 | ||
Deleting a Record | 00:02:00 | ||
Data Entry Rules | |||
Setting Field Properties | 00:04:00 | ||
Using the Allow Zero Length Property | 00:03:00 | ||
Setting the Field Size Property | 00:02:00 | ||
Setting the Append Only Property | 00:03:00 | ||
Working with Input Masks | 00:02:00 | ||
Creating an Input Mask | 00:03:00 | ||
Working with the Input Mask Wizard | 00:03:00 | ||
Setting Validation Rules | 00:01:00 | ||
Creating Validation Rules | 00:03:00 | ||
Setting Validation Text | 00:02:00 | ||
Basic Queries | |||
Creating and Using Queries | 00:05:00 | ||
Using the Query Wizard | 00:04:00 | ||
Creating a Query in Design View | 00:02:00 | ||
Saving and Running the Query | 00:01:00 | ||
Sorting Query Results | 00:01:00 | ||
Filtering a Query by Adding Criteria | 00:01:00 | ||
Creating a Query from a Filter | 00:03:00 | ||
Modifying Query Results and Queries | 00:02:00 | ||
Editing Query Results | 00:02:00 | ||
Adding Fields to a Query | 00:01:00 | ||
Finding Records with Empty Fields | 00:01:00 | ||
Performing Operations in Queries | 00:04:00 | ||
Using Comparison Operators | 00:01:00 | ||
Using the OR Condition | 00:01:00 | ||
Using the AND Condition | 00:01:00 | ||
Using the Wildcard | 00:01:00 | ||
Using Calculations in a Query | 00:03:00 | ||
Totaling a Group of Records | 00:02:00 | ||
Using the Avg and Count Functions | 00:01:00 | ||
Using Forms | |||
Creating Forms | 00:05:00 | ||
Examining a Form | 00:03:00 | ||
Creating a Basic Form | 00:01:00 | ||
Creating a Form Using the Form Wizard | 00:02:00 | ||
Using Design View | 00:04:00 | ||
Creating a Form in Design View | 00:01:00 | ||
Addings Controls | 00:03:00 | ||
DModifying Properties | 00:06:00 | ||
Applying Conditional Formatting | 00:03:00 | ||
Sorting and Filtering Records | 00:01:00 | ||
Using a Form to Sort Records | 00:01:00 | ||
Using a Form to Filter Records | 00:01:00 | ||
Working with Reports | |||
Reports | 00:03:00 | ||
Examining a Report | 00:01:00 | ||
Creating a Basic Report | 00:01:00 | ||
Creating a Report Using the Report Wizard | 00:02:00 | ||
Creating a Report Using Design View | 00:04:00 | ||
Modifying and Printing Reports | 00:05:00 | ||
Modifying Reports in Design View | 00:03:00 | ||
Modifying Reports in Layout View | 00:03:00 | ||
Grouping, Sorting, and Filtering a Report | 00:02:00 | ||
Adding Summary Fields Using the Report Wizard | 00:02:00 | ||
Modifying the Layout and Style of a Report | 00:01:00 | ||
Certificate and Transcript | |||
Order Your Certificates or Transcripts | 00:00:00 |
Course Reviews
No Reviews found for this course.