Access Chapter 1 Simulation Training

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the process to add the name quick start fields in columns 3 and 4 in Data sheet view?

Click to add column, click 'more fields' button in the add and delete group, scroll down and below quick start, and click 'name'.

How do you add a record with a company name of 'Front Poach Construction'?

Type in the information and then click the bottom row when done to complete the task.

What steps do you take to set the column width to best fit for the company name column?

Click the company name column, go to the home tab, in the records group click more, scroll down to field width, and click best fit.

What is required to create a new table in design view with PermitID as the primary key?

Click create tab, in the tables group click table design, type PermitID and press TAB, assign short text data type, and click primary key. Signup and view all the answers

How do you add a second field named start date with the data/time data type?

Click the first empty field name cell, type start date, select date/time as the data type, set the format to short date, and type start date in the caption box. Signup and view all the answers

What are the steps to display the relationships window and add the permits and contractors tables?

Click the Database Tools tab, click the relationships button, double-click the permits table, double-click the contractors table, and then click close. Signup and view all the answers

How can you create a one to many relationship between the contractorID field in the contractors table?

Click the contractorID field in the permits table, drag it to the contractorID field in the contractors table, and select the Enforce Referential Integrity check box. Signup and view all the answers

What steps are necessary to create a relationships report and save it?

On the relationship tools design tab, click relationship report, click save, and confirm in the save as dialogue box. Signup and view all the answers

How do you change the data sheets font size to 10 and the font to Verdana?

On the home tab, click the font size arrow to select 10, and in the text formatting group click the font arrow to choose Verdana. Signup and view all the answers

What steps must be taken to set the data sheet row height to 15 points?

On the home tab in the records group, click more, then click row height, and in the row height dialogue box, type 15. Signup and view all the answers

How do you hide the contractor ID field?

Click anywhere in the contractor ID column, go to the home tab, click more, and then click hide fields. Signup and view all the answers

What is the procedure to display the permits table in print preview?

Click the file tab, then click print, and select print preview. Signup and view all the answers

How do you change the data sheet orientation to landscape and print it?

On the print preview tab in the page layout group, click landscape, then in the print group click print, and confirm in the print dialog box. Signup and view all the answers

What steps are involved in adding a second field name CompanyName with short text data type in data sheet view?

In the field names row of the second column, click 'click to add', select short text, type CompanyName, and set the field size to 50. Signup and view all the answers

Study Notes

Data Sheet View Operations

Add quick start fields in columns 3 and 4 by clicking "more fields" in the add and delete group, then select "name."
To add a new record, input "Front poach construction" as the company name, "Poarch" as the last name, and phone number as (805) 5557722, then click the append row to complete.
Set column width for the company name column by selecting it, navigating to the home tab, and adjusting to best fit via field width options.

Table Design and Field Configuration

In design view, create a new table by entering "PermitID" as the first field, assigning it the short text data type, and setting it as the primary key.
Add a second field named "start date" with a data/time data type. Set its format to "short date" and caption to "start date."

Relationships and Reporting

Access the relationships window via the Database Tools tab, adding the permits and contractors tables in order and closing all dialogue boxes.
Establish a one-to-many relationship between contractorID fields in both tables, ensuring to enforce referential integrity with cascading options selected.

Reporting and Formatting

Create and save a relationships report by clicking the relationship report option, followed by saving in the suggested format.
Change the font size to 10 and set the font to Verdana using the text formatting group on the home tab.

Data Sheet Customization

Adjust the data sheet row height to 15 points through the row height dialogue box.
Hide the contractor ID field by selecting its column and using the hide fields option in the records group.

Print Settings and Layout

Display the permits table in print preview by navigating through the file tab, print, and then print preview options.
Change the data sheet orientation to landscape in print preview, followed by executing the print command.

Additional Field Management

In data sheet view, add a second field named "CompanyName" with a short text data type, and change its field size to 50.
Save the newly created table as "Contractors" by selecting the field name, altering the size and executing the save command.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Test your knowledge with this set of flashcards based on Chapter 1 of Access simulation training. Each card presents practical scenarios to enhance your understanding of database management techniques. Perfect for students preparing for hands-on applications in Access.