Range Searches are often used to search for something that is before or after (or equal to a certain value)
The Symbols used are < > <= >= And For example, if i wanted to search all data before 01/05/2009, i would type in the query ">01/05/2009" OR Searches are designed so that you can search for more than one value in a field.
Lets say i wanted to search different countries in a field, i would write "Germany" then add an "Or" which means you want to search more than one thing. so to also search for Spain and France i would put "Germany" Or "Spain" Or "France". This is how to search for multiple things at once, a very helpful feauture A Wildcard search is a different and unique type of search present in Microsoft Access.
There are certain symbols that you must use to do a wildcard search. An * means any number of Characters A ? means only one Character eg. ??? means three Characters REMEMBER: You must put "Like" before what you wish to type in! These are often used to search for things that start, end with or contain certain characters of Values. For Example, if i wanted to find something starting with 37, i would type in the field "Like "*37*". When Importing
1. Remembering to click on the IMPORT links, not export! 2. Remember that a CSV is a TEXT file 3. Click “First row contains column headings” in the import wizard 4. Remember to CHECK and select the correct data types! 5. Select a field as the primary key IF it is described as UNIQUE, otherwise select “No Primary key” 6. Check your table in DESIGN view after the import and fix any remaining formatting errors When making queries 1. SAVE AND CLOSE the query before doing a calculation 2. Remember the query criteria is written “show only the fields…” in the exam question When making reports 1. Remember to select the query in the report wizard, step 1 2. Remember to select landscape/portrait and any sort options 3. To get rid of # symbols, resize the fields in design view 4. Use CTRL as a shortcut to highlight two boxes at once 5. USE LABELS FOR YOUR NAME!! First, go into the design view. Pull down the 'Report Footer' Box. Insert a text box into the Report Footer, and click on the 'Text Box'. Type in what you want eg. Total cars for France and in the other box write =count(*). This will add up all of the data in the field. If you can see your text in the report.
=count(*): Counts all data in a field. =sum([Name of Field]): Adds up all data in a certain field. When you first load up your report, you will be in a 'Print Preview' View. Close this view and look at your report. If you can't see all of your data and it is replaced '#', go to design view. Expand the Fields, Rezise and move the field names so that you can see the data and fit it into a certain place that looks good. You may also want to add some new fields. If so, select 'text box'. REMEMBER! Text box is the second icon along the top, labels is the third one across.
Once you have done this you should be able to see all of your data in the correct place. If so, well done as you have succesfully done the task. First, create a new document. Choose a sensible name for your database and pick a location for it to be saved to. Then, go to the 'External Data' Tab and Select the type of file you will be imputing. I will be using a CSV File, which is Text. Make sure you know where the file your importing is located. When you see your Data appear simply click next. If your file already has subheadings, Tick the 'First Row Contains Field Names' Box. The Picture below shows a screen where you can select datatypes for your data. Check to see if these are correct. If not, correct them.
Before your create a Report, you must create a Query.
Creating Calculated Fields
I believe data is information stored in a computer.
Actually, Data is Meaningless. It is simply characters, symbols, numbers, dates or images. One Method of adding meaning and context to data is to give it a data type. Examples of Data Types are: Real Text Boolean Image Dates Integer Currency Text, String and Alphanumeric: Boolean: Can only be stored in one of two values. It is almost like thinking of something being On or Off. Examples are: Real: A Number with a Decimal Places eg. 3.14159, 18.01, 12.4 Integer: Whole Numbers, no Decimal Places eg. 37, 1337 Date: These can be stored in many different forms. In the UK, we use DD/MM/YYYY. America uses the format MM/DD/YYYY. Some examples include 24/06/2000, 3/9/1939 |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |