Customizing Dropdown Lists and Detail Forms in Designer for Microsoft Access created databases

March 11th, 2010

This tutorial shows you how to further enhance the default dropdown lists created by Designer for Microsoft Access in your new database, and how to add a button to launch another form to display detailed information related to the record you are viewing.

Duration : 0:8:49

Read the rest of this entry »

How do I Change a dependent in an Access 2003 report?

March 9th, 2010

I want to change the table an access 2003 report depends on with out recreating the report. How would I go about doing this?

Hi, try the following (this works for 2002 I don’t have a copy of 2003 to hand but assuming they’re the same):

1. Open the report in design view.
2. Right click on the grey area (the blank area to the side of where your actual report is) of the report and select properties. OR click on the properties icon in the toolbar.
3. You should get a popup box with some tabs, Format, Data, etc.
4. Click on the Data tab.
5. Select the new Data Source for the report in the top dropdown.

If your new data source fields are named differently to the existing ones you will need to change the control source of the text boxes that display the values.

You can do this by right clicking on any that need changing and selecting properties, on the Data tab you can select the Control Source from a dropdown list (the field that holds the data you want to show).

Hope this helps, Graham

Examples of access control methods, please help?

March 9th, 2010

i will give full points for a detiled answer

hi ya

See Your answer Below

—————————————————————
Using Access Control Methods

In order to protect assets in a company or corporation, security analysts and programmers can set access control to individual components on a computer. These components can be the operating system, programs or even hardware settings. It is a necessary function that many end users often see as a burden.

Access control can be used with the following items when implementing security:

* Objects – Files or hardware settings (restriction of network settings, usb ports or individual files and folders)
* Subject – a process function (such as opening a file or folder or program) a subject can be an end user
* Operation – is the process of an end user trying to modify or delete an object

Access Control Models

There are four major access control models that should be embedded within applications for access control to prevent malicious users from accessing key functions within an application. These access control models are:

* Manadatory Access Control known as (MAC)
* Discretionary Access Control (DAC)
* Role Based Access Control (RBAC)
* Rule Based Access Control (RBAC)

Because individuals are assigned roles in a relationship with access control objects and / or resources, these users are defined as Owners, custodians, and end users.

The owners are ultimately assigned the responsibility for a file (data integrity) and may delegate how other users use a file. The custodian reports to the owner and can review the security of the individual object. The end user uses and opens the file(s) or objects and ‘uses’ it.
Mandatory Access Control

The process is when the owner (above) defines a policy or policies that can strictly define the end user and their use of programs or files. Because MAC is typically used in the defense industry, this ensures that documents or files are secured.

Note: CompTIA along with other vendors teach these levels of access controls methods. Certifications offered by these vendors are 8570.1 complient to meet DoD (Department of Defense requirements).

Discretionary Access Control

This access control is the least restrictive and allows total control of objects. This allows users to change permissions and have control over objects as defined above. This can pose security risks and threats if used improperly. This control allows the end user to set the proper protection and settings. Programs such as Microsoft’s Windows Vista and other operating systems now prompt users before actions are taken on programs. Most individuals overlook the fact that the UAC (user account control) is color coded and can give prompts with a color indicating the risk level involved.

Role Based Access Control

Role Based Access Control is an approach that is more realistic and aligned with most business models. Analyst and administrators look at the actual role that the end user will be taking. This approach to security ‘looks’ at the end user and defines what they can or cannot do.

Rule Based Access Control

Rule Based Access Control allows for the dynamic assignment of an end user’s processes. If an end user tries to access a program or object, the system checks the individual’s role and the rules assigned for that individual and object.

So what does all of this mean?

Administrators, programmers and analysts must look at a set of best practices in security for their organization. These ‘leaders’ in information technology must look at the separation of individual job duties, a minimum set of priviledges and make sure that end users are trained and educated in security. With assets going online with e-commerce, small businesses as well as enterprise level businesses must implement extreme means of security to ensure their information and data are protected.

Think u got all the answer
n i get fuullllll point
hehee
all right
cheers

Access Virginia Beach for February 12 – 18

March 8th, 2010

Show V21#29 AV395510 02/12/10

Governors funding change impacts school division budget
City conducts homeless count
City has one of the lowest violent crime rates in the nation
Police Dept. hosts gang prevention workshop
Senior Citizens Police Academy
Adult Learning Center offers Senior Open House
School Board seeking candidates for At-Large seat
Career & Tech. Education Center hosts Dental Day

Parent Connection PSA

Princess Anne Rec. Center offers assistance ramp for pool
Rec. Centers offer spring break camps
Contemporary Art Center offers art camps
February exhibit at Old coast Guard station honors African Americans
Scholarship Central helps students find scholarship money
Bayside Elementary uses Education Foundation grant to help homeless
Bayside Middle School theater students get helping hand from professionals

Pet of the Week: 7 month old Beagle

Duration : 0:21:16

Read the rest of this entry »

Microsoft Access 2003 Tables

March 8th, 2010

Introduction to Data Tables in Microsoft Access 2003

Duration : 0:9:37

Read the rest of this entry »

Access 2003 Tutorial Creating Custom Toolbars Microsoft Training Lesson 19.2

March 8th, 2010

Learn how to create a custom toolbar in Microsoft Access at www.teachUcomp.com. Get the complete tutorial FREE at http://www.teachucomp.com/free – the most comprehensive Access tutorial available. Visit us today!

Duration : 0:4:1

Read the rest of this entry »

Cisco CCNA CCNP Exam Tutorial Access Servers Pt. 1

March 8th, 2010

There are several misconceptions about Cisco access servers and their role in a CCNA / CCNP home lab. In the first part of a two-part series, Chris Bryant, CCIE #12933, explains the purpose of an Access Server and clears up some misconceptions regarding these important Cisco home lab devices. Part 2 will show you how to configure an AS. Enjoy!

For over 200 free Cisco and Microsoft illustrated tutorials, videos, practice exams, and more, visit http://www.thebryantadvantage.com/Tutorials.htm.

I also post free Cisco training questions and tutorials daily on my blog, http://thebryantadvantage.blogspot.com/.

Duration : 0:7:36

Read the rest of this entry »

Access 2007 Tutorial Designing Queries Microsoft Training Lesson 7.2

March 8th, 2010

Learn how to design a query in Microsoft Access at www.teachUcomp.com. Get the complete tutorial FREE at http://www.teachucomp.com/free – the most comprehensive Access tutorial available. Visit us today!

Duration : 0:7:41

Read the rest of this entry »

DECOUPAGE! 2000. Part 6 of 9: “Karen Black & L7 – Bang Bang”

March 8th, 2010

Karen Black performs “Bang Bang” with she-rockers L7!
Decoupage! 2000 with Summer Caprice. Public access from 1997. Come visit us at www.decoupagetv.com

Duration : 0:3:15

Read the rest of this entry »

Pogoplug: Access Your Files Anywhere, Jupiter Jack: …

March 8th, 2010

The Best Version of Windows! Pogoplug… can you build a personal DropBox and access your files on the road? Boot Any Linux Distro Live, Is SCSI Dead? How good is a $10 hands free device? We review the Jupiter Jack. Help putting your microphone in the right place for better sound! Should you avoid Swoopo and BidRival?

Duration : 0:36:48

Read the rest of this entry »