Archive: Microsoft Access Private Tutor (Basic To Advanced) VIEW COURSE OUTLINE

Posted Jun 13      Owerri North, Imo State, Nigeria

Ad is archive
find similar ads in Classes & Courses in Owerri North

Post Ad like this for FREE
Private Teacher
IT & Software
IT Certifications
Service Features
Home Lessons
Services Rendering at Client Location

Ad details

Archive: Module 1: Access Basics<br /> Database concepts and terminology<br /> Starting Access<br /> Creating a new file<br /> Trusting a file<br /> The Quick Access toolbar<br /> Backstage view<br /> Exploring ribbons<br /> Using the Navigation pane<br /> Getting help<br />Module 2: Creating a first Database and Using the Tools<br /> Planning and designing your database<br /> Creating tables using Application Parts<br /> Creating tables in layout view with Quick Start<br /> Creating and editing tables in Design view<br /> Setting a primary key<br /> Creating a lookup field<br /> Creating multi-value fields<br /> Using calculated fields<br />Module 3: Setting Up the Data<br /> Setting field properties<br /> Setting input masks<br /> Setting validation rules<br />Module 4: Building Structure<br />a. Creating relationship and enforcing referential integrity<br />b. Viewing subdatasheets<br />Module 5: Formatting and Appearance<br /> Entering data into your tables<br /> Formatting tables<br /> Finding, sorting and filtering records<br />Module 6: Forms<br /> Creating data entry forms<br /> Using the Form Wizard<br /> Modifying a form in layout view<br /> Using Design view<br /> Setting tab stops<br /> Adding buttons to a form<br /> Using navigation forms<br />Module 7: Queries<br /> Introduction to queries<br /> Using the Query Wizard<br /> Creating a query in Design view with criteria<br /> Creating wildcard queries<br /> Creating reusable parameter queries<br /> Creating yes/no queries<br /> Creating &#34;and&#34; and &#34;or&#34; queries<br /> Building calculation queries<br /> Creating statistical queries<br /> Using update queries<br /> Using delete queries<br /> Creating crosstab queries<br />Module 8: Reports<br /> Introduction to reports<br /> Using the Report Wizard<br /> Formatting reports in layout view<br /> Identifying report structure in Design view<br /> Adding group and sort capabilities to a report<br /> Adding existing fields from other tables<br /> Adding totals and subtotals to a report<br /> Adding conditional formatting and data bars to a report<br /> Creating multi-table reports<br /> Creating mailing labels<br /> Printing reports<br />Module 9: Putting Data to Work<br /> PivotTables<br /> PivotCharts<br />Module 10: Automating with Macros<br /> Creating macros<br /> Attaching macros to objects<br /> Using data macros<br />Module 11: Using Other Applications with Access<br /> Importing Excel and text data<br /> Exporting data into Excel<br /> Exporting to PDf<br /> Exporting into a Word Mail Merge<br /> Publishing to a web browser in HTML or XML<br /> Sharing via mail<br /> Collecting data over email<br /> Using Package and Sign<br /> Publishing to SharePoint<br /> Importing and exporting with SharePoint<br />Module 12: Advanced Tools in the Database<br /> Compacting and repairing a database<br /> Using data analysis tools<br /> Encrypting a database and setting a password<br /> Splitting a database<br />Module 13: Customization<br /> Customizing the ribbons<br /> Setting Access options<br />Module 14: Review and Exercise files

Similar adverts

Show more ads >>>


Last seen 7 months ago