Want to create or adapt books like this? Learn more about how Pressbooks supports open publishing practices.
Access Practice 1
Here is a video demonstrating the skills in this practice. Please note it does not exactly match the instructions:
Complete the following Practice Activity and submit your completed project.
Since Microsoft Access is widely used in industry, and we are using Microsoft Win dows, we will focus on this DBMS going forward. There are many similarities across database systems, so the skills we are learning can be translated to other systems. The following ‘Practice It’ assignments are designed to be completed using Microsoft Access in Office 365 on a PC with Windows 10 or higher. You may need to download the Professional version of Office 365 (which is free to students) to view Access.
We will use Access to analyze, design, and create a database to extract, sort, calculate, and report business data. Since Access is used for Data Analysis, it is best to use a keyboard and mouse or touchpad rather than the touchscreen.
In Access, data is stored in Tables. This is the foundation of the database. Tables can be related to one another to create a relational database, which is a robust database. Each table row contains a record, and each table column is a field.
For our first assignment in Access, we will use a database template to become familiar with database structure including tables, forms, queries and reports.
- Start Access. In the search for online templates box, type Students and then press Enter. If you receive an error message, ensure you are connected to the Internet.
- Select the Students template database. Name the database Lastname_Firstname_Access_Practice1. Click the folder icon next to the file name to save the database in your Access folder. After you name the database, click create. Access is different from other software since you must give the file a name before you start entering information.
- It may take a few moments for the database to load. If a Welcome window opens, you can close this. If a yellow bar displays across the top of the database, select Enable Content.
- In the navigation pane, click the shutter bar once to close the Navigation Pane. Click it again to open it. The shutter bar looks like two arrows pointing to the left on the navigation bar.
- In the Navigation pane, click the downward pointing arrow next to All Access Objects. Ensure Object Type and All Access Objects are checked.
- Notice how the Student List is the current open Access Object. On the Home Tab, in the Views Group, choose the arrow below Views. Notice how Form View is selected. Change the view to Layout View , and notice the change in the object window. Then change the view to Design View , and notice the change in the object window. Return view to Form View.
- Close the Student List from by clicking the x in the object window. Take care to not close the entire database, rather only close the open object. The database window should be empty.
- From the navigation pane, under tables, double click the Students Table. On the Home Tab, in the views Group, click the arrow under View. Notice how the table opened in datasheet view.
- The ID field name has autonumber as the data type . This means that the ID will be automatically assigned, and you do not have the option to type it in. Ensure you are on the Fields tab under table tools.
- The Last Name field has a data type of short text, so you can enter a value here. Under Last Name, type in your last name and then press tab. Notice when you press tab the ID changes from (New) to a number.
- In the First Name field, type your first name and press tab. Continue to enter data for the E-mail address, and Student ID. You can make up data for these values. Notice how Level is a drop down box.
- On the Home Tab, in the Views group, change the table view to Design view. Notice the Fields Names and Data Types. These are the two required attributes to add a new field.
- Close the Students table. Notice how a warning to save did not pop up. Changes to tables in Access save automatically. Double click the students table to open it and view the data you just entered. Then, close the table.
- From the navigation pane under Queries, double click the Students Extended query to run it. The query opens in datasheet view and displays the query results. You should see the record you added on the Students table.
- On the home tab, in the Views group, change the View of the table to Design View. Notice the Students table in the upper portion, and the query grid with fields in the bottom section.
- Close the Students Extended query.
- From the navigation pane under Forms, double click the Student List form to open it. Notice how it opens in Form View.
- You should see the record you added to the Students table.
- Under the first name field, the left of (New) enter data for First Name, Last Name, and email. You can enter any data.
- On the Home Tab, in the Views group, change the View of the Form to Layout View. Notice the changes in the Object Window. Then change the view to design view and notice the changes in the Object Window. Close the Students List object.
- From the navigation pane under Reports, double click the All Students report to run it. You should see the two student records you added.
- On the Home Tab, in the Views group, change the View of the Report to Print Preview. Notice how changes to the report cannot be made in this view. Click the red X to Close Print Preview and return to Report View.
- Change the view of the report to Layout View. Notice how if a field is selected, you can move it and rearrange it within the report.
- Change the view of the report to Design view. This is also known as Developer’s view because it is the most powerful view. Anything can be modified in this view. Close the report without saving changes if prompted.
- To exit out of the database, first close any database objects that are open. It is good database practice to only have one database object open at a time. Select the File tab, and take note of where your database is saved. Then select close. Ensure your database is saved in your Access folder. Then, exit out of Access.
- Submit your entire database for grading per your instructor’s instructions.
Intro to Microsoft Office Copyright © 2021 by Abby Rusu & Maricopa Millions is licensed under a Creative Commons Attribution 4.0 International License , except where otherwise noted.
Share This Book
- Engineering & Technology
- Computer Science
Practical Exercises Microsoft Access
Related documents.
Add this document to collection(s)
You can add this document to your study collection(s)
Add this document to saved
You can add this document to your saved list
Suggest us how to improve StudyLib
(For complaints, use another form )
Input it if you want to receive answer
September 3, 2024, update for Access 2016 (KB5002633)
This article describes update 5002633 for Microsoft Access 2016 that was released on September 3, 2024.
Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016. It doesn't apply to the Office 2016 Click-to-Run editions, such as Microsoft Office 365 Home. (See What version of Office am I using? )
Improvements and fixes
This update fixes an extended range of supported characters that are displayed incorrectly in a Microsoft Access hyperlink field when they're pasted into an Access rich text field or other Microsoft Office applications.
How to download and install the update
Microsoft Update
Use Microsoft Update to automatically download and install the update.
Download Center
This update is also available for manual download and installation from the Microsoft Download Center:
Download update 5002633 for 32-bit version of Access 2016
Download update 5002633 for 64-bit version of Access 2016
If you're not sure which platform (32-bit or 64-bit) you're running, see Am I running 32-bit or 64-bit Office? Additionally, see more information about how to download Microsoft support files . Virus-scan claim
Microsoft scanned this file for viruses by using the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to it.
Update information
Prerequisites
To apply this update, you must have Microsoft Access 2016 installed.
Restart information
You may have to restart the computer after you install this update.
More information
How to uninstall this update.
Windows 11 and Windows 10
Go to Start , enter Control Panel in the search box, and then press Enter.
In the Control Panel search box, enter Installed Updates .
In the search results, select View installed updates .
In the list of updates, locate and select KB5002633 , and then select Uninstall .
File information
The English (United States) version of this software update installs files that have the attributes that are listed in the following tables. The dates and times for these files are listed in Coordinated Universal Time (UTC). The dates and times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and times may change when you perform certain operations on the files. x86
IMAGES
VIDEO
COMMENTS
CSC 110: Introduction to Computers Learning Unit 10: Access Assignment Page 1 of 3 Microsoft Access: Create a Database - Forms, Reports, and Queries In this exercise, you will create a database that includes a table, form, report, and queries The College for Advanced Studies seeks to provide a quality education to each of its students.
Learn how to build a database without writing code or being a database expert using Access templates, queries, forms, and reports. Follow the steps to create a blank database or import data from Excel.
Learn how to create, add data, and organize an Access desktop database from scratch or a template. Find out how to import or link to data from other sources and use the Table Analyzer to normalize your data.
Learn how to import, modify and run queries in Access database using the Query Wizard and Design tools. This assignment involves a bakery order data file and criteria for chocolate chip and pecan cookies.
Learn the fundamentals of Microsoft Access 2019 in a step-by-step and hands-on fashion with this textbook. It covers topics such as tables, queries, forms, reports, macros, and relational databases.
Ms Access Practical Questions - Databases
This article provides a basic overview of the structure of an Access database, including tables, queries, forms, and reports. It also explains how to use the Database Documenter tool to explore the details of each object in a database.
Learn how to create a new database in Access and set it up for data entry. Follow the steps to name, design, and save a database for business card information.
Follow the directions, then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum. Open a new Access database and save the new Module 14 assignment file to the Rowan folder on your desktop as BA132_LastName_QueryDB.accdb, replacing "LastName" with your own last name.
Assignment Instructions: 1. Create a New Blank database in which to store all the objects related to the gift shop data 2. Name the Access file as your last name in all lowercase letters. (For example, Janet Learner would save her file as "learner.accdb") (Be sure to name the database before hitting the "Create" button) 3. In Design ...
Learn how to use Access components such as tables, queries, forms, and reports with this assignment. Create a database for a fictional university and add data, queries, forms, and reports.
Select the Students template database. Name the database Lastname_Firstname_Access_Practice1. Click the folder icon next to the file name to save the database in your Access folder. After you name the database, click create. Access is different from other software since you must give the file a name before you start entering information.
Assignment: Modify Access Database. In the previous module's assignment, you created the beginning of a database. In this assignment you'll work with an existing database with business card information and use the skills you have learned in this module. To complete this assignment, download the Access file here.
Click on the link and follow the instructions to create a database using Microsoft Access. Creating an Access Database
To complete this assignment, follow the directions then submit your assignment. If you get stuck on a step, review this module and ask your classmates for help in the discussion forum. Open Microsoft Access to the Home page; Chose New Database: Choose from one of the ways to create a new database and select the New database option. Name ...
Practical Exercises Microsoft Access. 1. Create a new database, save it on the desktop and. 2. Create a Table in the School Database with the following: 3. Make the "ID Number" Field as the Primary Key. 4. Save the table as "Student's Table".
Start Microsoft Access and create a blank database by selecting "Blank database" from the list of available templates. Name your database using CS1100.LastName.A12 where LastName is your last name. Note the location of the database (remember the folder in which it was saved; most likely the Documents folder.) Lastly, click on Create to ...
Assignment: Create Queries for Access Database. Step 1: To view this assignment, click on Assignment: Create Queries for Access Database. Step 2: Follow the instructions in the assignment and submit your completed assignment into the LMS.
Learn what is Microsoft Access, a database management system that uses the Microsoft Jet Database Engine and comes as a part of the Microsoft Office suite. See how to create a database, table, query, form, report, macro, and module with examples and screenshots.
Learn how to use the Access Student database template to track and manage student information, such as emergency contacts, medical information, attendance, and more. Find out how to search, filter, show or hide columns, add pictures, maps, and reports, and customize the database.
Microsoft Access is a database management system (DBMS) that functions in the Windows environment and allows you to create and process data in a database. In Access, a database consists of a collection of tables. The rows in the tables are called records. A record contains information about a given person, product, or event.
Assignment: Create New Access Database. Step 1: To view this assignment, click on Assignment: Create New Access Database. Step 2: Follow the instructions in the assignment and submit your completed assignment into the LMS.
Today, to connect the application written in Delphi with the database, we need to install the Microsoft Access database engine 2016 driver. However, when installing the driver, it ends up conflicting with older versions of Microsoft Office, just as installing older versions of Microsoft Office ends up conflicting with the 2016 driver. ...
Azure Database Migration Service (DMS) Azure Database Migration Service (DMS) (General Availability) is a fully managed service designed to enable seamless online and offline migration from Azure Database for MySQL - Single Server to Flexible Server. DMS supports cross-region, cross-version, cross-resource group, and cross-subscription migrations.
This article describes update 5002633 for Microsoft Access 2016 that was released on September 3, 2024. Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016. It doesn't apply to the Office 2016 Click-to-Run editions, such as Microsoft Office 365 Home.
Assignment: Modify Access Database. Step 1: To view this assignment, click on Assignment: Modify Access Database. Step 2: Follow the instructions in the assignment and submit your completed assignment into the LMS.