This Microsoft Office 2007 Access Beginners – Complete Video Course 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.
- At the end of the course, you will be required to sit for an online MCQ test. Your test will be assessed automatically and immediately. You will instantly know whether you have been successful or not.
- Before sitting for your final exam you will have the opportunity to test your proficiency with a mock exam.
- After completing and passing the course successfully, you will be able to obtain an Accredited Certificate of Achievement.
- Certificates can be obtained either in hard copy at a cost of £39 or in PDF format at a cost of £24.
Who is this Course for?
Microsoft Office 2007 Access Beginners – Complete Video Course is certified by CPD Qualifications Standards and CiQ. This makes it 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.
Our Microsoft Office 2007 Access Beginners – Complete Video Course is fully compatible with any kind of device. Whether you are using Windows computer, Mac, smartphones or tablets, you will get the same experience while learning. Besides that, you will be able to access the course with any kind of internet connection from anywhere at any time without any kind of limitation.
After completing this course you will be able to build up accurate knowledge and skills with proper confidence to enrich yourself and brighten up your career in the relevant job market.
|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|
|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|
|Navigating in a Table in Datasheet View||00:05:00|
|Examining a Table in Design View||00:04: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|
|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|
|Setting the Required Property||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|
|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|
|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|
|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|
|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|
|Mock Exam- Microsoft Office 2007 Access Beginners – Complete Video Course||00:20:00|
|Final Exam- Microsoft Office 2007 Access Beginners – Complete Video Course||00:20:00|
No Reviews found for this course.