Premium Essay

Ms Access Tutorials

In:

Submitted By minlatt
Words 673
Pages 3
Specify the default form in Access Options
This procedure assumes that you have already created the form that you want to display. 1. Click the Microsoft Office Button , and then click Access Options. 2. Click Current Database, and then in the Display Form list, select the form that you want to display when the database starts. 3. -------------------------------------------------
Click OK, and then close and reopen the database to display the startup form. 4. How to hide and unhide a MS Access object

You can hide and unhide a MS Access object (Tables, Queries, Forms, Reports, Pages, Macros, Modules) in the query navigation pane. It's a similar feature like what you do in MS Excel to hide and unhide a spreadsheet. 5. There are various reasons why you want to hide and unhide an Access object. You may work on an Access database that was developed by someone else and you'd like to know if there are any hidden tables or queries and how to view them. 6. On the other hand, when you develop a MS Access database application, sometimes you may consider hiding some queries in the navigation pane and later you may want to see it back or unhide them. In this article, we are going to demo how to hide and unhide an Access query. 7. How to hide a query in Access 8. For hiding a query, it's similar across all the Access versions, Access 97, 2000, XP, 2003, 2007, etc. 9. Below are some screenshots for Access 2003 and Access 2007 for hiding the query "Quarterly Orders by Product" in Northwind database. 10. 1. Open Properties window. 11. Access 2003: In the Queries pane, right click on the query name "Quarterly Orders by Product" and select Properties in the pop-up context menu. 12. 13. Access 2007: In the navigation pane, right click on the query name "Quarterly Orders by Product" and select Object Properties in the

Similar Documents

Premium Essay

Research Proposal

...Microsoft Access Tutorial - FunctionX - Introduction - Creating A Database - Tables Design - Introduction To Microsoft Access Objects - Controlling The User's Input - Relationships - Subdatasheets - Forms Design Overview - Exploring And Analyzing Data - Query Design And Exploration - Forms Properties - Calculated Fields - Advanced Queries - Exploring Forms Controls - Designing And Improving A Report - Importing From And Exporting Data To Other Applications - Macros - Switchboard - Introduction to VBA - Shortcuts - A Complete Database Created With The Keyboard - Introduction To A Microsoft Access Database 1 - Introduction: A database is a collection of information organized as to make it easy to view it, search it, retrieve the right detail, and collect the necessary facts in an easier, timely, and effortless manner as possible. 2 - Relational Database: http://www.functionx.com/access/print.htm (1 of 95) [2000/11/04 09:42:31 AM] Microsoft Access Tutorial - FunctionX An organized database is composed of inter-related parts. Since you define these parts, you also organize them in a manner that helps some parts of your database to supply specific information to others. In one part, you would cover one category of data, such as people's personal information (name, date of birth, salary, hobbies, etc), in another you would cover what they buy in a store. 3 - Microsoft Access: Microsoft Access is a relational database used on desktop computers to manage...

Words: 34096 - Pages: 137

Premium Essay

Marketing

...Module Study Guide Information and Communication Technology The Claude Littner Business School The Claude Littner Business School Information and Communication Technology Module Study Guide |Module Code |BA40019E | |Level |4 | |Credits |20 | AY2014-2015 Version No 1 © UWL 2014 Location/Paragon Information and Communication Technology Module Study Guide |Contents |Page No. | |Module Leader and Teaching Team Details…………………… 4 | | | | | |Facts and figures | | | | | |Section A Overview and Content | | |1 Welcome and Introduction to the Module………6 ...

Words: 4674 - Pages: 19

Premium Essay

Australian Legal System in Context

...AUSTRALIAN LEGAL SYSTEM IN CONTEXT BLB1101 Semester 1 2014 Table of contents Topic Page number Unit rationale and learning outcomes 3 Calendars – lectures and tutorial workshops 4 Tutorial workshop exercises 5-11 Assessment information 12-23 Assessment tasks 12 Part 1 – VCAT and Applied law 12 Part 2 – VCAT and Contextual analysis 13 Hypothetical Case Studies 15 • Residential Tenancies List 15 • Planning and Environment List 18 • Anti-Discrimination list 20 Assessment criteria 22 Reading guide 24-28 Su Robertson, Unit Coordinator su.robertson@vu.edu.au 9919 1823 Unit rationale BLB1101 Australian Legal System in Context: • Provides you with a working foundation in the technical structure of Australian legal systems, using applied practical teaching and learning methods; • Exposes you to ways of making sense of Australian legal systems in a legal academic way using the themes of economics, sustainability, race and gender; • Inducts you in the ways of the lawyer, including appropriate language use and structure, ethics and legal professional behaviour, using reflective, applied and theory-based teaching and learning methods. Learning outcomes Upon successful completion of BLB1101, you will: • Be able to identify and understand the components of Australian legal systems, how these components intersect and interact, and how lawyers use these systems; • Be able to identify and use the language...

Words: 9050 - Pages: 37

Free Essay

Cis 206 Slingshot Academy / Tutorialrank.Com

...CIS 206 All iLabs: Devry University (DEVRY) For more course tutorials visit www.tutorialrank.com CIS 206 All iLabs: Devry University ----------------------------------------------------------- CIS 206 Case Study 2-3 Discussing the Functions of an Operating System (DEVRY) For more course tutorials visit www.tutorialrank.com You have been selected to present a short talk on the functions of an operating system for the weekly tech meeting. To support your talk, you must prepare a handout for the attendees. The handout should summarize the information that you have learned about this topic. ----------------------------------------------------------- CIS 206 Case Study 2-4 Discussing How Applications Interact with Operating Systems (DEVRY) For more course tutorials visit www.tutorialrank.com You have been asked to prepare a short lecture for users in the Accounting Department. They have expressed interest in learning more about how the operating system supports the applications they use. Your boss would like to review your lecture notes prior to the class, so you need to save them to a document. Your notes should provide details of your lecture. ----------------------------------------------------------- CIS 206 Case Study 8-2 Researching Background and Font Combinations in Fedora Core 4 (DEVRY) For more course tutorials visit www.tutorialrank.com Case 8-2: Researching Background and Font Combinations in Fedora Core 4 You have been asked to prepare...

Words: 3261 - Pages: 14

Premium Essay

Cis 336 Academic Professor - Tutorialrank

...CIS 336 Entire Course: Devry University For more course tutorials visit www.tutorialrank.com CIS 336 Entire Course: Devry University _________________________________________ CIS 336 Final Exam 1 For more course tutorials visit www.tutorialrank.com 1. (TCO 1) Most DBMS are referred to as _____________database management systems. (Points : 4) elemental linked hierarchical relational 2. (TCO 1) Data constitutes the building blocks of _____________. (Points : 4) information processing applications programming 3. (TCO 2) If a foreign key contains either matching values or nulls, the table(s) that make use of such a foreign key is/are said to exhibit __________ integrity. (Points : 4) referential restrictive secondary redundant 4. (TCO 2) In a "one-to-many" relationship, which constraint is usually added to the "many" table? (Points : 4) UNIQUE PRIMARY KEY FOREIGN KEY NOT NULL __________________________________________________ CIS 336 Week 1 iLab 1 Devry University For more course tutorials visit www.tutorialrank.com L A B O V E R V I E W Scenario/Summary This lab will introduce you to the processes involved in defining one of the key components of a data model; the relationship diagram (RD). In this lab, you will draw a relationship diagram for two of the steps shown. Keep in mind when you are trying to decide which side of the relationship should be the "one" side and which...

Words: 689 - Pages: 3

Free Essay

Human Resource, Policies

...Joined as a Trainee and later promoted to Jr. Web Designer ROLE AND RESPONSIBILITIES: • Project Coordinator: Gathering requirements, analyzing and working closely with developers to get work done • Designing and implementing web sites by working closely with clients to integrate state-of-the-art web resources to improve revenue and meet other marketing goals • Responsibilities as an interface designer include analyze the requirements of the project and develop the coding with the help of the HTML, CSS, JavaScript/jQuery and XAML (Silverlight). • Played lead role in designing prototypes and GUI for Web Applications, Windows Applications and Handheld Applications • Visualize, Develop, Design and Script web pages using Adobe Suite and MS Expression Suite • Interpret and translate requirements of the business into a visual stuff. • Assist in the creations of the requirements during product definition phase. • Done planning for completion of websites. • Providing identity and stationary design and icon sets. • Created presentations for Govt. bodies like MMRDA, Mumbai Metro ONE, DMRC, Saltpan Commissioner Office, and MMC (for SRA Scheme) for upliftment of Mumbai • Worked as Software Testing Executive to ensure the...

Words: 637 - Pages: 3

Premium Essay

Itt Syllabus

...GS1145 Strategies for the Technical Professional Syllabus Credit hours: 4.5 Contact/Instructional hours: 56 (34 Theory, 22 Lab) GS1145 Strategies for the Technical Professional Syllabus COURSE SUMMARY COURSE DESCRIPTION This course reviews characteristic and trends of the global information society including basic information processing, Internet research, other skills used by the technical professionals and techniques that can be used for independent technical learning. MAJOR INSTRUCTIONAL AREAS 1. Getting Started at ITT Technical Institute 2. Productivity Software 3. Overview of Technology Tools 4. Microsoft Word 5. Microsoft PowerPoint 6. Microsoft Excel 7. Microsoft Access 8. Communication Tools 9. Exploring Career Goals 21st-century skills o Changes in work and the workplace o Building marketable proficiencies o Projecting professionalism ITT Technical Institute Career Services Resources o Targeting job descriptions  o Transferable skills Crafting a Resume 10. Skills and Techniques of a Successful Student Strategies for independent learning Learning styles Note-taking strategies Test-taking techniques © ITT Educational Services, Inc. All Rights Reserved. [2] 10/29/2013 GS1145 Strategies for the Technical Professional Syllabus Critical thinking Problem solving Basic research skills o ITT Tech Virtual Library o Web searches o Citing sources Time management Working in teams COURSE LEARNING OBJECTIVES By the end of this course, you should be able...

Words: 14113 - Pages: 57

Premium Essay

Campus Resources

...Christian Zuniga Ms. Do Carmo English 60B March 12, 2013 Campus Resources Norco College offers a variety of resources to students who attend RCC Norco and seek assistance in education. For instance, RCC Norco offers students tutorial services; this service provides a supportive learning environment to students who seek help academically to improve in their classes. For example, tutoring services offers students with course assistance by providing tutors to help students understand there class materials. Another resource that RCC Norco offers is extended opportunity programs and services, better known as EOPS. This service is a student support program to help recruit, retain and assist the academic success of low-income and educationally disadvantaged students by providing them with the tools and resources for achieving a higher education. Tutorial services and EOPS are two of the variety of resources offered at Norco College for students who seek academic success. Two of the available resources offered at Norco College benefits a student with success through education and academic progress. For example, tutorial services benefits students by creating a learning environment around them and guiding them to academic success. In other words, a student who has a hard time understanding the material in a math class may go to the tutoring center a quiet place of study and seek assistance in math from a tutor. Tutoring can also help students achieve a higher grade point average...

Words: 400 - Pages: 2

Premium Essay

Final Exam~

...March BCOM 101F 1. Jennifer Kettle. (2003). Microsoft Office: The Complete Reference. California: McGrawHill Osborne Media Stair & Reynolds.(2006). Principles of Information System, 7th edition. Boston: Thomson 2. Format Lecturer Lecture 2 hours per week Mr. William Lee C.C E-mail Chyuanchuan.lee@newer a.edu.my COURSE OBJECTIVES This course will help students to acquire computer and information system skills to meet essential business demands. LEARNING OUTCOMES At the end of this course, student should be able to: 1. Understand the basic elements of computer systems. 2. Compose documents using common word processing software, i.e. MS Word. 3. Use common spreadsheet software, i.e. MS Excel 4. Create and manage database for information organization, i.e. MS Access. 5. Make use multimedia software for presentation, i.e. MS PowerPoint. LECTURE SCHEDULE WEEK TOPICS Introduction to computer and devices 1         History of computers What is a computer? What does a computer do? What are the components of a computer? Input Devices Central Processing Unit Memory Output Devices ¨ printers and computer screens  Storage devices Computer Software & Networking  Computer software ¨ system software and application software  Viruses and spy ware CHAPTER 1 ACTIVITY 2 1&2 Assignment 1 briefing BCOM 101F PAGE 1 OF 3 3 4&5 6,7 & 8  Networking Internet Technology  History of Internet  Introduction to Internet  Facilities and services  Browsers...

Words: 1095 - Pages: 5

Free Essay

Khjkh

...storage, server and virtualization architecture with knowledge of TCP/IP and WAN and LAN concepts ➢ Documentation and knowledge management strategy and implementation (PER, Reports, Execution Status, Delivery status report) ➢ Hand-on experience with hardware configuration and troubleshooting worked with many vendors and coordination with many engineers ➢ Worked closely with client team and conduct training for the users ➢ Hands on experience in user documentation (user manual, help documents, tutorials, instruction manual and FAQ) ➢ Worked as a trainer for the juniors and provide training on Networking related subjects and soft skills training ➢ Worked closely with development and functional team for initial documentation of complex enterprise software. ➢ Outstanding interpersonal and communication skills. Ability to analyze technically complex situations and to develop & execute solutions. ➢ Excellent skills in MS Word, Adobe Acrobat, PowerPoint, MS excel and MS project planning. Qualification Highlights ▪Cisco Certified Network Associate ▪Project Planning and Execution ▪Large Scale Network Engineering and Management ▪Network Analysis and Support Professional...

Words: 1029 - Pages: 5

Premium Essay

Answers

...years, other office suites have emerged or re-emerged to challenge its dominance. Chief among these competitors is OpenOffice, which is a product of Sun Microsystems, a multibillion-dollar company that makes computers, software, and Java The Price Tag • The element that most clearly separates the two suites is that Open Office is free. You can download it directly from Sun, order it on a CD or obtain it from a peer-to-peer network such as Bit Torrent. If you have a Linux operating system such as Ubuntu or Fedora, you can download it using their software package managers (which will also keep Open Office up to date for you). Meanwhile, MS Office must be purchased on a CD or DVD, although you can buy it pre-installed when you buy a computer from a company like Dell or HP. Differing Components • OpenOffice has a set group of components, while MS Office has several versions, with the least expensive version including a word processor, spreadsheet software, presentation software and note-taking software. OpenOffice includes Writer (the word processor), Calc (for spreadsheets), Impress (for presentations), Draw (for creating images) and Base (for managing databases). OpenOffice does not include an email client or desktop publishing software. Users of OpenOffice are usually directed to Evolution Mail or Mozilla Thunderbird for their email client needs. Compatibility • OpenOffice can read and create Word-compatible documents, but Calc can have trouble properly displaying Excel spreadsheets...

Words: 506 - Pages: 3

Premium Essay

Kiniect

...Faculty of Business & Enterprise Higher Education Division Unit of Study Outline HBM222/HBM350N Marketing Planning Semester 1, 2012 Version 1 (19 February, 2012) Table of contents Unit of Study Outline 4 Teaching Staff 4 Unit Aims. 4 Learning Objectives 5 Content 5 Learning and Teaching Structure 5 Lecture Program (Provisional Schedule) 6 Tutorial Guide 7 Resources and Reference Material 8 Assessment 9 a. Assessment Task Details: 9 b. Participation Requirements - Tutorials 9 c. Minimum Requirements to pass this Unit of Study: 9 NB - Your final mark will be the sum of the marks gained in all pieces of assessment noting that to pass this unit you must achieve at least 50% in the final exam. 10  If you score between 43% and 49% in the final exam your maximum mark will be 46%. 10  If a student scores less than 43% in the final exam, your maximum final mark will be 42%. 10 d. Assessment Criteria: 10 f. Extensions and Late Submissions: 11 g. Assessment Results: 11 h. Groupwork Guidelines: 11 i. Email Communication 12 j. Plagiarism: 12 k. Assessment and Appeals Policy and Procedure 12 Ethical Conduct at Swinburne 12 Blackboard Site for this Unit of Study 13 Student Feedback: 13 Safety Standards and Conduct Requirements: 13 Special Needs 14 Appendix 1 - Guidelines for Minor Assignment (situation analysis) 15 Appendix 2 - Marking Guide for Minor Assignment 16 Appendix 3 - Guidelines for Major Assignment (Marketing Plan) 17 Appendix...

Words: 6513 - Pages: 27

Premium Essay

Everything You Wanted to Do with Msoffice

...Everything You Wanted to Do With Office...But Didn't Know How You use Microsoft Word, Excel and PowerPoint on a daily basis and are still be trying to figure out where things are and how they work, using only 10% of the applications power. Below are 101 customizations and tweaks to help you harness the power of productivity, and customize MS office to work for you. The difference between an Microsoft Office beginner and advanced user is all about knowing how to use the individual applications, and knowing how to use them well. Wondering how to use your everyday Office applications effectively? The best way is to customize them. When you learn how to customize an application the way you want it--especially when it’s a productivity tool like an Microsoft Office program, you increase your productivity and effectiveness by leaps and bounds. All you need is a guide on getting the best customizations out there. Read on and make the leap from Microsoft Office beginner to expert with the following list of resources, tips, tricks and tutorials. Microsoft Word Microsoft Excel Microsoft Powerpoint Microsoft Outlook Streamline Document Formatting Keyboard shortcut/Cheat sheets Editing Importing Fonts Exporting to Different Doc Types General Word Tips and tricks Interface Customizations Formatting Text & Numbers in Spreadsheets Templates Macros and Calculations Keyboard shortcut/cheat sheets General Excel Tips and Tricks Interface customizations Printing Exporting Keyboard...

Words: 4859 - Pages: 20

Free Essay

Lte Complete Tutorial

...(Prepared from website Radio-Electronics.com with thanks http://www.radio-electronics.com/) 3G LTE Tutorial - 3GPP Long Term Evolution - developed by 3GPP, LTE, Long Term Evolution is the successor to 3G UMTS and HSPA providing much higher data download speeds and setting the foundations for 4G LTE Advanced.. LTE, Long Term Evolution, the successor to UMTS and HSPA is now being deployed and is the way forwards for high speed cellular services. In its first forms it is a 3G or as some would call it a 3.99G technology, but with further additions the technology can be migrated to a full 4G standard and here it is known as LTE Advanced. There has been a rapid increase in the use of data carried by cellular services, and this increase will only become larger in what has been termed the "data explosion". To cater for this and the increased demands for increased data transmission speeds and lower latency, further development of cellular technology have been required. The UMTS cellular technology upgrade has been dubbed LTE - Long Term Evolution. The idea is that 3G LTE will enable much higher speeds to be achieved along with much lower packet latency (a growing requirement for many services these days), and that 3GPP LTE will enable cellular communications services to move forward to meet the needs for cellular technology to 2017 and well beyond. Many operators have not yet upgraded their basic 3G networks, and 3GPP LTE is seen as the next logical step for many operators...

Words: 18462 - Pages: 74

Premium Essay

None

...memorandum to: | Microsoft Corporation | subject: | Critique of MS Outlook Product Guide | date: | February 3, 2014 | Microsoft Outlook has become a vital part of the academic and professional experiences of many people. The application is often utilized strictly for its capacity as an e-mail client, but the program has a variety of uses. Outlook allows users to do some basic photo editing, manage tasks and add them to calendars, and also has a number of social features fully integrated into the application (“Microsoft Outlook Product Guide”, 2010). Those are just a small sample of what a trained user can accomplish using Outlook. While the wide range of features included into Microsoft Outlook is ultimately a boon for users, for it gives them a lot of options and increases the value of the programs, using the features can become confusing. When users become confused, the go-to place for clarity would presumably be the MS Outlook User Guide published and maintained by the Microsoft Corporation. As the guide provided by the company responsible for the product, it is a reasonable assumption that it would be the best source to answer any basic questions concerning any of the plethora of features included in Outlook. However, they may not be the case. The guide developed by Microsoft may not address the needs of users in the best possible ways. Therefore, it is necessary to analysis the effectiveness of the MS Outlook Product Guide by Microsoft Corp according to a set of predetermined...

Words: 976 - Pages: 4