Looking for:
Microsoft access 2016 step by step pdf free free. MICROSOFT ACCESS STEP BY STEP GUIDE- Microsoft access 2016 step by step pdf free free
In this question the query needs to search the database in 2 ways: 1. Includes a field called Order which is calculated at run-time and multiplies the Price field by 3. What is a report? A report is a method we use to display our information in the clearest way possible.
Reports are essentially the output of the database. The report in this question only wants us to display information that meets certain criteria and, therefore, we also need to create a query. In short: Any tasks which sound like you need to search for information are tackled within the query. Any tasks which sound like they are talking about the display of the information should be tackled within the report. Creating the query How to do it: 1. Click Create and then Query Wizard.
On the next screen, you should make sure that tblkites option is selected. Use the arrows to move the fields from the Available Fields: window into the Selected Fields: window.
Select the Detail show every field of every record option then press Next. If the task required a summary of data then you would choose Summary 5. Choose a name which suits the task. I suggest Kites Order Query. Select the Modify the Query Design option.
This lets us create our searches. Click Finish. This takes us to the Query Design screen and from here we can tell Access which data we would like to search for: Query Design P a g e This field will calculate the Price multiplied by 3 Calculated fields only work during run-time. This means that the calculation is made as the query is activated or ran.
In query design view find the Stock Item field. Click the mouse cursor into the empty field to the right of Stock Item. The Order field will store the result of the [Price] fieldmultiplied by 3. Breakdown of what is happening here: This tells Access what to name the new field This tells Access which current field to use in the calculation P a g e 18 This tells Access which mathematical calculation to use.
Run the query by clicking the Datasheet View button. Your query result will be displayed with a calculated field called Order that contains the Price field multiplied by 3. Order field multiplies the contents of the Price field and displays P a g e Has the Order field set as currency with 2 decimal places 1.
To do this, right click the query and then select Design View. Highlight the Order field then right click and select Properties. In the Properties Sheet change the Format to Currency by using the drop-down list. Run the query in Datasheet View and check to make sure that your Order field is set to Currency. NOTE: Currency fields should be set to 2 decimal places by default. Shows only the records where Number is less than 2 and Stock item is Yes 1.
Click in the Criteria: section of Number field: 3. Click in the Criteria: section of the Stock Item field: 5. The question wants us to search for records where Stock Item is Yes.
To do this simply type Yes into the criteria box. Run the query in Datasheet View and check to make sure that the database has only returned records that match our criteria Number less than 2 and Stock Item of Yes. Sorts the data into ascending order of Make with Airush at the top Once we have our completed query we can take this information and display it in the form of a report.
Click Create and then Report Wizard. On the next screen, you should make sure that Kites Order Query option is selected. Press Next and the Next again. In the Sort Order section, use the drop-down box to select the Make Field.
Make sure that it is set to Ascending Low to High. Click Next. Landscape page orientation: 4. Choose a report name which suits the task I chose Kites Order Report. This lets us customise our report. Showing all fields and labels and making sure the report fits onto a single page: 1. You should be in Report Design View. If I ran this report in Report View you will see what I mean. Click the drop down arrow on the View option and select Design View. This lets us make the required changes.
Click on the Make field and drag the handles out to create more space for the information. Click back on Report View to make sure that the field has been resized enough to hold all of the information.
It looks okay. Continue doing this until all of the fields are just the right size to hold the information. You may need to reduce the size of some of them if they are too large. NOTE: Fields can also be resized to make them higher instead of wider. This is useful to force longer pieces of data onto a new line and, therefore, take up less room widthways.
This will make them easier to read. Move the cursor into the Page Header section and click on the ID label. Centre the label using the Centre Alignment tool in the Design tab. Repeat this for the ID field in the Detail section. Use the same techniques to re-align the other problem areas in the report. Much neater layout P a g e Calculate the total value of kites to be ordered and: o Shows this total at the bottom of the Order column o Formats this total value to currency with no decimal places o Has the label Total order value for the total value.
To add a total to the report you will insert a text box into the Report Footer section. By default the Report Footer section is hidden from view and so you have to create some room for the text box. Creating some room in the Report Footer. Position your cursor to the bottom of the Report Footer bar so that the cursor changes to an arrow. Hold the left mouse button down and drag the Report Footer row down a little bit to make some room.
In the Design section click the Text Box option. Draw the text box into the Report Footer underneath the Order field. Make sure the report is open in Design View. Click the text box which contains the calculation. In the Design section click Property Sheet. The Property Sheet for the text box will open. You should make sure that you are in the All section. Find the Format setting and use the drop-down box to select Currency.
Use the Decimal Places setting to select 0. Close the Property Sheet and click in the label for your calculated field. Change the text to Total order value. Resize or move label if necessary 3. Run the report in Report View and scroll to the bottom. Your calculated field and label should appear.
Includes the heading Kites we need to restock at the top of the page. Move the cursor into the Report Header section. Click in the heading label we currently have and delete the contents. Type in the required text Kites we need to restock. Has your name, Centre Number and Candidate number on the left footer of each page.
Move the cursor into the Page Footer section. In the Design section click the Label tool. Type your name, Centre Number and Candidate number into the label. Use Report View and scroll to the bottom of the page to check that the required information is fully visible. It should look something like this: Save and Print this report.
Fit two side by side on the page 2. Displays the field name as well as the data 5. Are sorted into ascending order of Size 6. Include the heading Special offer for kite surfers at the top of each label 7. This task, again, requires you to produce a query that searches for the required records described in task 2 of Q The rest of Q39 can be tackled in the process of making the labels.
Creating the query How to do it: NOTE: The question clearly requires you to make the labels based on all the data so you should ensure that the query is sourcing tblkites and not your Order query. Selected Fields Available Fields Arrows 4. If the task required a summary of data then you would choose Summary 6. I suggest Labels Query. Open the Labels Query in Design View. Click in the Criteria: section of the Use field.
Any record containing the words Kite Surf will be returned. Wildcard searches should be used as the criteria for any search questions that ask you to find records that contain specific words. Type Yes into the Stock Item criteria field. Type Not Beginner into the Skill Level criteria field. In this example there were 3 types of record held in the Skill Level field: Beginner Intermediate Experienced Including Beginner within the Not criteria excludes it from the search and Access will only look for records containing Intermediate and Experienced.
Access will now search for the records that match all 3 of the search criteria that we have created. Fit two side by side on the page 3. Are sorted into ascending order of Size Labels are a special kind of report. They are designed to provide a short, summary of information and you are usually required to fit two labels side by side.
Click on the Labels Query without opening it. Click Create and then Labels. Fitting 2 labels side by side 1. The task asks you to fit two labels side by side so select an option where the number across is 2. Label Type option should be Sheet Feed. The next screen allows you choose font styles and sizes but the task does not specify any formatting so it would be advisable to leave this alone. Type the field name Make into the Prototype Label window with a space at the end of the letter e.
Space after the letter e 2. Click on the Make field and use the arrow to move it into the label. Make field inserted into the label after the field name we added 3. Press enter to move the cursor to the line below. Ascending means From low to high. This means that the data will be sorted from the lowest kite size to the highest. Click on the Size field and use the single arrow to move it into the Sort By: window. By default, Access will sort the field into Ascending Order.
Single Arrow Click Next. Choose a suitable name for the label I suggest Kites Labels. Select the option See the labels as they will look printed and click Finish. Your labels should look something like this: Field names as well as the data Each field on a separate line All records sorted into ascending order of size Ammending the label s heading and footer How to do it: The problem: Produce labels from all the data which: 6.
Include the heading Special offer for kite surfers at the top of each label. Have your name, Centre number and Candidate number at the bottom.
Your label should be switched into Design View: 2. For information that you only want to display ONCE at the bottom of each page. For information that you want to display over and over. For example every piece of information should be displayed one after the other until we have nothing left to show. Because our heading needs to be displayed at the top of EACH label we need to insert a label into the Detail section.
Before we can insert a heading at the top of each label we need to create some room. Click and drag around each of the fields to select them. Drag the fields down a little bit to create some space at the top of the label. Click Design and then select the Label option. Draw your label in the Detail section, just above the fields. Type your heading into the label Special offer for kite surfers.
Repeat this underneath the label with your Name, Centre number and Candidate number. Expand the View menu and select Print Preview. The final labels should look something like this: Save and Print the Labels. Course material to download for free on Introduction to Access category Database. This course is intended for a strictly personal use, the file is of format pdf level Beginner , the size of this file is You have to come and see our Database. You will find your happiness without problem!
Download free an introduction to MS access , course material, tutorial training, a PDF file on 18 pages. Free courses and tutorials to download for free as PDF files. Introduction Microsoft Access allows people to effectively and efficiently organize data.
All you need to do is download the training document, open it and start learning Access for free. This tutorial has been prepared for the beginners to help them understand basic Access Office. After completing this tutorial you will find yourself at a moderate level of expertise in Access from where you can take yourself to next levels.
Comments
Post a Comment