Welcome, Guest: Register On Nairaland / LOGIN! / Trending / Recent / New
Stats: 3,194,025 members, 7,953,065 topics. Date: Thursday, 19 September 2024 at 10:11 AM

Form Operations And Some Powerful Built In Functions In Ms Access 2016 And 2013 - Computers - Nairaland

Nairaland Forum / Science/Technology / Computers / Form Operations And Some Powerful Built In Functions In Ms Access 2016 And 2013 (1149 Views)

Guides On How To Design Professional Reports In Ms Access Using Various Methods / Business Application Of Ms Access Query Functions In Students Gradelist System / Business Application Of Ms Access Query Functions In Workers’ Payroll System (2) (3) (4)

(1) (Reply)

Form Operations And Some Powerful Built In Functions In Ms Access 2016 And 2013 by microsofttutor(m): 3:57am On Jan 14, 2017
INTRODUCTION TO FORM, AN OBJECT OF ACCESS DATABASE
Source: http://www.microsofttut.com/2017/01/forms-manipulations-and-some-powerful-built-in-functions.html
Forms are very important when designing practical and functional applications in Microsoft Access because they enable you to easily gather data your customers or visitors input.
FORM
This is one of the objects of a database that is used to enter, edit, view tables, and query data. It is also used to perform calculations. The field that holds the calculation is called the Calculation Field. On a form, each field has its own text box.
Forms are based on tables or queries, and they are used for entering data into the database in a user-friendly manner. They are also used for displaying data to the end user and can be used to create a menu system for the database.

This chapter’s tutorial is split into 3 parts. This is the part 1.
In this part, I will explicitly explain all the operations of data forms and some powerful built in functions in MS Access 2013 and 2016.
USES OF A FORM
Here are some basic uses of a form in MS-Access:
1. Forms are mainly used for three things: editing data, viewing data, and creating a menu system. But in this chapter we will focus on how we use forms to facilitate entering data and viewing database data. Without forms, you would have to enter data directly into tables, which is usually more difficult.

2. Forms used for entering data and viewing data are built directly from tables or queries and provide a custom way to view, interact, edit, add, and delete the data in real time. It is important to understand that there is a direct “connection” between the form data and the table data. Any change you make to data on the form is actually modifying the table data at the same time.
BASIC PRINCIPLES IN BUILDING A FUNCTIONAL FORM IN MS ACCESS
Here are some basic user interface design principles to keep in mind when designing and building forms:
• Forms should have a consistent look and feel.
• Text on forms should be easy to read.
• Forms should be pleasant to look at and easy on the eyes.
• Functionally, forms should display all relevant information in a logical fashion.
• Forms should employ intuitive and consistent navigation.
• The layout and design of forms should reflect the way the end user works with the form data.
TIP:

To save time when building forms, the primary challenge is to make sure it works! Once the form is working properly, you can make necessary adjustments to the design. I suggest this method because you can waste a lot of time struggling with your form design just to discover later that it is not functional.
SOME BASIC TYPES OF FORMS IN MS-ACCESS
While considering how the end user will be working with the data, you also have to decide what type of form to create. There are four basic types of forms in MS-Access. They are:
1. Basic Forms:
They display one record of data on a form at a time.
2. Multiple Item Forms:
display multiple records of data at the same time. These are also referred to as Continuous Forms.
3. Datasheet Forms:
They display the data records in a datasheet view making the form look and function exactly like a table.
4. Split Forms:
They are like a combination of a Basic Form and a Multiple Item Form all wrapped into one big form. On a Split Form, you can view a single record in its entirety and also view multiple detailed records of data at the same time. Split Forms are so named because you can view and interact with the data in two ways simultaneously.
NOTE:

In a Microsoft Access database, you can choose to build a combination of Basic Forms, Multiple Item Forms, Datasheet Forms, Split Forms. Basic Forms, Datasheet Forms, Multiple Item Forms, and Split Forms are fundamentally the same to work with and build, except they allow you to interact with the table data in different ways.
VARIOUS COMPONENTS OF A DESIGN VIEW FORM WINDOW
The diagram below shows the various components of a form window.
Click http://www.microsofttut.com/2017/01/forms-manipulations-and-some-powerful-built-in-functions.html to study the full tutorial.
See also:BUSINESS APPLICATIONS OF MS ACCESS BUILT IN FUNCTIONS TO SALES REPORTS AND STOCK REPORTS at http://www.microsofttut.com/2017/01/business-applications-of-ms-access-functions-to-sales-and-stock-reports.html
See also: BUSINESS APPLICATIONS OF MS ACCESS BUILT IN FUNCTIONS TO STOCK CONTROLS AND BUDGET CONTROLS at http://www.microsofttut.com/2017/01/business-applications-of-ms-access-functions-to-stock-and-budget-controls.html

(1) (Reply)

How To Reset Your Forgotten Windows Password / Very Cheap Usa Used Hp Elite Book Core I7 For Jst 50k / Dell XPS 13 Spec, Features & Price In Nigeria

(Go Up)

Sections: politics (1) business autos (1) jobs (1) career education (1) romance computers phones travel sports fashion health
religion celebs tv-movies music-radio literature webmasters programming techmarket

Links: (1) (2) (3) (4) (5) (6) (7) (8) (9) (10)

Nairaland - Copyright © 2005 - 2024 Oluwaseun Osewa. All rights reserved. See How To Advertise. 13
Disclaimer: Every Nairaland member is solely responsible for anything that he/she posts or uploads on Nairaland.