 |
|
 |
Home »
Microsoft Access »
Functions and Expressions
::
ReportRelated Tutorials
 |
|
|
|
Microsoft Access / Functions and Expressions Action queries are queries that permit us in just one operation to perform changes on one o various rows in a table. With these queries we can create a new table including in it the records of another, change the data stored, insert new records or erase old records. Learn how to Make-table queries, Update queries, Append queries, Delete queries and Unshowing confirmation messages Site: www.teacherclick.com
|
||
|
|
|
|
|
|
Microsoft Access / Data Manipulation Queries are the stars of Microsoft Access. Queries make sense out of all the thousands of jumbled records and display exactly what you need to know. Queries discover things like what the average price of tea in China is or which customers bought the most parakeet food from your company. Queries can even make widespread changes to the records in your database without wearing out your mouse and keyboard! For example, a delete query can automatically delete a whole bunch of records that meet your criteria. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Access / Functions and Expressions A crosstab query is used when we want to represent a summary query with two grouping columns like a double input table, in which each one of the group columns is an entry, one down the left side of the datasheet and the other across the top. Learn the crosstab Query wizard and the design view of a crosstab query. Site: www.teacherclick.com
|
||
|
|
|
|
|
 Microsoft Access / Miscellaneous This tutorial covers: Types of queries, Creating a query, The Design view, Adding fields, Defining calculated fields, Forming expressions, Column headings, Changing the order of the fields, Saving the query, Running the query, Modifying the query design, Ordering rows, Selecting rows, Conditions ,Multitable queries, Joining tables and The external join Site: www.teacherclick.com
|
||
|
|
|
|
|
|
Microsoft Access / Gettings Started Introduction (Menu bars, buttons, toolbars, moving around Access),Designing Databases, Creating Tables, Creating and Using Forms, Working with Tables Working with Table Information (Adding, Editing, Deleting, Sorting and Finding Records), Creating Select Queries (Selecting Tables and Fields), Working with Select Queries (Adding, Deleting, Inserting and Moving Fields, Wildcard characters, Multiple Criteria), Creating and Using Reports, Enhancing Forms and Reports |
||
|
|
|
|
|
|
Microsoft Access / Gettings Started As done for the tables and queries, Microsoft Access provides a central dialog box you can use to create forms: this is the New Form dialog box. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Access / Data Manipulation We have used the concept of a query so far only to create a list of fields that would be considered for a set of records. We also mentioned that a query in Microsoft Access is simply a means of visually representing data. Indeed, a query is based on a SQL statement. As SQL is its own, fully functional language, we can use it to perform far more operations than to only select columns for a query. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Access / Miscellaneous It's easy to print a simple list of records in a table or query just click the Print button on the toolbar. But if you want your printed hard copies to look professional and include calculations, graphics, or a customized header or footer, you'll need to create a report. Reports present information from tables and queries in a format that looks great when printed. Site: www.brainbell.com
|
||
|
|
|
|
|
|
Microsoft Access / Data Manipulation Data analysis provides the user with the ability to examine a database's records and the overall behavior of its objects. Data analysis is performed on tables, queries, and/or forms. There are two main aspects involved with data analysis: what you provide to the users and what the users may decide to do with data at their disposal. An intermediate to advanced user of Microsoft Access will know how to perform some, most, or all of the operations we will review. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Access / Data Manipulation So far, to create a query we have learned to use either the Query Wizard or the Design View of a query. In both cases, we were selecting fields and adding them to the query. This concept of building a query is based on the Structured Query Language abbreviated SQL. In fact, all queries are based on SQL and this language is used by most database development environments, including Microsoft Access. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Access / Data Manipulation When creating relationships among tables, we were selecting the primary key of one table and the foreign key of a dependent table to join them. Once such a relationship is created, you can create a query that combines both tables to create a set of records, also called a record set, or a Recordset, that would include either all records or isolate only the records that have entries. Site: www.functionx.com
|
||
|
|
|
|
|
|
Microsoft Access / Gettings Started When examining records on a database, some tables are so wide the user would need to scroll left and right to see fields one screen at a time. Sometimes, the user does not need to see all fields all the time. Microsoft Access allows you to temporarily hide unneeded columns. This feature does not delete records or columns; it only hides them and can display the columns as needed. To hide columns, you have two options. Site: www.functionx.com
|
||
|
|
Site Search
Categories
Adobe Fireworks
Adobe Flash
Adobe Illustrator
Adobe Image Ready
Adobe Photoshop
3D Studio Max
Cinema 4D
Maya 3D
Microsoft Excel
Microsoft PowerPoint
Microsoft Word
Microsoft Access
MySQL
C and C++ 
Python
Visual Basic
.htaccess
Adobe DreamWeaver
ASP
CGI & Perl
CSS
Java
JavaScript
Microsoft FrontPageAdvertisement
|
|